Copying a database to a newer version of SQL Server
Home > IT Answers > SQL Server > Copying a database to a newer version of SQL ...
SQL Server Ask the Experts
2445 pts.
0
Q:
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?
ASKED: Aug 18 2008  7:01 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 BACKUP DATABASE and RESTORE DATABASE commands on the links provided.
Last Answered: Aug 19 2008  2:13 PM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   46795 pts.  |   Aug 19 2008  2:11PM GMT

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

 
0