Upgrade to SQL Server 2005

• am-244616

  SSCarpal Tunnel

  Points: 4936

  More actions

  November 5, 2008 at 3:52 pm

  #126793

  Guys,

  i am trying to move database from from sql 2000 instance to sql 2005, for this move I am planning to use detach from SQL 2000 and

  attach to 2005 process instead for backup and restore.

  Are there any issues with attach and detach process acorss different versions.

  Any suggestions and inputs would help.

  Thanks

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  November 5, 2008 at 4:25 pm

  #894577

  You can do that:

  http://msdn.microsoft.com/en-us/library/ms189625(SQL.90).aspx

  HTH,

  MJ

• CrazyMan

  SSChampion

  Points: 12560

  More actions

  November 6, 2008 at 6:14 am

  #894799

  Hmm you can do that unless you are fine with the down time 😀

• Kishore.P

  SSCrazy Eights

  Points: 8147

  More actions

  November 6, 2008 at 6:27 am

  #894809

  one of the best method to upgrade from SQL 2000 to 2005 is attach and detach the .mdf files.