EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

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 SQL Script Editor.
  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.