SqlDiffFramework

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

SqlDiffFramework Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Free
  • Price:
  • Free
  • Publisher Name:
  • By Michael Sorens
  • Publisher web site:
  • Operating Systems:
  • Windows 7, Windows 2003, Windows 2000, Windows Vista, Windows XP, Windows Server 2008
  • Additional Requirements:
  • .NET 3.5 Framework
  • File Size:
  • 761.05K
  • Total Downloads:
  • 332

SqlDiffFramework Tags


SqlDiffFramework Description

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.


SqlDiffFramework Related Software