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 copy with the help of the Copy Database Wizard.
- Create copies of separate database objects by using the Duplicate Object Wizard.