Wednesday, February 13, 2008

Effortless migration of data from SQL Server 2005 to SQL Server 2008

It's so easy to transfer a database from SQL Server 2005 to SQL Server 2008. Well the same holds good from SQL Server 2000 to SQL Server 2008. Read on...

Moving database from SQL Server 2005 to SQL Server 2008 in three steps

SQL Server 2005 can be migrated to SQL Server 2008 quite easily by manually detaching the database from SQL Server 2005 and attaching it to SQL Server 2008. This is a much easier process than the 'Copy Database Wizard' which has two procedures one of which is the same as the manual process but carried out under the watchful guidance of a wizard and the other which does not require the stopping of the Source server.


NicoAtMicrosoft said...

Great information to have (and bookmark)! Does this work already with CTP5 or do you recommend waiting until RTM?
Nico del Castillo
Microsoft 2008 Joint Launch Team

Jayaram Krishnaswamy said...

This is in CTP5. I think it is the November 2007 release. The next one is CTP6 Feb 2008. I do not know how many more CTP's are in the works. Protection Status