Compare and synchronize data in databases

Last modified: May 28, 2025

This section explains how to compare and synchronize data between databases to ensure data consistency across environments. It includes instructions for setting up comparisons, mapping tables, views, columns, and schemas, defining comparison keys, and filtering rows. Topics also cover analyzing comparison results, handling mapping warnings, customizing comparison options, and managing synchronization processes.

In this section

Set up data comparison

Save and load data comparison documents

Map tables and views

Map columns

Map schemas

Set a comparison key

Filter rows included into the comparison

Mapping warnings

Data comparison options

View data comparison results

Generate a data comparison report

Synchronize databases

Exit codes used in the command line for /datacompare

Synchronization warnings

Synchronization error handling

Compare and synchronize data

Schedule database synchronization

Additional /datacompare arguments

Options used in the command line for /datacompare

Work with backup files

Known data comparison issues

Type compatibility table

Data comparison process overview

Data synchronization process overview