DB SynchroComp compares two SQL Server databases, determining differences between them, and generates scripts that will change the target database structure to match the source database structure. After you execute the synchronization script, the two databases will have the same structure, and existing data in the target database will remain intact.
Database differences are shown graphically and in text. There is the possibility to select objects that are to be synchronized or to synchronize all objects (this is the default option). You can change some of the comparison options before comparing databases. After creating the synchronization script, it is possible to change it. Usually, there is no need for changing this script.
DB SynchroComp changes database structure only, not the data. You can not use DB SynchroComp to synchronize data in two databases. After synchronization of the database schemas, target tables will be populated with data that existed on target database before synchronization, except for newly created fields that can be either null, or populated with some default data that is generated by the program or by the user.
|