Importing MS SQL 2005 Databases into MS SQL 2008 Databases
Print this Article
Last Updated:
August 21, 2017 9:39 AM
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
- Back up your 2005 database.
- Delete your 2005 database.
- Create a new 2008 database. We recommend using the same user name so you don't need to modify your scripts.
- 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.
