SQL Compare 15

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.

Didn't find what you were looking for?