Home > IT Answers > SQL Server > Copying a database to a newer version of SQL Server
SQL Server Ask the Experts
2,585 pts.
 Copying a database to a newer version of SQL Server
Copy Database Wizard, SQL Server database
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 accurate, or is there more to my issue than that?

Software/Hardware used:
ASKED: August 18, 2008  7:01 PM
UPDATED: August 19, 2008  2:13 PM
RELATED QUESTIONS
Answer Wiki:
SQL Express doesn't include the Copy Database Wizard. Backup the database, and restore it to the newer version of the SQL Server database engine. You can restore a SQL 2000 database to SQL 2005 or SQL 2008. You can read up on the <a href="http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-the-backup-database-command/">BACKUP DATABASE</a> and <a href="http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-the-restore-database-command/">RESTORE DATABASE</a> commands on the links provided.
Last Wiki Answer Submitted:  August 19, 2008  2:13 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,550 pts.