Change Log

< 1 2 3 4 5 6 Beta >

Date	Version	Repository Level
2021-09-09	2.2.2	141*
New
Update application code page to UTF-8. Requires Windows Version 1903 (May 2019 Update) and above. Add character set and collation info to table column comparison for select DBMSs. Add Load SQL command to scripts views to load a sql file statement by statement.
Fix/Update
Update Scintilla text editor to latest 5.1.1 version. Update Firebird database to latest Firebird 4 version. Update generated sql script, save as html and xml to use UTF-8 encoding.
2021-07-14	2.1.2	140*
New
Add support for drag and drop. Add keep sorted workspace command. Add reopen last closed DBMS comparison command.
2021-05-25	2.0.22	140*
New
Add support for high-dpi monitors. Update minimum Windows requirement from Windows XP SP3 to Windows 10. Add support for Oracle pluggable databases. Add support for MariaDB. Add support for Snowflake data sources. Add support for Google BigQuery data sources. Add support for Amazon Redshift data sources. Add table check constraints support for MySQL 8 and MariaDB. Add script Microsoft SQL server default constraints. Add support for retrieving and comparing SQL Server SQL_VARIANT data type. Add support for SQL Server 2012 and above sequences. Add support for two additonal diff apps commands. Add Edit and Clear column content type commands. Add Close Other DBMS Comparisons command. Add workspace blank area popup menu. Add Non key column counters to comparison main properties. Display comparison key image in comparison headers. Add settings menu items to column counters popup menu. Add support for resultsets with number of rows greater than 4G. Add middle mouse click support to add/remove counter filter. Add support for tab ctrl horizontal scroll using mouse wheel. Include schema prefix by default, if applicable, in copy as/save rows as sql command output. Hold down the shift key when executing the command to not include schema prefix in the generated sql. Add insert nulls option to generate sync script. Add script table column as drop/set default/not null for extended support DBMSs. Add support for drop table option clause (restrict/cascade) for supported DBMSs. Add go back/forward handling using mouse buttons, if any.
Fix/Update
Uniquely identify Oracle data source server with the instance service name. Support multiple instances of MySQL on the same server by uniquely identifying data source server with MySQL server_uuid. Support multiple instances of MariaDB, PostreSQL on the same server by uniquely identifying data source server with port number in addition to host name. Fix saving binary column data as binary data when opening column data in external diff apps. Update Microsoft SQL Server repository tables to use datetime2 instead of datetime datatype to work with recent MS ODBC drivers that do not correctly bind datetime parametes column size/precision. Update Microsoft SQL Server minimum supported version for hosting application repository to SQL Server 2008. Update save comparison as html. Add Low, Medium and High max active property to items view. Fix issue with shrunken toolbars on re-login to windows. Update meta-data comparisons max active implicit property from Very High to Medium. Update default commit interval from 1000 to 100 (1 for MS Access). Update support for Microsoft Access, Excel and text latest office ODBC drivers. Fix opening ODBC Administrator from data source setup dialog. Update support for Mimer SQL latest ODBC driver. Identify SAP Hana data sources. Update support for SAP Advantage Database Server. Update support for FileMaker. Fix Failed to launch help when no tab is open. Update counter format to display thousands separator for the locale. Fix display of NULL values. Faster sort of large resultsets. Fix crash deleting sort properties grid item. Add Reserving Rows status. Add 2 cell properties support. Fix slow UI updates with long running tasks. Add status bar to main scripts view. Add execute selected text command to scripts view. Fix copy/paste workspace item label where item label is being edited. Fix updating item name in dropdown list on save when both item name and item detail have changed. Bug fixes and performance enhancements. Fix counter tooltip display for unicode values.