"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
"We are a startup HIS company that provides a hosted solution for hospital
Clinical Diagnostic Information. The requirements are such that we needed a comprehensive
Structure and Data Diff/Update tool for our sometimes complex updates. SQL Diff
and SQL Data Diff have been nothing short of miraculous in performing diffs and
providing upgrade scripts. Even a diffficult update with table,column and key name
changes showed a lot of intelligent programming went into these tools. Highly recommended"
ChartWise Medical Systems
"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
"Purely FYI - I looked at your product back in mid 2003 when it was branded
Lockwood rather than ApexSQL. Just had a look back at my summary of a comparison
I did then against Red Gate. Both products have obviously evolved since then but
I think yours has improved rather more, especially with respect to data comparison.
And for anyone interested in command line, data and metadata comparisons, you certainly
have an edge in value for money."
"I compared your software with RED-GATE. I must say APEX is more user friendly
Array Software Systems Pvt Ltd.
"I am with my third company using your ApexSQL tools.
Brian, over the years it I have always appreciated that you see and respond personally
to the Email & Forum traffic.
SQLDiff still rocks and splitting out SQL Diff Data was definitely a step in the
David M. Carpenter
Senior Application Developer
CareMedic Systems Inc.