EMS DB Comparer for SQL Server is a powerful utility for comparing Microsoft SQL databases and discovering differences in their structures.
Features: EMS DB Comparer for SQL Server is a tool for SQL Server database comparison and synchronization. You would be able to view the differences in the elements of the database. Once done, you could run scripts to eliminate the differences in all the items found or in selected items. The scripts would be generated automatically. This comparison of the databases can be done on databases that are resident locally on the same server or located on different server over the same network. As you navigate through the database objects you get a display of the corresponding script for synchronization. You can browse the differences in the form of a script or a grid. You can choose to do the synchronization step by step or all at one go.
You can moderate the synchronization script by changing the sequence in which they are executed. You have the ability to work on several compare projects at the same time and save or load the projects with all their parameters. It is possible to customize the working environment easily. Keyboard templates are available for editing the scripts faster. Using the console application gives you the choice of getting the syncing done automatically. The script editor has syntax highlighting to make editing easier. Latest SQL server versions are supported.
Overall: A nice and handy tool for database comparison and synchronization.