OK I am using Visual Studio 2010 and have developed an ASP.NET 4.0 web application that is currently using a single MS SQL database. Can I get a suggestion as to the easiest way to deploy my application to this hosting site/server if I buy the Winhost Max service? My biggest concern would be the SQL database. Is there some automated tool that will create a schema file from my exisiting database that I can transfer to the server then use that to recreate the database on the server? How do I create a secure login username/password for my database on the server. Finally once my site is up and running how do I apply changes I may need to make to the database structure? By hand? or some other automated way? Or should I just load the (.mdf) file into my App_Data folder and update my connection string to use SQL Express and use Windows Authentication to open the database?
Try looking at this kb article. It explains about our Restore/Backup database feature in the Winhost control panel. Basically you will take a backup of your local database. Place the .bak file to our web server and use the tool to restore it to our SQL server. http://support.Winhost.com/KB/a771/how-do-i-generate-or-restore-a-backup-of-my-database.aspx
