How do you export results from data compare? Can you export from the Row Viewer panel in the data compare results page?
There are 3 panels in the Data Compare results window. The top panel is the general compare job info showing source and target, and the number of results from the compare.
The 2nd/middle panel shows a full list of all records and columns. The view can be adjusted by clicking on the toggle buttons to disable or enable certain views to show the results. There is the option to "Export to Excel" in this panel.
To export, right click on the grid or click on the toolbar button.
Display options include:
- Show source only records
- Show different records
- Show target only records
- Show equal records
- Show conflict records
- Show columns where all values are the same in both tables.
- Filter option to specify further what you'd like to see or not see.
The bottom panel is the Row Viewer. This show the single row of columns based off the setting in the middle panel. This only shows one row at a time and shows all column values side by side. There is no export option in this panel.
An enhancement request CR101251 has been submitted to development for consideration in a furture release of Toad for SQL Server.
The enhancement request is for an export option in the Row Viewer panel to export results per row in that view.