Copy Database Wizard in SQL Server 2008

This task used to be a lot easier in earlier versions. Now you have more things to think and work on before you use the tool. SQL Server 2000 and SQL Server 2005 can be migrated. Now you can migrate logins as well.

Copying a database from an SQL 2005 Server to an instance of SQL Server 2008 is described using the Copy Database tool available in the SQL Server 2008. Procedure to create a proxy needed for this task is also described. The transfer method adopted in this article allows you to transfer chosen objects without stopping the source server. The transfer is painless as long as the security is not violated. Make sure you record the execution logging of the transfer as this is invaluable in the postmortem of failed transfers.

Read on and enhance your KB...

Copying a Database from SQL Server 2005 to SQL Server 2008 using the Copy Database Wizard

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.