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.
I agree. I think a great feature would be to compare the results of two queries.