Comments
Sort by recent activity
Re PIVOT - I can't imagine using SQL Data compare without it! I'd happily go to the Uservoice to plead the case for adding it back into the newest release, but I don't now how to navigate to UserVoice. I use Pivot every time I do a SQL Data Comparison. First off, I pivot the results to see the fields showing differences - that tells me right away if I I've inadvertently included a column for comparison that varies from run to run and produces invalid exceptions. Also, I have a hypothesis of which fields SHOULD have changed and will roll thru the highlighted fields in the pivot view to see if there is any thing unexpected there. From that point I can dig in and start eliminating false breaks (float field comparisons, bad key setup, etc.) and also to eliminate comparison of fields that are NEVER different in the two sets, thus narrowing the results so that it both runs faster and true differences can be more easily viewed and investigated.
This was the BIGGEST help! I just found out about this because we hired someone new and I was training him on this tool. He'd gotten the new version deployed and that was where I took him first. Am recommending that he downgrade and I will not be upgrading to a higher version since this is gone now.
Please bring it back. I think the only reason you might have noted low usage is because maybe some people just don't know about it. Yes, it is worth the resources to include again. Thanks!!! / comments
Re PIVOT - I can't imagine using SQL Data compare without it! I'd happily go to the Uservoice to plead the case for adding it back into the newest release, but I don't now how to navigate to UserV...