DB SynchroComp

DB SynchroComp is a powerful software that allows you to compare two SQL Server databases (7 - 2005) and determine the differences between them. The program then creates a synchronization script that will change the target database structure to match the source database structure. By executing this script, both databases will have the same structure, while preserving any existing data in the target database.


With DB SynchroComp, you can view database differences both graphically and textually. You can select specific objects for synchronization or choose to synchronize all objects, which is the default option. Before comparing the databases, you can also modify certain comparison options. Additionally, after generating the synchronization script, you can make changes to it although generally, no changes are needed.

One of the key features of DB SynchroComp is that it changes the database structure only, without affecting the data. After synchronizing database schemas, the target tables will be populated with data that existed on the target database before the synchronization process. However, for any newly created fields, you can choose to leave them null or populate them with default data that are generated by the program or by the user.

Overall, DB SynchroComp is an excellent tool for anyone who needs to compare and synchronize SQL Server databases. With its simple interface and powerful features, it can greatly simplify the otherwise labor-intensive process of maintaining database consistency across different environments.