Using the SQL Server 2005 database an my ISP

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?

newbiewebSr. Software EngineerAsked:
Who is Participating?
danrosenthalConnect With a Mentor Commented:
It will depend on the access level you have at your host. If you don't have full access, you may be able to send them the db file and have them manually attach it for you. I suggest calling your host and asking them for the best way to accomplish your goal.
newbiewebSr. Software EngineerAuthor Commented:
thanks.  I would certainly want to be able to do the attaching myself.  Glad I asked before I picked an ISP.

Can you suggest one where I would have control?
ina_donConnect With a Mentor Commented:
I think that your ISP must have a dashboard or an SQL Script execution interface that should allow you to execute the script to create the structures in your assigned database. I doubt they'll allow you to attach because the SQL server is most likely shared by many users. Just script your entire database and run the script to create it on the host site.
It will probably be much more expensive to have that level of control. I use GoDaddy and have no direct access to DB files, but boast a 100% data retention rate and will provide a backup DB file if you ask nicely.

If you find a better solution, let me know!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.