Compare data

dbForge Studio for SQL Server allows you to compare and synchronize data between databases and backup files. Key features include:

• Data comparison between databases and backup files.
• Intuitive result display for analysis and synchronization.
• Quick synchronization of source and target data.
• Asynchronous comparison and synchronization.
• Support for a command-line interface.

By default, data comparison is performed for objects with matching names and owners. You can use dbForge Studio’s automatic mapping feature or manually map objects, including schemas, tables, views, and columns, even when they have different names, owners, or structures.

The following tables and views cannot be compared:

• Invalid tables or views.
• Tables or views with inaccessible metadata.

Data comparison is usually based on a primary or unique key. If necessary, you can define a custom key. It is not recommended to use a non-unique key. If a table lacks a suitable key, select a custom key manually. For views, always define a custom key when the Compare Views option is selected.

Data comparison results can be saved to a file and reopened later for re-analysis.