I've been working in TOAD data point 5.0+ 64 bit on Windows 10 with 64 bit Office 365, and while the data compare is working great within the application, I am having some problems when exporting the data compare results. This is a problem as we would like to use the exported Excel files to share compare results with users who do not have TOAD Data Point, and save them as documentation.
There are currently 2 major issues with the data compare export files:
1.) Data compare exports (Excel files) do not function well if larger than 50-100k rows, and freeze Excel if larger than 400-500k rows.
I tried using the data compare on a table that has 500k+ rows X 80 columns and the compare works fine in TDP, however if I export this to Excel it locks up my excel application upon opening this file in Excel. RAM use will climb to about 8gb until Excel just becomes unresponsive. It appears to be a problem with the formatting causing a lot of strain on Excel as if I take a smaller file and clear formatting , it becomes much more responsive. I was also able to get the 500+k row file to allow me to select all data , and paste values to a new workbook. This new workbook was working fine until I then tried to paste formatting from the original data compare export , at which point both Excel instances froze. So it would appear the formatting may be causing a large strain on Excel for files with a lot of rows. Clearing the formatting would render the compare files almost useless as being able to filter by color is what makes these so very useful.
2.) When doing a data compare, if either the option for "Ignore whitespace" or "treat empty values as nulls" is enabled, the data compare export to excel causes EVERY string to be highlighted in purple as a "difference". This is not seen in the GUI, and the compare results are displayed correctly in TDP. It only occurs when exporting the compare with one of these options enabled. This essentially makes exporting a data compare result using these options unusable.
Aside from the above issues, it would perhaps be an item for the idea pond that TOAD data point offers other options for exporting data compare results. Excel is good for smaller comparisons but doesn't work (currently) for large comparisons. It will also have a limit to 1 million rows making it impossible to save a comparison result of 1+ million rows.