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:

  1. 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 CheckBox 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 Execute Script.
  2. Create a database backup with the help of the Backup Database Wizard. Then run the Restore Database Wizard and select the RadioButton New database as a destination database.
  3. Create copies of separate database objects by using the Duplicate Object Wizard.