DBDiff Ver. 5.0 Release Notes The following are the changes that DBDiff has gone through since Ver. 1.0: Ver. 1.0: Original Release. Ver. 1.1: Bug: Sort was incorrect when first field in tables was numeric Status: Fixed Bug: Broken link in Help file Status: Fixed Ease of use: Start screen maximized Status: Done Ver. 1.2: Bug: Word wrapping on extremely long lines did not break "nice" Status: Fixed Ease of Use: Disable not applicable buttons on control panel. Status: Done Feature: Context Help Status: Added Ver. 1.3: Bug: When saving a file and disk ran out of space, DBDiff did not recover Status: Fixed Ver. 2.0: Feature: Ability to exclude columns by patterns. Status: Added Feature: Ability to ignore leading and trailing spaces in data. Status: Added Ease of Use: Add more indexes to on-line Help Status: Done Ver. 3.0: Feature: Comparison of indexes. Status: Added Feature: Incremental/Automatic report saving Status: Added Feature: Process all tables or only those owned by user Status: Added Feature: Process data types as ODBC standards or DBMS specific Status: Added Ease of Use: On-line help revised to include description of features and troubleshooting Status: Done Ease of Use: If ODBC returned error, DBDiff would report and terminate execution Status: Now DBDiff reports and continues except when fatal error encountered. Bug: Sometimes could not connect to SQL Server Status: Fixed Bug: Saving on some machines failed apparently at random Status: Fixed Bug: When using Oracle's ODBC driver and the advanced options, DBDiff would "hang" Status: Fixed Bug: Restoring cursor statuses after DBDiff was stopped on Windows NT failed occasionally Status: Fixed Ver. 3.1: Feature: Create report directly to file Status: Added Ease of Use: Press enter to add new pattern and stay in pattern field (Advanced Columns Options) Status: Done Bug: Cannot retrieve column information on DB2 type databases when table... Status: Fixed Ver. 3.2: Ease of Use: Show previous columns in Columns to ignore (Advanced Options) Status: Done Ease of Use: Show previous tables marked for skipping in Advanced Structure Options Status: Done Ease of Use: Help file updated. Status: Done Bug: Report correct message when there are no columns to select from DB Status: Fixed Bug: Tables marked for skipping were erased on next run if no advanced setup was done for next run. Status: Fixed Bug: Too much memory consumed by index comparison Status: Fixed Ver. 3.3: Feature: Automatic detection of special named database objects Status: Added Feature: Ability to compare numbers by value and not by representation Status: Added Feature: Ability to ignore seconds and fractional seconds when comparing date/time values Status: Added Bug: Some special characters caused a problem when retrieving data Status: Fixed + See above feature. Bug: Float representation across databases sometimes caused differences to be shown when non existent Ease of Use: On-line help updated Status: Done Ver. 3.4: Feature: Include in report tables with identical structures Status: Added Feature: Include in report tables with identical data Status: Added Bug: Some numeric fields were being truncated at display Status: Fixed Ver. 4.0: Feature: Compare views and views data Status: Added Feature: Compare procedure definitions Status: Added Feature: Save settings for retrieval on next run Status: Added Feature: Create and load configuration files Status: Added Feature: Command line run Status: Added Bug: Retrieval of unwanted tables in SQLServer/DB2 Status: Fixed Bug: Spelling mistakes in help file Status: Fixed Ease of Use: Added user name to database name Status: Done Ease of Use: Updated Help Files Status: Done Ver. 4.1: Bug: Character truncation on long data fields Status: Fixed Bug: Installer failed to create entry in Start Menu Status: Fixed Feature: Multi-user database auto detection Status: Now DBDiff automatically identifies and handles such databases Feature: Ability to save report in RTF format Status: Added, now report can be saved preserving the colors. Ease of Use: Added server name to database name Status: Done Ease of Use: Updated Help Files Status: Done Ver. 5.0: Ability to select owner/catalog/schema to be processed Ability to compare subsets of data by adding conditions to the data retrieval Window size and position are now restored Bug in display of length in report when LONG fields where used. Fixed problem validating license under some versions of Windows when not installing in drive c:. Window size and position are now restored. Changed status bar to reflect database colors for ease of use. Ability to change the report's font Ability to change the report's syntax highlighting colors Ability to print a report. DBDiff now shows which config file you are using and allows for save as well as save as Ability to compare the resulting data of 2 free form sql select statements Ability to rerun last compare with a single click Significant performance improvements when comparing large amounts of data Connection errors are now properly displayed. New tools menu to access other DKG tools. Fixed truncate of column names in report headers. Ability to create database snapshots to compare off-line databases, or track historical changes. Fixed problem with automatic treatment of special names. DBDiff now "remembers" which tab in advanced options was last used. Configuration files are now "editable" ASCII files. Ability to output data compares in CSV friendly format. Changed copyright information. Ability to create Executive Summary report. Added right-click menu for easy access of functions. Redesigned Control Panel user interface for ease of use. Fixed keyboard focus when entering columns to ignore. Ability to ignore columns based on data types. Help is updated and in html format.