Apex SQLDiff

Apex SQL Diff is a server based, high speed database comparison tool that will analyze the differences in tables, procedures, views, users etc between two Microsoft® SQL Server© databases in seconds.

You will be able to visually observe the differences in the object's script shown side by side.  Apex SQL Diff also allows you to programmatically synchronize the databases based on the differential analysis.

With new version 2.x, Apex SQL Diff now supports DATA DIFFERENCES.  No need to buy multiple products for Database structural AND data databases - Apex SQL Diff does it all.  

Best of all Apex SQL Diff is fast - if will process the largest database in seconds, not hours, using server side comparisons that leverage the full processing power of SQL Server.

Check out the powerful new Command Line Interface!

Very Recent versions of ApexSQL Diff have introduced the following new features

• Linked servers no longer required.
• Large data diff performance improvements
• Full BLOB support for data comparison
• Command Line features were significantly improved to add switches for passing Options and Object Selections
• Command line added for data comparison
• Support for comparing and encrypting encrypted objects

Features

Version 2.32

• Command line for data compare added.
• Compare and synchronize Encrypted objects

Version 2.29

• Huge improvements in command line - ability to pass profiles for options and object selections. 

Version 2.27

• Data difference performance increase by factor of 14x!

Version 2.25

• Totally redesigned interface - Office Themes

Version 2.24

• "Ignore indexes" for comparing tables.

Version 2.23

• Ability to perform a pre-execution syntax check on Synchronization script directly from Apex SQL Diff editor
• Execute synchronization scripts directly from Apex SQL Diff editor

Version 2.19

• Option to Ignore Owner in structure comparison
• Linked servers no longer required for Structure Comparison
• Structure comparison performance gains 4x - 10x for some databases

Version 2.17

• Scripting and Merging exponentially faster
• Filter by Difference Codes (a powerful feature unique to Apex SQL Diff)
• Integration with GrigSoft Compare It!
• Blob datatype support for data compare
• Powerful HTML reports
• Data Merge
• Another performance break through - table comparisons 30% faster (15 Sept 2003)
• Support for Data differences at table and line level
• Generate scripts to merge databases
• difference reason codes.  Visually see what makes the sql objects different - permissions, checks, indexes, columns etc.
• Support for tables, views, procedures, rules, defaults, user defined datatypes, user defined functions, roles, users and file dependencies
• View script differences visually
• High performance database analysis - server side technology allows large databases to be processed in seconds
• Sort by Name, Owner and Type
• Grouped and non-Grouped grid supported

How does Apex SQL Diff compare?

• Compare Structure AND Data:  Apex SQL Diff is a complete solution that compares Database Structure AND Data.  Other products either offer no data comparison support or force you to buy 2 products to accomplish these two tasks.
   
• Difference Codes:  Apex SQL 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:  No need to pay for different products to automate your comparisons.  Apex SQL Diff includes a powerful command line interface that can accept profiles of Option and Object selections.
   
• Free Support:  At Apex SQL we don't charge support fees.  Some companies charge fees that can run as much as the software itself over only a few years.  All support is free. 
   
• Free Upgrades:  We don't charge upgrade fees - ever.  Unlike other companies that force you to pay to get the recent version of their software even if you purchased only 1 month earlier - your unlock code will work on all future versions of Apex SQL Diff.  Say "no" to these costly upgrade fees and make your purchase of Apex SQL Diff your last outlay for SQL comparison tools.
   
• Discounted in Bundled Software:  Apex SQL Diff can be purchased in a bundle of several other powerful SQL tools - why shop around to 5 or 6 different companies to purchase a complete value added SQL software suite if  you can accomplish this at Apex SQL with a single purchase and a big discount discount.  Other company's Database comparison "bundles" simply combine separate products that have the same features as our single database comparison offering.
   
• Best Price / Best Value: Apex SQL Diff offers tremendous value for the price when you consider it features BOTH Database structure and data comparison.  When factoring in support costs and functionality, Apex SQL Diff is less expensive for the functionality than any SQL comparison tool on the market today.

Awards

Free Add-on

All existing customers of Apex SQL Diff have been sent their free license to GrigSoft Compare It! commiserate to the number and type of licenses purchased.  Thanks from Apex SQL!

Click on this image to see clarity of Table script differences when viewed by Compare It!

"[Apex 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
Bell Mortgage
Proj Manager

"...  it saved me TONS of time, so thanks a lot for a great program!"

Robert Echten
Sr  Engineer
Sendo  Intl  Ltd.

Customer Comment

"I congratulate you on the decision and the approach of free upgrades for life as it is a rare opportunity to see that these days, when most other software companies want more and more money for the things we as users already paid for. I think that if you believe in your product it will speak for itself"

Vilko Poznovia
Database Administrator
Silver Chain
Perth, Western Australia

Order

We are a leading provider of value SQL tools for Microsoft SQL Server developers

Single Developer License - for only one SQL Server databases Developer

Site Developer License - for many SQL Server databases Developers

Home   More Software   More Apex Sql Products

  More Software     More Car Software   Excel Spreadsheets