SQL Examiner Suite 2023 change log

The change log below contains a complete list of all fixes and improvements in each public build of the SQL Examiner Suite 2023

All improvements and fixes are marked with a mark showing in which program the changes were made:

• SQLE
  SQL Examiner (schema comparison and synchronization tool)
• SQLDE
  SQL Data Examiner (data comparison and synchronization tool)
• SQLES
  Both SQL Examiner and SQL Data Examiner

9.0.0.106 - March 20th, 2023

Fixes

• SQLDE
  SQLES-1322: Synchronization output appearance: the text is too close to the Output tab borders.
• SQLDE
  SQLES-1323: Information about enabling triggers is displayed in the synchronization output even if they have not been disabled before.
• SQLDE
  SQLES-1324: In some cases, the program synchronizes only a few tables marked for synchronization, the rest is skipped and not synchronized.
• SQLDE
  SQLES-1331: If a user made a comparison with a new (<New>) target database and then created a database copy during synchronization, only the comparison with the database copy will be available in the Recent Comparison list. The comparison with the new target database cannot be repeated.
• SQLDE
  SQLES-1326: If the target database in a comparison from the Recent Comparison list has been replaced with a new (<New>) database, the comparison settings are completely reset and should be restored manually.
• SQLDE
  SQLES-1340: When generating a Database Variance Report the Custom ODBC Data Source connection string used as a database name can contain a password.
• SQLES
  SQLES-1349: FileNotFoundException occurs when starting SQL Examiner or SQL Data Examiner command-line tools.

9.0.0.105 - March 15th, 2023

Fixes

• SQLE
  SQLES-1329: If procedures or functions in a PostgreSQL database use arrays of user-defined types, the program generates an incorrect synchronization script.
• SQLE
  SQLES-1338: In some cases, when synchronizing unique indexes in MySQL databases, the program generates an incorrect synchronization script (excessive statements).

9.0.0.104 - March 9th, 2023

Improvements

• SQLDE
  SQLES-1305: Additional hidden settings have been added to fine-tune the program's work with ODBC sources.
• SQLDE
  SQLES-1305: Added additional logging of program work with ODBC data sources.

Fixes

• SQLDE
  SQLES-1317: The message "Backing up 'dbName' database..." has been displayed twice on the last step of the Synchronization wizard.

9.0.0.103 - March 7th, 2023

Fixes

• SQLE
  SQLES-1303: Syntax errors while parsing PostgreSQL creation scripts.
• SQLE
  SQLES-1307: In some cases, NotImplementedException occurs when synchronizing SQL Server temporal tables between a database snapshot (source) and a live database (target).
• SQLE
  SQLES-1308: In some cases, when synchronizing SQL Server temporal tables in a database snapshot (source) and a live database (target), the program generates an incorrect synchronization script (wrong order of statements).
• SQLDE
  SQLES-1305: In some cases, ArgumentException occurs when loading data from a HANA database using Custom ODBC Data Source.
• SQLDE
  SQLES-1311: In some cases NullReferencesException occurs when synchronizing data in Oracle databases and the program crashes.

9.0.0.102 - March 2nd, 2023

Fixes

• SQLDE
  SQLES-1304: In some cases, when starting SQL Data Examiner, NotImplementedException interrupts running the program.

9.0.0.101 - March 1st, 2023

Fixes

• SQLDE
  SQLES-1301: In some cases, InvalidCastException occurs when saving changes in the program options (Options window).

9.0.0.100 - February 28th, 2023

Initial public version of the SQL Examiner Suite 2023. You can see the list of changes and improvements in the 2023 version in the Release Notes.