: How to deploy ASP.NET application with MS SQL server database I want to deploy my website with MS SQL server database. It's my first time and I have never done it before. What I have come

@Bethany197

Well, you need the do following:


Find a hosting company that provides .net and MS SQL, which many windows hosting companies do
Create the database on your host using the panel that they provide
The panel should provide you with a connection string for the new database
Replace your current connection string with the one for the new remote database or use different web.config files, like web.local.config and web.live.config
Upload your website using VS or FTP
Open both your local database and the remote database (on your host) in VS and copy the table definitions - open the table definition of a local table select every row, copy, then paste the rows in a new table definition on the remote database
You can also copy all of the contents of the tables in the same manner


Then see if it worked.

Vote Up Vote Down