Moving MS SQl db from one server to another

[Bananaman]

Here is a good guide i found using the MS Publishing Wizard.

http://products.secureserver.net/products/hosting/PublishingWithDPW.htm

You will need to install this: http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

And this:

Microsoft SQL Server 2005 Management Objects Collection
X86 Package (SQLServer2005_XMO.msi) - 9529 KB

http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en
_________________
/Johnny

- Banana Hosting -
"The fun place to host your site"
http://www.bananahosting.com

[Bananaman]

If you cannot see your database when you login with SQL:

Apprently 'viewing' your database is a security issue for sql 2005 so it has been turned off.

1- If possible tell your SQL express which db you want to connect to, (as opposed to just logging in)

2- Use EMS SQL Manager Lite, which allows you specify which db to login to: http://www.snapfiles.com/reviews/EMS_MS_SQL_Manager_Lite/emsmssqllite.html
_________________
/Johnny

- Banana Hosting -
"The fun place to host your site"
http://www.bananahosting.com

[Bananaman]

I have been testing this for several users and here is what works best.

- Use Publishing Wizzrd to extra the db to an .sql file. Select the option 'compatible with SQL 2005'

-Use EMS SQL Manager LITE to connect to the db and 'Execute SQl from file" Finding that option is tricky, you need to go to Tools> SQL query and then click the open file icon.
_________________
/Johnny

- Banana Hosting -
"The fun place to host your site"
http://www.bananahosting.com