SqlDiffFramework for Windows

Name: SqlDiffFramework
Rating: 4.9 (1 reviews)
Author: Michael Sorens

Download now

Used SqlDiffFramework for Windows?

Developer’s Description

By Michael Sorens

Compare data from Microsoft SQL Server, Oracle, MySql, or ODBC.

Unique in database comparison, SqlDiffFramework compares live data or saved snapshots from any combination of SQL Server, Oracle, MySql, or ODBC data sources (Access, Excel, CSV files, etc.).Benefits: (A) 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!(B) Dramatically reduce your time and effort to find data discrepancies in your production or development databases.(C) Obtain peace of mind by quantifying differences between target data sets.(D) 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.Features: (A) SqlDiffFramework compares two data sources and highlights both row and column differences for just the columns you want.(B) Automate analysis by running any number of comparisons with one click.(C) Define connections to your data source with the powerful connection editor, be it Oracle, SQL Server, MySql, or any ODBC data source.(D) Get information about your data with the meta-query picker, such as finding which tables contain a column of a given name, what the primary keys of a table are.

Use SqlDiffFramework to compare: the same data over time on one server; the same data on two different servers; data from different platforms (e.g. SQL Server vs. Oracle). Use as a replacement IDE for a uniform experience across different platforms. It includes useful features you rely on in commercial IDEs (syntax-highlighting, command completion, search-and-replace, undo/redo), and some powerful features you may not find elsewhere: macro expansion, meta-queries, execute-on-load, multiple query executions/batch processing, formatting control, linked editors). And unlike a lot of free software, SqlDiffFramework comes with an extensive manual--over 150 pages.