Incorrectly UPDATING excluded tables

LittleColin · July 24, 2009 5:51AM

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 · July 24, 2009 6:40AM

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 · July 24, 2009 12:43PM

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 · July 27, 2009 9:33AM

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

gknierim · July 27, 2009 8:44PM

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 · July 31, 2009 10:49AM

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.

Incorrectly UPDATING excluded tables

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk