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, Apex SQL Diff now supports DATA DIFFERENCES. No need to buy multiple products for Database structural AND data databases the Apex SQL Diff tool does it all.

Best of all the Apex SQL Diff tool 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.Apex SQL Diff is a software that make database comparison.

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.

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.

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 SQL software suite if you can accomplish this at Apex SQL.

This gives you a suite of proven tools with common interfaces to help perform all aspects of database monitoring and maintenance. Other company's database comparison "bundles" simply combine separate products that have the same features as our single database comparison offering.

Here are some key features of "Apex SQL Diff":

· Scripting and Merging exponentially faster
· Filter by Difference Codes (a powerful feature unique to the Apex SQL Diff tool)
· 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.


Requirements:

· MDAC 2.6(ADO 2.6) MSSQL Server v7 or 2000 MS SQLDMO Object Library (SQLDMO.DLL


What's New in This Release:

· Auto updater allows per file update (i.e. downloading and updating changed files only)
· Wrong data comparison for numeric keys
· Filtering by "Column" Diff Code doesn’t work for Views
· Objects with differences not from a Diff Codes stay hidden on any filtering operation
· Toolbar settings not saved between starts of the app
· Auto updater is enabled