Using the SQL Server 2005 database an my ISP
Posted on 2007-10-01
I assume I should:
1) create a database locally
2) detach the database
3) FTP it to my website
Then, how to I attach it to the database running at my ISP. I do not have a Windows Desktop associated with my website, instead I intend to use a cheap website. How do I detach the database from the website's SQL Server?
Once I have the database attached, then I need to create a connection string to it.
What information do I need from the ISP to connect to SQL Server? I presume that once I create a valid connection string I'll be able to connect to my database.
Do I have it right? What am I missing?