November 24th, 2011New:
· Identify Microsoft Access 2010 data sources
· Identify Microsoft Excel 2010 data sources
· Add script column as create, add, drop, modify, rename, etc to supported DBMSs
· Add script primary key as create, drop, etc to supported DBMSs
· Add script index as create, drop, etc to supported DBMSs
· Add script user table as create, drop, truncate/delete for most supported DBMSs
· Add Clear Key settings command
· Add support for using currently selected column items for open item commands
· Add support for saving selected column items as documents
· Add support for generating sql insert/update script for Oracle where sql string literal is longer than 4000 characters
· Add Fixed Char option to generate sync script right trim options
Fix/Update:
· Fix MS SQL Server numeric() identity and decimal() identity column view data type name for create column
· Fix DB2 clob, blob, dbclob, for bit data displayed column data type for create column
· Fix Firebird blob displayed column data type for create column
· Switch Primary Key/Index view order
· Restore focus to script as dropdown when it gets re-enabled if dropdown has focus and the script as selection has not yet been scripted (gets disabled) and focus did not change
· Fix crash on script column as xml where table has identity column but there is no template for selecting identity column info (SQLite, Access)
· Update script constraint as name from create to add
· Account for 'begin tran|transaction|work' when parsing sql statement
· Implement workaround for Ingres ODBC driver not returning PK_NAME column in resultset description for SQLPrimaryKeys when table does not have a primary key
· Save hidden lines due to folding on saving text view text
· Move Settings submenu to bottom of parent context menu
· Fix issue with save item file name where item key has large number of trailing spaces
· Fix disabled copy of text for synchronized but not yet re-retrieved item
· Add workaround for MySQL ODBC driver 3.51.29 returning 0 instead of 10 for SQL_DESC_NUM_PREC_RADIX for SQL_DECIMAL and SQL_NUMERIC causing crash due to incorrect column size reported by driver
· Add workaround for MySQL ODBC driver 3.51.29 returning data max length instead of column size for SQL_DESC_LENGTH for character/binary columns
· Display specific data type name for MySQL tiny, medium, long text/blob
· Fix displayed data type name for Postgres longvarchar varchar column
· Add fix for MySQL column default retrieved from information missing literal prefix/suffix
· Fix issue with second list getting its horizontal scroll position reset on row filter
· Fix performance issue with comparing Sybase triggers
· Add KEY_WOW64_64KEY to opening registry machine key to allow using same site/enterprise license entry with 32-bit version of the app running on 64-bit Windows
· Omit constraint name when scripting add foreign constraint where constraint is system-named
· Ensure generates sql sync script summary is ordered alphabetically by table name
· Return table, system table, and view for Sybase table types as Sybase ODBC driver does not return any table types
· Add application shortcut icon to desktop on installation
· Include prebuilt Firebird repository database with installer to allow using the application after first install without having to create the Firebird embedded repository from new database
September 3rd, 2011New:
· Add statement separator option to user scripts
· Maintain focus on main tab view change; set initial focus for main tab views
· Add history to main tab view (Back/Forward)
· Add script trigger as commands to script trigger as create/drop/enable/disable as applicable for supported DBMSs
· Add support for copy/save text as JSON
· Add support for copy/save text as XML
Fix/Update:
· Update embedded Firebird 32-bit client to version 2.0.6
· Update Postgres trigger resultset to use 9.0 tgconstraint rather than 8.x tgisconstraint
· Fix mismatch in integer/big integer for column size for x64
· Fix bug with clearing item default script, if any, on editing pre/post update scripts
· Clear user message filter, if any, on starting repository wizard action
· Remove product version from installation folder and Start Menu folder
· Fix issue with changing main view on main tab selection change
· Fix JavaScript iframe error writing comparison as html for Chrome
July 26th, 2011· New
· Update included Firebird ODBC driver to version 151 (fixes issue with using embedded repository on x64 Windows)
Fix/Update:
· Fix issue with combined sql sync script file having BOM before the start of merged part files where part file is unicode
· Fix invalid cursor state error when synchronizing SQL Server data and table has an after trigger causing a pending resultset to be generated for the insert/delete/update by SQL Server
· Increase limit for dynamic columns from 128 to 256 on x64
June 11th, 2010New:
· Add SQLite compare trigger support
· Add support for hosting application repository on Apache Derby
· Add support for reseeding identity column when synchronizing data
· Add Scripts 1/Script 2 views and output script statement results to messages view
Fix/Update:
· Fix issue with IBM DB2 ODBC DRIVER returning no rows for Derby table types
· Fix crash opening Find/Replace window when there is a rectangular selection
· Add support for Informix Serial8/Bigserial (ODBC data type SQL_INFX_BIGINT)
· Fix crash sorting rows where row selection is incorrectly kept but now for place-holder row(s)
· Warn on driver check/support for row bind offset max one time per run (Excel ODBC driver)
· Check for cancel while retrieving long data in parts to account for drivers that return SQL_NO_TOTAL for SQLGetData causing the application to take a long time to retrieve large long data
· Release SQLGetData temp buffers on reaching end of resultset/error/cancel
· Account for Oracle 64-bit ODBC driver incorrectly returning (SQLINTEGER) -1 instead of (SQLLEN) -1 for SQLRowCount when determining number of rows affected by sql statement
· Fix out of memory error on clicking DBMS dropdown toolbar button caused by using the same key for 32-bit and 64-bit DBMS comparison MRU lists when 32-bit and 64-bit version of the app are used on the same machine
· Check for reference count when user deletes a script
· Fix bug with changing query side/where clause and explorer/non-explorer tabs are open for the item
· Add Refresh support to queries and where clause comboboxes
· Draw non-editable properties text item as disabled text
· Add option to draw login ID icon in item title and add tooltips to item title fields
· Fix grid tooltip where tooltip does not appear for cell or adjacent cells
· Increase DB2 repository script text column CLOB size from default 10M to 100M
· Fix issue with disappearing Excel udpates due to code path that skipped calling ::SQLDisconnect before freeing connection handles
· Do not allow column that is part of comparison actual key to be excluded from updates until pending key column changes are applied and column is no longer part of the comparison key
· Display comparison sides horizontally by default; update initial app window size/position to fit better on screen
· Display column size in column comparison as unsigned number
· Display column size instead of blank in settings view for long text and long binary
· Fix text editor default line ending from LF to CR/LF
· Update workspace tree ctrl to use Windows default text font
· Identify ITTIA DB and Empress data sources
· Fix bug with DBMS MRU list sometimes deleting first item
· Fix bug data source set up DSN combobx is not restored to last new item
· Update repository wizard to run tasks in worker thread
· Process message queue messages while opening more than one item in main tab so application would not appear non-responsive on Windows 7
· Add Alt+D shortcut to access item bar (combobox/edit) for an item
· Add workaround for MS SQL Server ODBC driver returning incorrect info for update/delete rule for foreign key constraint where the rule is set null/set default
· Add workaround for Oracle ODBC driver returning delete rule null for foreign key constraint defined with delete rule set null
· Use default system font for sql, xml and text views
· Update Oracle stored procedure list resultset to exclude TRIGGER from all_source (Oracle 11)
· Call close query on closing comparison root
· Fix possible crash on disconnecting/changing repository when there are active tasks
March 25th, 2010New:
· 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
Fix/Update:
· 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
November 30th, 2009· New
· Update UI to be dpi-aware to allow using application on higher than 96 dpi setting without scaling in Windows Vista/7
· Update application to use the system ANSI codepage rather than ASCII (US-en) codepage. Application now supports ANSI database objects that use locale's code page extended characters in their name.
· Add Rows Per Insert Statement option to generate sync script options to allow scripting multiple rows in one sql insert statement
· Add accelerators for item view commands
· Add support for generating sync script at folder level
· Fix/Update
· Add support for storing license info at local machine registry key (Site/Enterprise licenses)
· Allow disabling application automatic check for update at the machine level registry entry
· Update generate sync script/save updates as and folder level synchronize titles to display target data source server name
· Fix issue with possible deadlock/skipping last item when synchronizing folder items and last item is already active
· Update messages pane workspace item link click behavior to open item in its own tab rather than open item in explorer tab
· Update generate sync script combined file ordering of sql statement to (insert, update, delete) instead of (delete, insert, update) to be the same ordering as synchronizing data at folder level using multiple passes.
· Add persistent command to hide application menu (like IE8) to maximize vertical display space available for user data
· Do not display shutdown status image in application status bar for shutdown scheduling
· Update accelerator for Close All DBMS Comparison command from Alt+Shift+W to Ctrl+Alt+W because Windows uses Alt+Shift key binding by default for switching between input languages where user has more one language enabled in regional settings causing the alt key to appear as not working due to inadventently switching input languages on composing the old accelerator key stroke
· Add popup menu to application toolbar/status bar areas to allow hiding menu/toolbar/lower tab/status bar
· Make show application statusbar option persistent
· Add End of Line option to script constraints as options dialog
· Use CR/LF instead of LF for script constraint as command XML output line end
· Use CR/LF instead of LF by default for line end for generate sync script command and add End of Line option to generate sync script command
· Use CR/LF instead of LF to terminate messages view lines
· Handle/warn about end of string characters in sql literals when generating sql script
· Fix bug with displaying LF replacement character instead of end of string replacement character for unicode column
· Fix display not immediately refereshed on Show Null command
· Update NULL display to display instead of Ø
· Update html help style sheet to use relative font sizes; add Forward and Font buttons to html viewer toolbar
· Show Items view Canceled, Error counters only if counter is not zero and counter is not part of row filter
· Fix bug where items view subtask gets canceled by opening and closing the subtask item in a new tab and then closing the new tab.
· Add tooltip support to owner-draw grid cells whose text is not completely visible
· Add progress column to items view
· Add command line option to mirror UI to provide some support for right-to-left locales
· Use .sys.sql_modules instead of .syscomments for retrieving SQL Server 2005/2008 triggers and stored procedure text. Add support for SQL Server Azure.
· Fix issue with SQL Server 2K join not including constraint catalog/schema when getting fk constraint status
· Add Compare Filter Items command to items view
· Add Recompare command to main tab/list context menu if recompare is applicable
· Add Show In Folder command to message log file link commands
· Fix bug with saving updates progress count not being rolled back on rolling back update to last commit point
· Add Filter On command to items view
· Fix severe UI performance issue with inline comparison where buffer size is very small and there are many rows to keep
· Update items view sync items task to not start items that have already been compared and have no differences and their objects were discarded unless restart option is checked
· Update generate sync script preview and script dialog to dismiss dialog by pressing the escape key if script task is not active, otherwise escape key is used as an accelerator to stop the script task; Add Esc accelerator to script as tool window
· Fix issue with script/script as dialog where toolbar may not get updated automatically to reflect the end of script execution
· Use worker thread to cancel executing sql to avoid locking up UI
· Update testing for Caché ODBC 3.5 driver
· Fix possible crash refreshing tables comparison where a new item is open and its parent New1/New2 item is not open
August 7th, 2009New:
· Add Script Constraint As command to FK comparisons to allow scripting constraint(s) as create, drop, enable, disable (as applicable) and XML for most databases
· Add exported foreign key comparison view to table views
· Add support for comparing Ingres 9.2 column defaults, sequences, stored procedures and rules
· Add support for comparing Pervasive SQL 10 triggers and stored procedures/functions (long metadata V2)
· Add support for hosting application repository on Ingres 9.2
· Add Count Unique Differences settings command to count unique differences for a comparison column. Display unique differences for a column, if any, following the differences count in the column header and properties row summary. Display first few unique differences in tooltip for unique differences counter and for a difference value.
· Take into account foreign key constraint disabled status when determining depedencies for synchronizing folder data for DBMSs that supported disabling foreign key constraints (MS SQL Server, Oracle, DB2 and Informix IDS)
· Add inherited foreign key constraint handling option to updates properties to allow user to ignore foreign keys, disable/enable foreign keys as necessary (MS SQL Server, Oracle, DB2 and Informix IDS), or drop/re-create foreign keys as necessary for most other DBMSs where foreign key is self-referential or is part of a dependency cycle.
Fix/Update:
· Update workspace sort order to place user folders at the end of sorted workspace items
· Fix Sybase folder-level metadata comparison error due to transaction in catalog function call
· Allow copy and add to workspace commands for selected metadata detail rows
· Fix delay (Working) in starting virtual folder metadata comparison due to initializing virtual items
· Account for Ingres ODBC driver returning table types in lowercase
· Replace CR/LF when saving comparison as html with line break tags
· Fix incorrect text for folder list popup menu Cut menu item
· Fix issue with displaying procedure source code for overloaded Informix and PostgreSQL procedure/function
· (internal) Group registry entries for repository wizard by data source number or dbms code
· Remove filtered counter(s) from properties grid and replace with displaying number of filtered items in grid group header
· Add self reference column to foreign key comparison resultset
· Set Active as the default row filter for items view compare/synchronize tasks
· Fix inconsistent ordering of items view synchronize task items where items belong to more than one schema
· Execute 'ALTER SESSION SET cursor_sharing=FORCE' on connecting to Oracle 10 and above when using DataDirect driver (in addition to Oracle ODBC driver) to improve catalog function performance (does not help DataDirect driver with exported FK).
· Fix issue with display not getting updated on ignore/unignore object command
· Fix issue with removing but not deleting comparison root from workspace on deleting one its data sources
· Allow opening comparison root by double-clicking on its item in workspace. Update double-click behavior for workspace items to expand/collapse item rather than open item is a new tab if the item is a user folder or virtual folder
· Fix issue with where clause not displayed for explorer tab due to create on demand
· Fix issue with header text and type info tooltip not appearing on seperate lines occasionally
· Do not lock comparison settings when recomparing column data due to comparison setting change
· Do not add row to pending inserts when inserts are disabled for a data comparison side but all rows were selected (some eligible updates) and then sync left/right command is invoked.
· Do not execute sqlforeignkeys to determine dependencies when synchronizing folder data and data source does not support SQLForeignKeys (MS Access ODBC driver, for example).
· Fix bug with missing some fk constraints when determining dependencies for synchronizing folder data
· Fix bug where difference column numbers has not changed due to comparison key change recompare and the old difference columns displayed in main properties are not refreshed
· Fix issue with garbled grid display on first open of resizable grid parent dialog
· Use separate file for x64 application check for update
· Update application minimum OS requirement from Windows XP to Windows XP SP3 since application now uses msxml6
May 13th, 2009New:
· Add Ignore Object command to allow excluding objects from items view and folder-level metadata comparisons where the objects are not of interest but pass the main comparison name LIKE pattern filter.
· Add messages history and filter to messages view and display workspace items as links in messages view.
· Add native support for 64-bit Windows. 64-bit version of the application is now available in addition to 32-bit version. See x64
· Add search support to items view and add filtered counter. Add close button to search box
· Add mini toolbar to main tab with Active Tabs button and Close button
· Add Up One Level command
· Add foreign key enabled/disabled status for MS SQL Server, Oracle, DB2 and Informix foreign key comparison resultset
· Add basic support for hosting application repository on Informix IDS 11.5 (non-ANSI)
Fix/Update:
· Fix possible memory leak determining items eligible for restart on synchronization
· Change default to display schema name for object name where object schema name is the same or different; display titles at top rather than at bottom by default and not side by side and don't display title item icon.
· Support using DataDirect Oracle ODBC driver for hosting application repository on Oracle
· Display progress ctrl for repository wizard actions
· Fix bug with not removing scheduled task from inactive/shutdown maps on detaching schedule
· Use separate saved row filter for items view synchronize task
· Fix incorrect text alignment for SQL_TINYINT
· Warn about using unsupported MySQL 5.01.05 and earlier MySQL 5.x drivers
· Update Firebird embedded dbms to version 2.0.5
· Update Firebird ODBC driver to build 148. Firebird ODBC driver build 148 dll name has changed to odbcfb.dll whereas in build 142 of the driver the dll name is odbcfb32.dll. If you have a previous build of the Firebird ODBC driver (such as build 142 from a previous CompareData release) the Firebird build 148 installer does not remove the older odbcfb32.dll from the Windows system directory and you must update any Firebird ODBC data sources you have previously set up to use build 148 by making no change edit to the ODBC data source using ODBC Administrator. No change is needed for CompareData internal data source to use the odbcfb.dll instead of odbcfb32.dll.
· Improve performance of initializing items in items view for Firebird repository
· Fix performance issue populating virtual folder where folder is already expanded
· Fix bug with incorrect application exit code on command line run exit
· Do not clear repository data source on failing to connect to repository executing command line run.
· Disable user prompts if the application is started with -m command line option (minimized to Windows notification area for internal scheduling) or as a run command (external scheduling) except for commands executed directly by the user from the UI.
· Allow using single or double quotes to quote command line arguments
· Include repository, if data source is used as repository, and DBMS comparisons connection counts when displaying number of current connections to a data source in the data source edit dialog
· Fix unnecessary sorting of virtual folder on contents row filtering
· Fix Select All for New 1/New 2 contents view
· Use the number of client machine cpu cores when determining the initial default value for items view max threads property.
· Add Copy command to counters context menu
· Add error checking for failing to create windows due to user opening large number of main tabs since Windows application default limit is 10,000 user objects.
· Create windows on demand, if possible, to allow user to open more main tabs and use less Windows user object handles
· Add Close Tabs To The Right and Close All But Explorer Tab commands to main tab context menu
· Open tab next to current tab rather than at the end of tabs if tab is being opened from a main tab
· Clear DBMS comparison open state when closing by Close All DBMS Comparisons command
· Fix possible crash with populating virtual folder due to recompare
· Get Informix column defaults from system catalog
· Fix locking issue where virtual folder is refreshed by user and its items view synchronize data task is running.
· Close items view objects in worker threads and use separate worker thread for each compare/synchronize item task.
· Fix repository PK error setting items view row filter for new items comparison and shared settings cmp type PK error.
· Check for unhandled exceptions on executing sql, connecting to data source
· Reduce flashing/flicker on resizing main window
· Fix possible missing schema separator for main tab item label. Fix possible too wide main tab label for item opened in its own tab
· Log first 20 messages per message type for a command line run to Windows event log in addition to logging to application repository
· Add application version number to Windows event log application source name
· Fix possible crash with items view sorting while main task is in progress and a row filter is present
· Qualify Informix system catalog tables/views with informix schema name to account for ANSI informix databases
· Use dropdown rather than dropdown list for tables filter schema grid item to allow user to enter schema name where driver does not return schema list for data source
February 3rd, 2009· Add Empty counter to items view main properties
· Add Close All DBMS Comparisons command
· Add -r command line option to allow running comparisons and data synchronization from the command line and/or external scheduling.
· Add Back/Forward explorer commands
· Add multi-core support to metadata folder-level comparisons. If your machine has more than 2 cores, please see the application online help about moving the application repository from the embedded Firebird database to an enterprise-class DBMS such as MS SQL Server, Oracle, or DB2 to take advantage of enhanced performance possible with more than 2 cores.
· Enhance logon userid/password security; empty logonID/password (Windows authentication) is no longer/not necessary to encrypt
· Add Limit Connections option to data source setup dialog
· Use idle processing to enable/disable properties grids
· Allow Run Now command for shutdown/inactive schedules
· Fix crash due to main comparison refresh where a metadata multiple item comparison is in progress.
· Add Open and Explore commands support to metadata lists
· Fix UI for Windows 7
December 8th, 2008· Add Matched column counter to comparison main properties
· Fix error determining temp folder for Windows Vista
December 3rd, 2008· Log schedule run info to repository to allow external applications to query repository about a scheduled task status/info including number of rows new/different/same, updated, inserted, deleted, etc.
· Log schedule run messages to repository
· Add trim history options to schedule maintenance dialog
· Add run end proc name option to schedules to allow running a stored procedure on a schedule run end to allow user to call their stored procedure that may inspect the run results and send an email, for example.
· Add Filter On command and Filter Settings On command to allow quickly filtering on the current cell text and filtering settings on current column name
· Add right trim, nill is null and zero is null column updates settings
· Reinterpret left trim and right trim comparison settings as ignore leading and ignore trailing spaces, respectively rather than always left trim and/or right trim when comparing so that two space filled strings of the same size are identified correctly as equal regardless of their column left trim/right trim comparison settings.
· Allow applying settings command for the same table to multiple columns by selecting text of the affected columns ( in comparison or settings view ) and executing the settings command on an anchor column. This allows user to right trim all char columns, or selected char columns, for a table with one command, for example.
· Implement view Show White Space and Show Line Endings for text views
· Add Select Match command and Column Match Tool to allow matching columns by clicking on source and match columns and to allow user to match columns where number of eligible unmatched columns exceeds 32 columns.
· Identify MS SQL Server 2008 data sources and add support for new data types: date, time, datetime2, datetimeoffset, geometry and geography. Support comparing/synchronizing UDT data types.
· Fix issue with synchronizing data at folder level where item gets re-retrieved unnecessarily for delete pass due to comparison object being released at the end of the insert/update pass because it does not meets keep objects items property.
· Fix error with setting where clause for side 1 of one-side table comparison
· Rollback delete if error is encountered determining number of rows affected by delete
· Rollback update if error is encountered determining number of rows affected by update
· Log warning instead of an error if number of rows affected by an update is zero
· Warn if save updates as/generate sync script output file folder is invalid on opening dialog since Apply button stays disabled
· Save schedule on Run Now command
· Validate/save script on Run Script command
· Fix tab key and entering tabs in editor pane depending on pane read-only state and allow tabbing out of text view using Ctrl+Tab or Ctrl+Shift+Tab
· Disable delete command for a schedule attached to an item
· Fix deleting unattached schedule that was set as weekly
· Fix issue with procedure column view reverting to contents view in explorer procedure/function navigation to another procedure/function workspace item
· Add item image to settings rows
· Move PK column to first column ( right after item image ) for column comparison
· Re-use delete, insert and update statements, if possible, when synchronizing data inline to enhance performance.
· Fix row not found issue for delete using Oracle ODBC driver where part of the row key is a table column whose length is greater than 128 characters
· Fix right trim comparison setting not working where data type of one of the two columns being compared is unicode char.
· Make list view current cell the clicked cell, if any, on right click
· Use end ellipses to truncate column names in menus where menu item text exceeds predefined max menu item width
· Fix current cell focus rectangle not shown where all text or rows text is selected
· Update comparison settings images foreground color so that image is visible when cell text is selected and list does not have focus
· Fix crash on retrieve where column excluded from select from both sides is added to key
· Allow using ALTER key to select header column text by clicking on header difference counter while holding down ALTER key to account for case where difference counter occupies most of the lower area of the column header.
· Display blank header for settings side 2 where settings are displayed horizontally to allow user to select side 2 settings column text by clicking on the blank column header or display header context menu.
· Add Copy As submenu to settings view context menu and fix settings save as sql where clause key
· Fix bug with display column filtering not refreshed where there is an ignore column filter and a column ignore state changes
· Fix issue with invert row filter and select text available count not updated
· Add Clear Contents Settings command to help recover from crash due to corrupt settings
· Fix crash due to inconsistent comparison key columns after match key column is excluded from select
· Extend Add Here workspace command to any main tab that has an item being displayed
· More error checking on converting strings to numbers when comparing text to numbers
· Fix settings stamp edit not being enabled for matches where it is applicable
· Support using spacebar, enter and escape keys for editing settings properties
· Use user encoding option when saving rows/selected text as sql
· Use ANSI encoding, if possible, rather than always unicode for saving as csv, txt formats
· Update generating sync script options to include new updates settings for Right Trim Spaces, Nill is Null and Zero is Null, and use these options when saving inserts as text.
· Remove redundant scrollbars from text views
· Fix issue where pending exclude from select column was getting used for inserts
· Fix issue with starting a retrieve where first new where clause has not been validated
· Fix bug with no data is retrieved for a folder metadata where the folder contents view has not yet been retrieved
· Fix bug with validating first where clause where comparison is started before user saved where clause sql
· Reduce flashing of tab item label when task is active
· Fix issue where display buffer does not contain last batch of an inline comparison eligible items when user cancels the comparison task
· Fix crash with closing Save As SQL preview while task is in progress
· Add Stop toolbar button to Save As SQL preview dialog
· Support comparing time data type to character data types
· Add title commands to display titles side by side, not display title item icon and display title text in gray color and display user logon id in title
· Fix context-sensitive F1 help not working for some context menus
· Retrieve all SQLite character columns with SQLGetData as DBMS does not enforce character column size limit
· Display data type information for comparison column header tooltip
· Adjust dropdown list detail width to completely display list items
· Fix crash due to delay time before tooltip is displayed for last item of list view that is being filtered out
· Display scrollbar for data source list box if necessary
· Fix issue with timestamp precision when synchronizing data where default precision was being used instead of actual target column precision.
· Update application to use maximum rather than minimum timestamp precision for inserting/updating repository tables
· Fix UI for use with unthemed Windows style
· Check DBMS version for hosting application repository on Oracle to be 9.x or above
· Rename three repository FK constraint names on table in_sync_node to be the same as the DB2 constraint names (now same pre/post scripts for all supported DBMSs for moving repository)
· Add support for clearing settings for multiple items by implementing Clear Settings command at the items view
· Add repository procecure to advance repository sequences for moving repository to Firebird, DB2, Oracle and PostgreSQL and update help topic with additional script for advancing repository sequences.
· Swap workspace DBMS comparison sides on adding the same DBMS comparison with swapped sides when the existing DBMS comparison is not open.
· Fix issue with tree ctrl scrolling to the bottom of the workspace on opening comparison root that has nested expanded items
June 26th, 2008· Add support for internal scheduling of comparisons and data synchronization
· Add data source setup option to close unused connection after specified number of minutes and by default close unused connections after 10 minutes
· Check for dead connections
· Add support for profiles via command line option to allow multiple separate environments for the application for the same user
· Add command line option for starting application minimized to Windows notification area
· Reduce OnIdle cpu usage due to mouse move
· Fix crash with closing DBMS comparison where one of the item is selected and open in explorer and its own tab
· Fix crash with synchronizing Firebird data at the folder level where ODBC driver returns SYSDBA instead of NULL for SQLForeignKeys foreign key table schema when determining table dependencies
· Fix crash with cut/paste tree item where tree item is current item in explorer tab or open in its own tab
· Always commit on releasing a connection to the connection pool to release dbms catalog/system locks, if any.
· Use PostgreSQL 8.3 pg_trigger.tgenabled definition for PostgreSQL trigger resultset
· Update embedded Firebird server to version 2.04
· Fix memory leaks due to stl ostrstream::str()
· Add message pane max size option to limit message panes memory usage
· Add tooltips to application status bar
· Add procid and trigid to Informix procedures/functions/triggers resultsets order by clause to account for overloaded object names. Remove paramtypes column from procedures resultset sql.
· Use Windows login user name for Informix user name if the driver returns empty string for SQLGetInfo SQL_USER_NAME
· Fix crash due to currently usupported interval data types
· Clear tree item expanded state if it is expanded and has no children on comparison root close
· Fix flashing of tooltip window where mouse pointer is inside tooltip window
November 16th, 2007· Add Synchronize command to allow synchronizing table data at table level with options for pre/post synchronization sql scripts
· Add column default to table column comparison
· Add Clear Pending Deletes/Inserts/Updates commands
· Add Clear Comparison command
· Add Copy As command to allow copying selected text/selected rows to clipboard as tab-delimited text, CSV, or SQL delete/insert/update statements.
· Add max characters per item option for Save As HTML application options to limit item text when saving comparison as HTML
· Application installer file is now digitally signed
· Account for NULL where clause column values when generating delete/update sync script or synchronizing data.
· Rollback to last commit point for each insert error when synchronizing data in case other tables were affected by failed insert
· Use updates properties where clause key when saving synchonized deletes rather than defaulting to PK/AK
· Add support for inheriting update properties ( Updatable, commit interval and error limit ) from parent item and display overridden inheritable properties in bold.
· Warn user when comparing without a comparison key
· Fix bug with recomparing an inline comparison due to comparison key change
· Fix memory leak with pending updates grid label/counter
· Fix memory leak with popup menus and save as HTML images
· Check for no error information returned by driver on sql errror. Example, Oracle ODBC driver and inserting into varchar2 column where source column data type is SQL_GUID
· Update inline comparison counters after each batch comparison is complete rather than when each individual row comparison is performed.
· Check for memory allocation failure when reserving comparison resultset vectors
· Fix sometimes missing list rows when a tables comparison node is expanded and is set as the current node when dbms comparison is reopened.
· Fix sporadic crash with refreshing comparison settings
· Move ODBC Admin button from data source list dialog to data source setup dialog
· Update some windows to use middle of window for context menu displayed using shift F10 if relevant position is not in view
· Restore support for Windows Classic theme to allow application to be used on Windows Server 2003 where themes service is disabled by default.
· Add counters for deleted/inserted/updated rows
· Add refresh support for main properties object list filters
· Update Exporer tab to display current item name as tab label
· Improve performance of populating virtual tree nodes ( tables comparison, for example).
· Update list item tooltip to display multi-line tooltip
· Add status, created, last_ddl_time, timestamp and object_id columns to Oracle procedures, sequences and triggers comparison resultsets
· Add support for converting string to timestamp when comparing where date and time parts of the string are separated with one colon ( example, Oracle all_objects.timestamp column value 2007-06-16:09:46:42 )
· Fix error getting catalog functions resultsets for MySQL where 'schemata' was used as dummy schema instead of dummy catalog
· Implement workaround for MySQL ODBC driver 3.51.21 incorrect info for sql union support
· Fix redraw issue with deleting main tab preceding item where main tab scrollbar is present
Find us on Google+
