Copy Database Wizard
The Copy Database Wizard generates a SQL Server Integration Services (SSIS) package that can copy or move one or more databases from one server to another. If the database is moved to a server on the same network server, this is the premiere method. This method won't work to copy a database from SQL Server 2012 to an older version of SQL Server. In addition, destination server must have the SQL Server Agent running. If the destination server's SQL Server Agent is not running, the wizard will prompt you to start it. The Copy Database Wizard offers the most flexibility and capability. The wizard offers you one of two choices: The detach and attach method or the SQL Management Object (SMO) method.
Get Microsoft SQL Server 2012 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.