DB SynchroComp

DB SynchroComp screenshot

( click to enlarge )

DB SynchroComp compares two SQL Server (7 - 2005) 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.