action plan for migration of Database from sql2000 server to sql2005 server with minimum downtime

• randeep_singh

  Newbie

  Points: 9

  More actions

  February 10, 2009 at 2:46 am

  #128674

  Hi all,

  We have migrated the database structure in test environment already. Now we have the challenge of porting all the changes as well as data in the new production sql2005 server.

  Can anyone please tell the action plan to be followed so that we can have the minimum down time.

• steve block

  SSCertifiable

  Points: 7698

  More actions

  February 11, 2009 at 8:03 am

  #942172

  There are three basic ways that I am aware of to migrate databases from 2000 to 2005:

  1) Backup the 2000 database and restore it on the 2005

  2) Detach the 2000 database and attach it to the 2005

  3) Create an SSIS package that will move the data from 2000 to 2005

  If you already have the structure moved, maybe all you need is SSIS to move the data.

  The detach and reattach method does provide a method to make sure someone is not updating the old database after the migration has been started.

  If you are looking for speed, test the various options.

  Here is a link to an article about migrating databases.

  http://www.sqlservercentral.com/articles/Administration/2987/

  Steve