Online Documentation for SQL Management Studio for SQL Server
Running Database Comparer
EMS DB Comparer for SQL Server is an excellent tool for comparing SQL Server databases and discovering differences in their structure. A simple and intuitive GUI allows you to work with several projects at once, define comparison parameters, and alter modification scripts. Many other features make your work with our tool easy and fast.
DB Comparer for SQL Server provides you with an easy-to-use GUI environment: you can view all the differences in compared database objects and execute an automatically generated script to eliminate all or selected differences.
Additionally to the GUI version which is implemented in the form of a Wizard application, DB Comparer for SQL Server includes the console version which is intended for running from Windows command line with a template file name used as the execution parameter.
To run DB Comparer for SQL Server, click its icon or caption on the Desktop Panel and follow the steps of the Wizard. If necessary, you can click the Arrow-down button to open the menu allowing you to specify a template, and run the wizard/console with the template.