CompareData 1.4.3.105

You can retrieve some/all data for a table/view from two databases and compare the data visually to see differences highlighted on the screen. You can also compare data of two sql queries and dbms metadata. Features * Compare data between two tables/views of the same or disparate names * Compare columns having the same or disparate names and/or data types * Compare data of two sql queries * Synchronize table data at row level, table level or group level * Compare data of a group of tables/queries or all tables with one command * Compare resultsets of any size.* See comparing large resultsets * Compare dbms metadata for two tables or a group of tables including: columns, indices, primary key, foreign keys, triggers and table permissions * Compare stored procedures/functions * You can benefit any two comparable columns of two resultsets as the comparison key * Free, license is not required for comparing table/view data. New evaluation period is started with each new release. DBMS Support DB2, Firebird, EnterpriseDB, Informix, InterBase, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, Sybase Adaptive Server Enterprise, SQL Anywhere. Basic sustain for Access, Derby, DBISAM, Excel, MaxDB, Teradata, etc. See DBMS Notes. Requirements * Windows XP or higher * ODBC 3.5 compliant drivers to connect to the databases you want compare their data or a compliant ODBC-JDBC gateway and JDBC driver.