Data Compare comes with a free add-in for SQL Server Management Studio that allows you to compare and synchronize databases right from the SQL Server Management Studio Object Explorer.
The Data Compare add-in is bundled with the Data Compare tool. When you install the tool, the add-in will be installed too.
To compare two databases via add-in in SQL Server Management Studio:
1. In the SQL Server Management Studio Object Explorer, right-click a database you want to compare and select Set as Source from the Data Compare menu:
The dbForge Data Compare tab appears, with the database you selected as the source displayed in the leftmost pane:
2. You can select the database you want to set as the target in two ways:
To swap the source and target and databases, click the button.
3. Click the button to start the comparison.
4. Data Compare launches, displaying the New Data Comparison window, where you can configure the comparison options for your project.
The Data Compare SQL Server Management Studio add-in enables you to compare and synchronize Scripts folders.
To set a Scripts folder as the Source or the Target:
1. On the dbForge Data Compare tab, click to select Scripts Folder as a type of a source or target for database comparison.
2. Under the Database scripts folder click < Browse… > to specify a path to the Scripts folder you want to add to the comparison.
3. Click the button to start the comparison.
4. Data Compare launches, displaying the New Data Comparison window, where you can configure the comparison options for your project.