Incorrectly UPDATING excluded tables

LittleColin

Using SQLDataCompare command-line, I am specifically including a subset of tables however I am getting UPDATE statements for tables not in my list.

The tables are explicitly wrapped in \[Tablename\] so should match exactly.

Note that SQL Data Compare 7 seems to work ok and the issue only seems to exist in SQL Data Compare 8.

Simon C

Hi LittleColin. Thanks for the bug report - I've managed to reproduce it on my machine. We'll be getting a patch release out ASAP to fix this. Apologies for the problems this causes

Simon

Simon C

I can confirm that this issue has been fixed in the 8.0.1 patch release. More details are available here. Please use Check for Updates from the Help menu to download it

Simon C

LittleColin

Fantastic, I can confirm it fixes my issue. Thanks for the fast turnaround.

gknierim

I have excluded 2 tables for sync however, when I look at the summary and script, it is still dropping and adding constraints for those 2 tables that are different but which I have excluded from the sync. Can someone please verify this issue?

Thanks,
Greg

Alice E

Hi gknierim,

Sorry you encountered this problem. We believe we have a build that fixes this issue. If you contact support@red-gate.com they should be able to give you more details.