Unique in database comparison, SDF lets you compare live data--or saved snapshots--from any combination of SQL Server, Oracle, MySql, or ODBC data sources (Access, Excel, CSV files, etc.). Compare like-named or dissimilar tables or fields--now you can compare apples to oranges!

• Take the pain out of comparing apples to oranges. No need for a complicated recipe to export, transfer, and reconfigure data; define simple SQL query statements just once then run any number of comparisons with a single click!

• Dramatically reduce your time and effort to find data discrepancies in your production databases or development databases.

• Obtain peace of mind by quantifying differences between target data sets.

• Really see what your front end is doing by monitoring cause and effect: take a snapshot first, perform some action in your application, then see exactly what changed in your data.

Visual Comparison

(A) SqlDiffFramework compares two data sources and highlights both row and column differences for just the columns you want.

• Compare the same data over time (either current data vs. prior data or two snapshots of prior data).
• Compare the same data on two different servers.
• Compare data from different systems (e.g. SQL Server vs. Oracle).
• Verify two systems have synchronized data.

Automated Comparisons

(B) Automate analysis by running any number of comparisons with one click.

Connection editor

(C) Define connections to your data source with the powerful connection editor, be it Oracle, SQL Server, MySql, or any ODBC data source.

Meta-Query Selector

(D) The meta-query picker lets you quickly get information about your data, such as finding which tables contain a column of a given name, what the primary keys of a table are, etc.

• Expanded Feature List
• Articles by Michael Sorens