SQL Data Compare 12.1 - Reverse Deployment Issue

rlrcstr

I opened SQL Data Compare and selected a couple of tables, ran the comparison and found the differences. I then cleared the items on the right (so they weren't deleted) and deployed. I then wanted to get the items on the right to the DB on the left, so I reversed the deployment direction. The app refreshed and showed the proper deployment direction, and the items that I had cleared were now checked, but the item count at the top was not updated. It still showed 0 of 4 items. And if I cleared an item, it shows -1 of 4, etc. Even with all 4 items checked, SDC complained that I hadn't checked anything and there was nothing to deploy. Refreshing the comparison did not help.

I have a screen shot, but I don't see a way to upload it for the post...

Thanks.

J

Jessica R

Thanks for your post!

I'm afraid I haven't been able to reproduce this so far with a quick test, but can I please check the exact 12.1 version that you are using (Help>About)?

Can you please also send your screenshot to support@red-gate.com with the subject "Screenshot for #84855"?

Thanks!

rlrcstr

Version and screen shot sent via email.

Jessica R

Thanks J, it looks like you're running into an issue we have logged as SDC-1425. I've added the details you shared to the bug report, thanks for these! We don't have a timeline for this as of yet, but I'll post any updates here.

Mark J

Hi there

We've just released SQL Data Compare version 12.4.4.4771 which contains a fix for a similar bug with the selected row count, and I think it might fix this issue as well - could you take a look and see if it helps? 12.4.4.4771 is currently available on Frequent Updates, so you might need to enable that (details here: https://documentation.red-gate.com/display/SDC12/Turning+on+Frequent+Updates )

Thanks,
Mark