DB SynchroComp compares SQL Server database schemas (versions 7-2005) and generates a script to align their structures while preserving data integrity.

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.
Version 4.0.1: SQL Server 2005 compatible: it is possible to synchronize SQL 7 or 2000 databases with SQL 2005 (using the subset of features supported by the older server version in the comparison process)
Version 3.4.0: - options for selective (by types) deletion of extra objects on destination side added