GoWebsite.com provides Domain Registration
Website Hosting, On-Line Shopping Carts, SEO
Blog Hosting, Email Accounts, Security Certificates,
Merchant Accounts & other Website Products.
Free setup! Speak with us anytime: 480-624-2500

• Windows-Based Databases
• MS SQL

Related GoWebsite.com Articles

• What are the Database Publishing Service and Database Publishing Wizard?
• What version of SQL Server is supported by the Database Publishing Service and Database...
• What should I be aware of when using the Database Publishing Service in the hosted environment?
• Limitations of the Database Publishing Service in the Shared Hosting Environment
• What does my Database Publishing Wizard error mean?
• Where can I get more information on the Database Publishing Wizard client?
• Publishing Objects Using the Database Publishing Wizard

Importing MS SQL 2005 Databases into MS SQL 2008 Databases

You can import MS SQL Server® 2005 database information into MS SQL Server® 2008 databases using the following steps.

To Import MS SQL 2005 Databases into 2008

1. Back up your 2005 database.
2. Delete your 2005 database.
3. Create a new 2008 database. We recommend using the same user name so you don't need to modify your scripts.
4. Restore your 2005 database information into your new 2008 database.

NOTE: After backing up or restoring databases, we recommend waiting at least 10 minutes to connect to it.