Online Documentation for SQL Manager for SQL server
Create a database copy
In order to create a copy of the whole database or of separate objects you can:
- Extract DB objects structure and data into SQL script using the Extract Database Wizard. The result script can be used to copy or restore your database. If the Generate CREATE DATABASE statement option was not checked while customizing script options then you need to create a database before performing the extract script. It is better to execute a script from file using the SQL Script Editor.
- Create a database backup with the help of the Backup Database Wizard. Then run the Restore Database Wizard and select the New database as a destination database.
- Create copies of separate database objects by using the Duplicate Object Wizard.