Monday, April 28, 2008

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

No comments: Protection Status