Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

How to: View Data Differences

After you compare the data in two databases, you will see each database object that you compared and its status. You can also view results for the records within each object, grouped by status.

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.

To view data differences

  1. Compare the data in a source and a target.

  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



Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.