How to: View Data Differences

After you compare the data in two databases, Team Edition for Database Professionals lists each database object that you compared and its status. You can also view results for the records within each object, grouped by status. For more information about the status designations, see Overview of Comparing Database Data.

After you view the differences, you can update the target to match the source for some or all of the objects or records that are different, missing, or new. For more information, see How to: Synchronize Database Data.

To view data differences

  1. Compare the data in a source and a target. For more information, see How to: Compare the Data of Two Databases.

  2. (Optional) Do one or both of the following:

    • By default, the results for all objects appear, regardless of their status. To display only those objects that have a particular status, click an option in the Filter list.

    • To view results for records within a particular object, click the object in the main results pane, and then click a tab in the Records View pane. Each tab displays all records within that object that have a particular status: different, only in source, only in target, and identical. Data appears by record and column.

See Also

Tasks

Walkthrough: Comparing the Data of Two Databases

Concepts

Terminology Overview of Team Edition for Database Professionals

Other Resources

Comparing Databases