Migrating from SQL 2000/2005 to SQL 2008

1. Install the SQL 2008 client (note that you will not be able to use the SQL 2005 or earlier clients on a SQL 2008 database).

2. Order SQL 2008 addon in Control Panel (you will be charged a prorated fee corresponding to the amount of time left in your current billing cycle).

Proceed to the following steps after you have received the SQL 2008 activation email.

3. Optional: If your site performs frequent updates to the database, we recommend that you disable your site during this process to avoid losing data. You can do so using the stop/start tool in Control Panel's IIS manager.

4. Backup your SQL 2000/2005 database using the SQL Tools in Control Panel. Note the filename.

5. In the SQL 2008 Manager, use the SQL 2008 restore tool to restore the backup file that you just created.

6. Once the restoration is complete, the SQL 2008 database should contain all the data from your SQL 2000/2005 database.

7. Test several queries directly with your SQL 2008 client and make sure that your database has migrated properly.

8. Update your web application's connection string to point to the SQL 2008 server.

9. Contact our billing department to terminate SQL 2000/2005 service.

 

...Some good tips and links here:
Migration SQL Server 2000 to SQL Server 2008
http://blogs.technet.com/mdegre/archive/2009/07/21/migration-sql-server-2000-to-sql-server-2008.aspx

 

The steps outlined are perfect.

In fairness, it should be pointed out that terminating the SQL 2000/2005 service will not result in a credit to your credit card, but rather a credit towards future purchases.

So you will be on the hook for the incremental charges for the balance of the billing period.

marc

 

Also note, this migration information also pertains to SQL 2008 R2.

 

Same for SQL 2000 to SQL 2005 ?

Hi

Is it the same migration procedure to go from SQL 2000 to SQL 2005?

Thanks
albanello

 

HI albanello. Yes, you will want to use this procedure.

 

Thanks Billy Shears

Thought so just wanted to make sure.

Thanks again
albanello