Copying the structure of a database
Published 26 June 2013
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.
- Synchronize 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.