Dare to compare

"We have fully integrated ApexSQL Diff and ApexSQL Data Diff into our design, integration/ performance testing, and production release SDLC. The ApexSQL tools have tremendously increased our confidence level on the integration of these systems and the veracity of our product release cycles. ApexSQL DataDiff allowed us to proof test the automation of a ETL process against the long standing manual process that was in use in production, and when that system goes into full production, will save our company hundreds of thousands of dollars over the next few years, and millions in the years to come. "

William E. Saxon, Jr.
IT Consultant - Application Development
Nationwide Better Health

"I have to say, the purchase of Diff and DataDiff has to be among the best (if not *the* absolute best) investments my company ever made for our database needs. Our flagship product runs on each client's site against a series of databases - 4 to be exact; so when we add new functionality to the product we invariably have a fair amount of updates to one or more of these databases. We generally deploy our updates in small batches as soon as new features get out of QA so we never really needed to come up with an elaborate deployment scheme. We would simply generate a few SQL scripts to create or alter SQL objects and populate data as needed. All that changed recently. A major new update to our product was completed, comprising nearly two years worth of effort. Extensive changes were made to each of the four databases, with one of them more than doubling in size (amount of SQL objects). The changes were, of course, varied: new tables, stored procedures, entity relationships, rules, etc... as well as scores of updates to existing objects. Included among the changes were pre-populated lookup tables containing thousands of rows of data. Now we were faced with the challenge of how to deploy this beast. Could we write deployment scripts to update our existing clients? Of course. But how long would that take? Hours? Days? Sure, Enterprise Manager could generate the DDL to create our new objects, but it doesn't take dependencies into account; the manual intervention required to ensure our deployment scripts would create SQL objects in the proper sequence would only add to the overall time required. We were under an extremely tight deadline to deploy our changes so I tried the combination of Diff and DataDiff to apply our changes. Using a test server first, I used Diff to sync against my development server and was amazed to find that within MINUTES I had a completely sync'ed database. No searching for all of the objects I needed to synchronize, no update script to write, and no dependency order issues to worry about - Diff took care of everything for me! Best of all, it also provided me with an update script that I could save and archive in source control. Using DataDiff next, I was able to sync as much or as little of my data differences as I needed. I couldn't have asked for better results! Your tools literally paid for themselves the very first time I used them! I whole-heartedly recommend Diff and DataDiff to anyone with any serious SQL Server synchronization needs."

Rich Ackerson

"I compared your software with RED-GATE. I must say APEX is more user friendly ..."

Pankaj Sutradhar
Team Leader
Array Software Systems Pvt Ltd.