Getting started with SQL Data Examiner

Comparing and synchronizing the content of two databases is easier than you think. You’ll learn how in this short, step-by-step tutorial.

1. Start a new comparison

Start a new comparison

To start a new comparison, simply click the “New” button, located on the toolbar, or select File » New in the File menu.

2. Choose data sources

Choose data sources

In the window that appears, type in or select the database server, the authentication method and the names of the first and the second databases.

If the databases you compare are on the same server, select the “Both databases on the same server” option so that you don’t have to type the login name and the password twice.

Click “Next” to continue.

3. Select tables, key columns and columns to compare

Select tables, key columns and columns to compare

Select the tables you want to compare and the key column(s) necessary to match the records in the compared databases. Specify a unique index in the drop-down list if there are any such indexes, or select the custom key. By default, the program selects the primary key column(s) as the key column(s).

If no key columns have been chosen, when you click “Compare” the application will remind you to choose a key column.

Now you can select the columns to compare. By default, all columns are selected, but in the drop-down list you can deselect the ones you don’t want to compare.

The “Select All” button allows you to select all the tables in the list. You can click the “Select None” button to clear the checkboxes. The “Clear Wrong” button deselects all the tables for which the key column hasn’t been specified.

Click “Compare” to continue.

4. Review the comparison results

Review the comparison results

When the comparison process is complete, the results are displayed for you to review.

The differences in the rows are color coded:

  • Black for tables that have identical content in both databases;
  • Grey for tables that have some different records;
  • Blue for tables that have some records in the first database that are missing in the second; and
  • Green for tables that have some records in the second database that are missing in the first.

5. Select the records to synchronize, and run the synchronization wizard

Select the records to synchronize, and run the synchronization wizard

Selecting a table activates the right panel of the dialog box. It displays the following tabs:

  • The “Identical” tab displays the identical rows in the compared tables;
  • The “Different” tab displays rows with different content. Such tables must be synchronized in order to be identical;
  • The “Only in DB1” tab displays rows in the first database that are missing in the second database; and
  • The “Only in DB2” tab displays rows in the second database that are missing in the first database.

Select the tables or rows you want to synchronize, and click the “Synchronize…” button on the toolbar.

6. Select the direction of synchronization

Select the direction of synchronization

In the wizard’s first step, you will be asked to select the synchronization direction. Choose the database to be changed.

You will also be prompted to create a backup of the database that will be changed. We recommend that you back up your target database before synchronization.

Click “Next” to continue.

7. Select the options you need

Select the options you need

In the second step you can select the options you need. By default, all four options are selected.

You can find detailed descriptions of these options in the program’s Help file.

Click “Next” to continue.

8. Review the planned changes

Review the planned changes

In the third step you can review a summary of the planned changes and the script that will execute them.

Click “Next” to continue.

9. Run the synchronization

Run the synchronization

On this step, you can specify what actions should be performed on the synchronization script: execute the script, save it or send it to an external application. If you want to review the results of the synchronization, check the “Compare databases after synchronization” option.

Then click “Execute” to perform the specified actions.

10. Synchronization is complete

Synchronization is complete

Click “Finish” to close the “Synchronize” window.

11. Review the final results

Review the final results

Synchronization has been completed successfully.

  • Product: SQL Data Examiner
  • Edition: All
  • Version: All

Related Articles

Getting started with SQL Examiner

Data comparison and synchronization: Supported sources

Do not see what you are looking for?
Please submit a support request