Take the 2-minute tour ×
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.

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 to know from my googling is that I must have a domain(.com/.net/.co) and a host(for my web pages .aspx & .cs(confusion here if I can also deploy my database)).

Now, I am not getting to where I have to deploy my database. If I also have to buy a seperate SQL Server database or a host consisting of every thing (means I can deploy both my ASP.NET application & database as well).

share|improve this question

migrated from webapps.stackexchange.com Aug 7 '11 at 9:35

This question came from our site for power users of web applications.

add comment

1 Answer

up vote 1 down vote accepted

Well, you need the do following:

  1. Find a hosting company that provides .net and MS SQL, which many windows hosting companies do
  2. Create the database on your host using the panel that they provide
  3. The panel should provide you with a connection string for the new database
  4. 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
  5. Upload your website using VS or FTP
  6. 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
  7. You can also copy all of the contents of the tables in the same manner

Then see if it worked.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.