Copy Database Wizard

Error message in the Copy Database Wizard in SQL Server 2005

I am attempting to make a copy of a database using the Copy Database Wizard in SQL Server 2005, but I am receiving the following error: TITLE: Copy Database Wizard ------------------------------ The action you attempted to perform on a remote SQL Server instance failed because the action requires...

Copying a database to a newer version of SQL Server

I have a database on my SQL Server that needs to be upgraded to SQL Server 2005 or SQL Server 2008, but when I try to copy it with the Copy Database Wizard, I do not have the option “Copy” listed under “Tasks”. I am using SQL Server Express, which I think may be my problem. Is this...

How to Modify SSIS packages created by Copy Database Wizard in SQL Server 2005

Hello, I recently read Jeremy Kadlec great article titled, "Step-by-Step Guide: Migrating to SQL Server 2005 with Copy Database Wizard" at http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1194265,00.html. Question for anyone: I used the wizard to copy 12 databases from ServerA to...