Data Compare not working with system-versioned tables
stone
Posts: 10 New member
Data Compare not working with system-versioned tables. Comparison results are shown but they are incorrect.
Tagged:
Best Answer
-
stone
Posts: 10 New member
cperez, I have been incorrect in my assessment. The table in question has an int identity column as the PK, and I was not aware the prod and test were manually populated, instead of using the Data Compare to move the new rows from test to prod, and also that test and prod have never been in sync for this table. The new rows in test did show up under the "in both but different" tab due to the new PKs in test were already in prod. Thank you for your time. This was my 1st post to a Redgate forum and I am impressed with the helpfulness.
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?
Apologies on the delay, Yes, the explanation makes sense. I installed this version of SQL Data Compare locally in my environment, created two system-versioned tables named Department and filled them both with 5 identical rows of data.
My comparison in SQL Data Compare was accurate without any mismatches or errant data being show. Afterwards I added 2 additional rows to only one of the tables but they continue to show up nominally on my end.
Are you saying that the Test Database has 17 rows of data and the Production Database has 11 rows of data and when the comparison is performed you cannot see the differences?
Would you be able to share your logs from SQL Data Compare?