Schema Synchronization

DbSchema holds its own image of the schema, independent from the database. This image is saved to project file.

Schema Synchronization means to compare and apply the schema changes in the database or in the local project.

This allows to create the same schema over multiple databases or to upgrade the production databases to the development schema. During schema synchronization you can view the differences and choose for each of them an action: change in the project or in database. For each difference the SQL script can be generated.

Database Schema Synchronization

Deploy the Development Schema

It's a common practice to develop an application in the development team and deploy the latest version on production servers. During migration the production databases has to be migrated to the latest development schema. DbSchema may help during this step. Load the development schema in DbSchema, connect to the production databases ( one by one ) and do Schema Synchronization. At this step you will get the differences. Each of them can be merged in the production database.

Share the Schema Project in a Team

DbSchema project file is an XML text file. It stores the schema definition and the layouts. This file can be integrated into SVN. Schema changes will be updated in the latest schema version.

From DbSchema you can do a schema compare between the opened project file and another file. This means you can do a schema diff between two application versions even without connecting to database.

Convert Schema Rdbms

DbSchema allows to convert the schema to a different database. Converting schema means to fix the data types, constraints. The schema scripts will be generated in the new database language.

Manage Schema on Multiple Databases

Schema Synchronization allows to compare schemes between different databases. Since the DbSchema project holds its own image of the schema, your project will be database-independent. The project file can be opened on any computer, even without connecting to database.