Copying the structure of a database
Published 10 December 2025
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.
This documentation contains proprietary information and is protected by copyright law.
Copyright © 2026 Red Gate Software Limited. All rights reserved