Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Work with Data > Compare Differences in Data

Compare Differences in Data

You can compare result sets from the current editor or a different editor in the Database Explorer's Data tab or the editor's Result Sets without having to save one of the sets to a file.

Notes:

If you want to synchronize data, use Data Compare instead of the Data Diff Viewer.
You cannot modify files in the Diff Viewer at this time.

To compare differences

Right-click data in the Editor's result set or Database Explorer's Data tab and select Compare To | Set_number.

You can also save a result set and later use it as a historical comparison.
Use the Diff Viewer toolbar to view any differences.

Tips:
- To switch the contents of the left pane to the right pane, and the contents of the right pane to the left, click .
- You can also open files to compare by clicking beside the drop-down list at the top of each pane.