Schema Comparison and Synchronization Overview

Last modified: November 2, 2023

dbForge Studio gives you a perfect opportunity to compare and synchronize schemas with many useful features. They include the following:

• Comparing and synchronizing of two schemas or a schema and a database project. Note, you can’t compare and synchronize two projects.
• Schema comparison separates objects existing only in the Target or Source database, identical objects, and ones having the same name, but with different structure.
• Schema comparison results are displayed in a convenient document, easy for analysis and synchronization.
• Schema comparison is asynchronous. Based on your needs, you can stop it in any moment.
• Schema comparison includes object description. When any errors occur during description, error notifications are shown. You can either stop or retry comparison, or ignore the errors. In case of fatal errors, schema comparison is automatically stopped.
• You can quickly synchronize the Target schema with the Source one or export a schema synchronization script.