Copying the structure of a database
Published 13 December 2022
You can use SQL Compare to copy the structure of an existing database to a new database.
To copy the structure of a database:
- Use your SQL application to create the new database.
- Create a project that compares the existing database, scripts folder, backup or SQL Compare snapshot with the new database.
- Run the comparison on the project.
- Select the database objects that you want to copy.
- Deploy the databases.