Add support to export comparison results to MS Excel
Can we please get the ability to export the contents of the SQL Data Compare results window (containing the rows with differences) to Excel, complete with the cell formatting seen in the application? I.e. headers for fields with differences in bold, cells with differences highlighted a different colour, etc.
This functionality exists in SQL Prompt (exporting from SSMS, admittedly without the formatting) so surely should be possible from Data Compare also?
Even better would be to be able to do this for all tables/subsets selected in the list of tables above the results window (i.e. all the data included by the boxes ticked).
Context:
I use data compare a lot to analyse the impact of changes to code while developing - it provides a convenient way to do row-by-row comparisons without having to write the queries to identify the differences myself. However, where the product falls down in my opinion is the ability to export these results to a file where they can be used for further analysis. I have tried the CSV export and found it to be less hassle to write queries myself, to get something I can easily use.
I am happy to discuss this with a member of the RedGate team. Thank you.