DB SynchroComp compares two SQL Server databases, determines differences between them, and generates the script that will change the target database structure to match the source database structure. After you execute the synchronization script, two databases will have the same structure, and existing data in the target database will remain intact.

Database differences will be shown graphically and textually. It is possible to select the objects that are to be synchronized or to synchronize all the objects (this is the default option). You can change some of the comparison options before the comparison of databases. After creating the synchronization script, it will be possible to change it. But usually, there will be no need to change this script.

DB SynchroComp changes the database structure only but not the data. After the synchronization of database schemas, the target tables will be populated with the data that existed on the target database before the synchronization, except for newly created fields that can be either null, or populated with some default data that are generated by the program or by the user.

DB SynchroComp features:

1. Copes with the object dependences successfully without relying on the sysdepends table; instead, it operates according to its own algorithm.

2. Dtects all new fields, which do not allow null values and the generation of the sync script will not be possible without defining them first.

3. Connection Manager – helps you to organize your connections; to classify Microsoft SQL Servers into groups, divide groups into subgroups etc. It has a history of connections for recomparing the databases without reentering the connection parameters.

4. Etremely simple user interface.

5. Reliable and lightning fast!

SQL, MS SQL, Compare, Synchronize, Database, Collation, Structure, Script, Tool, Differences, DB SynchroComp