CompareData 1.6.1 build 125

CompareData 1.6.1 build 125 is designed to be an intuitive and helpful Windows cross-dbms application with which you can visually compare and synchronize data between two SQL databases using ODBC drivers. You can retrieve all/some data for a table/view from two databases and compare the data visually to see differences highlighted on the screen. You can also compare the data of two SQL queries.

Major Features:

1. Compare data between two tables/views of the same or different names
2. Compare columns having the same or different names and/or data types
3. Compare data of two sql queries
4. Synchronize table data at row level, table level or folder level
5. Compare data of a group of tables/queries or all tables with one command
6. Compare resultsets of any size.
7. Compare schema for two tables or a group of tables including: columns, indices, primary key, foreign keys, triggers and table permissions
8. Compare stored procedures/functions
9. Command line or internally schedule comparisons and data synchronization
10. Multi-threaded, multicore-ready design. Native 64-bit version is available. 
11. Free for comparing table/view data. New evaluation period with each new release.

Enhancements:

• Add support for date/time interval data types. Currently only Informix and Mimer SQL ODBC drivers return ODBC-compliant results for interval data types
• Add support for Replace/Replace All to text editor find dialog
• Add Make Uppercase and Make Lowercase commands to advanced edit menu
• Add Comment and Uncomment Selection commands to advanced edit menu
• Add support for scheduling/running folder-level generate sync script command from the command line
• Work around MaxDB 7.07.06.09 ODBC driver issues to allow using driver for comparing data
• Display status message, progress bar and busy icon/hourglass when logging all pending messages on clearing messages due to task start since if there is a large number of pending messages to be logged, the UI thread will not be responsive until all pending messages are logged; allow user to cancel logging remaining unlogged pending messages by presssing Esc key.
• Display line numbers for messages view by default
• Display echoed sql statement text with original line end characters in messages view
• Log echoed sql that result in error to appear before error details in log
• Remove comments when executing MS Access script (Access driver does not support comments when executing sql)
• Fix possible crash with deallocating statement maps used in synchronizing data
• Account for data sources that are not transaction capable when synchronizing data (Advantage StreamSQL ODBC driver, for example)
• Do not use parameter bind offsets when synchronizing data if data source supports parameter bind offsets but not for prepared sql (Oracle ODBC driver) to allow using prepared sql for better performance.
• Fix bug with columns 1/2 all filtering where comparison has not been performed
• Add tooltip detail to comparison row, column and object counters
• Use theme font for application owner-drawn text or default font for Windows classic
• Unlink table column comparison from data comparison to allow refreshing table column comparison directly without having to refresh table data comparison.
• Use Windows Explorer theme for workspace tree on Windows Vista and above
• Add Open File command to query and script editor
• Add *.txt and All Files (*.*) filters to text save as dialog filter
• Do not stop fetching rows on fetch error when in worker thread to allow retrieving rows that can be fetched with no error
• Add Fit Headers command and update fit command accelerators to use Shift modifier to signify all columns
• Rename settings Dec (decimal digits) column to Scale
• Add middle mouse button click accelerator to close tab command
• Fix issue with detaching owned windows (properties grids, etc) on destroying owner window rather than when owner window is detached from main tab ctrl
• Remove space between progress percent done number and percent sign
• Fix bug with editor selecting too little/too much text on Find Next when searching using regular expression; add Look In dopdown to Find dialog to allow search in selection, if any, or entire document.
• Update Fit commands accelerators from Y to I since Ctrl+Y is used by text editor for Undo command
• Do not search hidden text when using Find/Find Next commands
• Update text component from Scintilla 1.74 to 2.02
• Add Repository Info command to application status bar context menu to allow hiding repository information from application status bar. Append repository info to UI thread state icon when connected to application repository and repository info is not displayed on the application status bar
• Remove num lock, scroll and caps indicators from the application status bar and add Ln/Rw and Col panes for displaying current line/row and column for text editor or list display that currently has focus.
• Extend File | Save command to saving where clause, query or script without necessarily checking the sql for the item in contrast to Check SQL command
• Fix crash with exploring/opening New1/New2 where resultset info for New1/New2 item is cleared previously incorrectly when parent comparison has no items
• Add Exclude from Updates counter to main properties column counters
• Move item schedules properties to their own properties tab
• Fix crash where data source connection keep limit is zero and dataobject is constructed with transaction
• Fix bug where synchronize items data scheduler task uses FK constraint/Existing Rows default rather than user updates properties
• Fix bug where tooltip is displayed only the first time for cells on the same line
• Display cell text and corresponding cell text for difference cell tooltip text
• Display cell text and original cell text for pending update cell tooltip
• Fix bug with determining comparison default key where a comparison eligible unique index is not used if comparison has primary keys but primary keys are not usable
• Log item(s) error message when comparing columns at folder level and item(s) were not retrieved due to errors
• Use bold rather than semibold font for main tab current item label and overridden properties attributes
• Fix issue with Sybase generate sync script and error getting column data type literal prefix/suffix due to SQLGetTypeInfo and transaction
• Fix bug with copy/generate sync sql and duplicate quoting of string initial value
• Fix bug with initial value for matched ignored column to require stamp for insert
• Fix bug with setting stamp indicator for a matched column on refresh settings/matching column

Requirements:

• Windows XP SP3 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.