"Apex SQL Diff tools... time-saving, life-saving software.... I love it :)"
Ben Joyce
Fiat Group Automobiles UK Ltd
"Microsoft Great Plains is a database that has over 1000 tables and 11,000
stored procedures and a large amount of other objects contained in SQL. I have looked
at many different products to show the differences between the different versions
of GP and APEX sql, in my opinion was the fastest. Since their new changes to APEX
SQL diff they've even surpassed their own record in how long it takes to compare
the databases. I validate this because I didn't do an accurate timing 2 years ago
but I'm pretty sure the comparison has gone from 10-15 minutes down to less than
a few minutes. It's amazing how fast it really works! "
Jaydel Gluckie
.net Development Manager
Horizons International
"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
"
Martin Bradburn
Principle DBA
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
needs."
Rich Ackerson
"Thank you for the fine product your company delivers (ApexSQL Diff). I have
caused several companies to purchase this during my career as a DBA as I find it
to be the best at reconciling database structure, hands down. I have successfully
activated the software and as usual am extremely happy with the upgrade."
Chuck Fox
Blue Frog Solutions Inc.
"Thank you for all the help! After working with sqldiff for so many years it is
extremely encouraging to see your involvement in the direction of the products!
I still remember when I first started using proc-blaster(many moons and employers
ago)! The product line has come a long way since those days and I am encouraged
by the direction the applications have gone. :) With each release you have made
my life easier. :)"
Tom Bruinsma
Vice President - Integration Services
MicroLogix Information Systems, Inc.
"I have evaluated Apex Diff vs Red Gate tools and I would be most happy with
the Apex Diff product. I find Apex Diff smoother to operate, easier to use and it
is so fast."
Howard Rybko
Syncrony
"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
right direction."
David M. Carpenter
Senior Application Developer
CareMedic Systems Inc.
"Thanks! Great customer service! I really appreciate your help and quick response.
I had never used ApexSQL Diff before and in 5 minutes I had my scripts ready to
upgrade my other database with both new objects and data. ApexSQL Diff was very
intuitive to use and worked like a charm. I can't believe how much time I wasted
previously generating upgrade scripts by hand."
Tempe Lampe
Development Manager
Water & Gas AMI Solutions
"I just wanted to thank you both for all of your help--- particularly with
such short notice! I am looking forward to using your new products. The APEXSQL
Edit/Diff are some of the best tools in my arsenal. I assure you that your hard
work and sweat are much appreciated!"
David Hanson
RITIX Inc.
"First I would like to thank you for creating the most comprehensive and fully
featured SQL objects comparison tool I have ever used. I went through almost all
its features. I like it SO MUCH because one of the benefits of using this tool is
that it provides me not only high efficiency but also tremendous reliability to
the large database migration processes. I believe that the HIGH level of quality
and efficiency of doing database migrations with its help would NEVER be achieved
by any other means we used to utilize."
George Zhang
Board of Equalization, California
"I have been using ApexSQL Diff and absolutely love it. Fantastic product well
done."
Ben Jackson
Senior Developer
Sage Technology
"So far, ApexSQL is the only SQL diff program that actually works with SQL2005
CTE's in stored procedures."
Greg Gillis
Development Manager, Data Warehouse Analyst
Datamark
"Keep up the good work by the way, I'm using 2 of your products on a daily
basis. SQL Diff rocks."
Joris Laperre
DBA
Global Care Solutions (www.hospital2000.com)
"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."
Merlin McKenzie
Director
Centralis Limited
"Thanks for the feedback Brian - I have liked the UI and support for your product
[ApexSQL Diff] the best, I should be parting with my cash very soon...
Thanks for the support..."
Patrick McCarthy
Developer
JDA Software Group, Inc
"As your product offers the best set of features i've [sic] seen so far and
your customer-service has fully convinced me (couldn't be better ... keep it going
like this) i'd [sic] like to order a license of ApexSQL Diff"
Martin Schwier
Proj. Manager
WDT Datentechnik
GmbH, Germany
"SQL Diff paid for itself in the first hour of using it. I synced 12 different
databases to a common rev and man am I happy"
Casey Kirt
Project Manager
Bell Mortgage
"ApexSQL Diff is a great product. Keep on the good work."
Kris Gilot
Software Manager
OffiCom