Compare and synchronize data in databases
Last modified: July 22, 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 schemas
- Map tables and views
- Map columns
- Set a comparison key
- Filter rows included into the comparison
- Mapping warnings
- Data comparison options
- Veiw 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
Was this page helpful?
Want to find out more?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.
Request a demo
If you consider employing this tool for your business, request a demo to see it in action.