Using Visual Diff


Visual Diff allows to compare files or results from queries, procedures or any other valid SQL statement which can be executed on different servers. To get meaningful results when comparing data You have to consider couple of things. Results should have identical number of columns, do not include volatile columns like timestamp and columns  should be sorted in a same order if possible.

 

Visual Diff offer Quick Diff option. To use this option just do one of the following: select text in Editor or Result grid and drag / drop it to "Quick Diff" toolbar button on the main menu.

After you do it twice Visual Diff screen will open automatically displaying difference. Also right click popup menu in Editor and Result grid has an option to execute "Quick Diff"