PRODUCT INFO
LINKS LOCALIZED DATASHEETS
TOP REASONS TO BUY
PRE SALES QUESTION?
ApexSQL Univ Studio
$1,999
All ApexSQL Tools with 1 yr Maint and all New tools Free for 1 yr. Click Here for more info.
ApexSQL Dev Studio
$999
All 7 ApexSQL Developer Tools - One Download / Discounted Price. Click Here for more info.
SALES FAQs
Killer Discounts
Unbeatable Killer Upgrades and Discounts. Click Here for more info.
ApexSQL Gear
Click Here for our ApexSQL Gear Store.
SUCCESS STORIES
Jerry Kurtz
OHIC Insurance Company
Wade Winningham
"I just downloaded the (new to ApexSQL) Edit tool, and it looks great. This should be a nice addition to the ApexSQL family, and fills an important gap. "
Michael Dorfman
Chief Technical Officer
Mercatus
Stephen Wynkoop
President
SQL Server Worldwide Users Group SSWUG.ORG
Lisa M Kirkeby
Web Designer/SQL DBA
BP
Lee Davies
Software engineer
Occam direct marketing
www.occam-dm.com
Compare your
SQL Databases in seconds - including BOTH Data and Structure.
Automate
Database comparisons with a powerful Command Line Interface (included
as a standard option)
Synchronize your databases
Integrate seamlessly into your
build process
ApexSQL Diff 2005 is a sophisticated database comparison tool that will analyze the differences in tables, procedures, views, users etc between two SQL Server databases.
ApexSQL Diff implements a state of the Art solution to the most complex database comparison scenarios including many unique features like Diff codes, RegEx object filters, Project Wizards and much more.
|
Product Information
|
|
)
)
)
)
)
)
)
)
)
)
)
)
- [NEW] All new database objects in SQL Server 2005 supported.
- [NEW] Synchronization Wizard for both Data and Structure.
- [NEW] Column level Data comparison.
- [NEW] New row level script difference viewer.
- [NEW] Advanced handling of owners in Synchronization script (include and exclude).
- [NEW] Owner Mapping in comparison.
- [NEW] Improved HTML Report for Structure and Data.
- [NEW] Improved XML Export for Data.
- [NEW] Significantly Improved Performance.
- Provides a sophisticated summary, hints and warnings about potential problems that may occur when running the synchronization script.
- Compare Structure AND Data: ApexSQL Diff is a complete solution that compares Database Structure AND Data.
- Difference Codes: ApexSQL Diff is the only product to offer visual clues as to the reason for the difference - other products force you to script the object first before determining what the difference is.
- Command Line interface: ApexSQL Diff includes a powerful command line interface that can accept profiles of Option and Object selections.
- Customizable, Office Themed Interface: The familiar Microsoft Office themed interface makes learning ApexSQL Diff simple. The fully customizable interface makes working with it extremely fast and comfortable.
- Sophisticated Command Line Interface included as a standard feature (not as an expensive add-in).
- Proprietary dependency parser that allows for more accurate ordering on scripts than if SQL Server’s own sysdepends table was used.
- Includes an integrated character (not line) level script difference viewer and also allows for shelling out to external Diff tools like Compare it! and Beyond Compare.
- Powerful HTML reports – both simple and complex variants. Including collapsible regions and allows for user customizable output.
- Unique Difference codes show a visual summary of the type of differences without having to look at the line level differences. ApexSQL Diff includes a powerful filter that leverages these Diff Codes.
- Includes an integrated editor that allows for viewing and even running scripts, saving having to shell out to QA or SSMS.
"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"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"Thanks a lot, you are the best tech support company I ever dealt with. Much better than Microsoft or other big names."
Daniel Liu
.NET Senior Consultant
Orange County Probation Department"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"I compared your software with RED-GATE. I must say APEX is more user friendly ..."
Pankaj Sutradhar
Team Leader
Array Software Systems Pvt Ltd."Thanks for the feedback Brian - I have liked the UI and support for your product 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"... In either case thanks for your help. One of the primary reasons I wanted to purchase your software was your unflagging support and friendliness."
Brian Schkerke
Lead Developer
NETCO, Inc."Thanks for your swift reply. I see that the move from LockwoodTech to ApexSQL has not done harm to the brilliant support I've always experienced from Brian."
Robert Echten
Senior Software Engineer
Sendo International Ltd."Thanks for the quick (and honest) reply. I am impressed. Your company sounds like its truly different from the rest ..."
Paul Barbin
DBA
Lewis, Inc."I must say that the support you offer your customers is the best I have come across in this industry to date. To think we very nearly paid to upgrade Red-Gate, our previous tool. ... we are certain we made the right choice. It was speed of the product that won in the end, but what a lovely surprise to find that the support was every bit as impressive."
Tracy Webb
Database Administrator
Misys Financial Systems Ltd"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