DB Upload/Create Question

Topics: Developer Discussion
Apr 25, 2007 at 4:48 PM
I have read various posts here regarding problems getting the SQL scripts to run without error. I have never used them to set up my site because I don't know HOW to use them with my host. My host has a shared DB server running SQL 2005 and does not allow remote access. This is the procedure I used to create the DB file. Please tell me if there is a problem using this method.

1. Created an empty DB on server using Plesk admin tools provided by host.
2. Assigned a user and password to new DB.
3. Used SQL Express on local machine to make a backup of ClubDB.
4. Logged into remote DB server using DB admin tool provided by host.
5. Restored empty DB from .bak file created in step 3.

Most things seem to work, but I'm starting to wonder if creating the DB this way rather than using the SQL scripts can create any problems.

Apr 25, 2007 at 10:13 PM
Nope... should be the same. This is probably the better way to do it... some people are having some problems with the generated scripts.
Apr 27, 2007 at 9:56 PM
I would like to suggest that you take a look at the SQL Server Database Publishing Toolkit for Web Hosting. You can read a little about it here http://weblogs.asp.net/scottgu/archive/2007/04/19/update-of-sql-server-database-publishing-toolkit-for-web-hosting.aspx

This might solve other users problems as well.
Apr 28, 2007 at 4:19 PM
I am using that... that's the problem. It creates these really long scripts.