RedGate SQL Compare OR Lockwood Tech ApexSQL
What tools do you guys use to ease the nightmare of keeping multiple instances of SQL Server databases synched?
Happy customer of SQL Compare here.
We bought ApexSQL Diff because it's base price was significantly less expensive than Red-Gate's bundle and did the same thing - compare structure and data. When factoring in free support/upgrades we save another $140 I believe. Although red-gate "claims" to be the fastest product - our tests on physically separate servers showed ApexSQL to be slightly faster on structure comparison and much faster with data comparison.
I have used both products and have to resoundingly recommend RedGate. I've been a RedGate user for over 2 years now and have been shipping production DBs patched by their "differential engine" without a single issue.
These marketing threads are getting fairly imaginative now. Maybe we should start a thread of products to avoid due to the phoney marketing.
I have tried both products and decided that ApexSQL Diff is more qualitative than SQL-Compare. The decision is a consequence of one fact: ApexSQL-diff produces the script for synchronizing with much less errors than SQL-Compare produces. I don't consider the number of options as a quality coefficient. What profit of bicycle with square wheels even if it has the gilded handle bar?
Weee, care to explain why ApexSQL Log ("transaction log read utility" that you mention) is "bad, bad, bad"? As ApexSQL Log Project Leader I'm very interested in some concrete examples of why do you find it lacking in quality. Thanks in advance.
I don't know about sql compare tools but if red-gate's is as good as their bloated, obsolete and overpriced ($10,000) bug tracking tool - Aardvark - i would run, not walk, to any compeitors tool. Most likely the red-gate shills hang out on Joel's forum to learn how to build a good bug tracking system like fogcreek.
Fog Creek Home