sql 2005 to 2008 user databasees

• sri2015

  SSCrazy

  Points: 2780

  More actions

  November 2, 2012 at 6:27 am

  #264983

  Could we migrate user databses with Attach/Dettach method from SQL Server 2005 to SQL Server 2008

  (Ex:Dettach Database from SQL Server 2005 and attach in SQL Server 2008)

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  November 2, 2012 at 6:41 am

  #1555437

  Yes dettach attach is a supported migration path, just remember that once it is done it cannt be undone.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736494

  More actions

  November 2, 2012 at 9:42 am

  #1555558

  Look at FOR ATTACH in here. It says that you can attach earlier versions: http://msdn.microsoft.com/en-us/library/ms176061.aspx