Data Compare not working with system-versioned tables

Data Compare not working with system-versioned tables.  Comparison results are shown but they are incorrect.
Tagged:

Answers

  • Hi Stone,

    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
  • stonestone Posts: 3 New member
    version 15.3.6.25729 Professional

  • stonestone Posts: 3 New member


    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?
Sign In or Register to comment.