Migrating from 2000 to 2005

• VastSQL

  SSC-Dedicated

  Points: 36144

  More actions

  January 14, 2009 at 12:03 pm

  #133629

  Hi Experts,

  Can anyone please provide some documents or ideas on migrating database from SQL Server 2000 to 2005.This is for the purpose of giving a project plan.

  TIA

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  January 14, 2009 at 12:17 pm

  #926829

  depends... you doing an in place upgrade or moving from one server to another...

  How are you planning to do it? Detach - re-attach? Backup and Restore?

  To help us help you read this[/url]For better help with performance problems please read this[/url]

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  January 14, 2009 at 12:54 pm

  #926870

  Check these:

  http://msdn.microsoft.com/en-us/library/ms144245.aspx

  http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

  There are also lots of articles on SSC about upgrading and migrating from SQL 2000 to SQL 2005. Just use the search function at the top of the page.

  Greg