- or
3 results found
-
Provide support for custom comparison queries
While browsing the improvements, I notice a whole set of ideas centered around the ability to filter data, providing support for data types that may have changed between stages in the database lifecycle (development to QA to production for instance), and the ability to filter columns, changing column names, etc.
All of this could be supported by providing custom SQL query support in SQL Data Compare.
The tool should provide for a custom comparison query for the source and destination table.
19 votes -
Run SQL Queries and compare results
We have a scenario where table ‘abc’ in database1 is split to new tables ‘def‘ , ‘ghi’ and ‘jkl’ in database2. It is very complicated to map the tables, columns and choose a stable primary key to verify the new tables with the old table.
And so we need to be able to join the tables to generate the data to verify old and new tables.It would be very nice to have a feature to run the query for database1 and query for database2 and compare the results.
14 votes -
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…
11 votes
- Don't see your idea?