This topic describes how to use the Copy Database Wizard to upgrade a SQL Server database to a later version.
When using the Copy Database Wizard to upgrade a database, adhere to the following requirements:
Connect to any instance of SQL Server Database Engine using Object Explorer in SQL Server Management Studio.
Expand Databases, right-click a database, point to Tasks, and then click Copy Database.
Complete the steps in the wizard.