Setting databases in SSMS

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.

Comparing databases

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:

SSMS set as a source

The dbForge Data Compare tab appears, with the database you selected as the source displayed in the leftmost pane:

SSMS compare pane

2. You can select the database you want to set as the target in two ways:

  • Right-click a database in the Object Explorer and select Set as Target from the Data Compare menu.
  • Drag a database you want to set as the target from the Object Explorer to the Target section of the tab.

To swap the source and target and databases, click the Swap button button.

3. Click the Start comparison button 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.

Comparing a Scripts Folder

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.

Scripts folder as a type

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 Start comparison button 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.