Sorry to hear you are having issues with system-versioned tables in SQL Data Compare. System Versioned tables should be supported, could you confirm which version of SQL Data Compare you currently have installed?
Additionally, do you have a screenshot or example of the results being incorrect, I will need some more context in order to troubleshoot locally in my environment.
cperez, as I cannot show company data this is the best I can do. In the image above, TABLE_A is the system-versioned table in the production database, and when the table is compared to the same table in the test database I do not see the extra 6 rows in the "Only in right" tab (prod on left, test on right). Make sense?
Answers
Sorry to hear you are having issues with system-versioned tables in SQL Data Compare. System Versioned tables should be supported, could you confirm which version of SQL Data Compare you currently have installed?
Additionally, do you have a screenshot or example of the results being incorrect, I will need some more context in order to troubleshoot locally in my environment.
Best Regards,
Redgate Support
cperez, as I cannot show company data this is the best I can do. In the image above, TABLE_A is the system-versioned table in the production database, and when the table is compared to the same table in the test database I do not see the extra 6 rows in the "Only in right" tab (prod on left, test on right). Make sense?