SQL Compare 10

Copying the structure of a database

You can use SQL Compare to copy the structure of an existing database to a new database.

To copy the structure of a database:

  1. Use your SQL application to create the new database.
  2. Create a project that compares the existing database, scripts folder, backup or SQL Compare snapshot with the new database.
  3. Run the comparison on the project.
  4. Select the database objects that you want to copy.
  5. Deploy the databases.

Alternatively, Red Gate offers SQL Packager, which will script the structure, and optionally the contents of a database. You can create a .NET executable file or C# project, which will enable you to create the entire database.


Didn't find what you were looking for?