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.3.0.139 - October 10th, 2023

Fixes

• SQLE
  SQLES-1674: In some cases, when comparing a PostgreSQL database with PostgreSQL database scripts (script file, script folder), some functions are recognized as different.
• SQLE
  SQLES-1667: In some cases, when comparing a PostgreSQL database with PostgreSQL database scripts (script file, script folder), the program recognizes some procedures and functions as different, although they are identical.
• SQLE
  SQLES-1637: In some cases, if a PostgreSQL table has to be recreated during synchronization, its sequence is reset to the initial value. (reopen)
• SQLE
  SQLES-1669: In some cases, when comparing a PostgreSQL database with PostgreSQL database scripts (script file, script folder), the program recognizes triggers as different, although they are identical.
• SQLDE
  SQLES-1652: On the last step of the Export to Script wizard, the Output tab contains unreadable characters and the wrong path to the folder where the script is saved.
• SQLDE
  SQLES-1654: The transaction isolation level specified in synchronization settings is not taken into account.
• SQLES
  SQLES-1676: In some cases, an error with the "Format of the initialization string does not conform to specification starting at index N" message occurs when the password for a MySQL database connection contains special characters.

9.3.0.138 - September 27th, 2023

Fixes

• SQLE
  SQLES-1637: In some cases, if a PostgreSQL table has to be recreated during synchronization, its sequence is reset to the initial value.
• SQLDE
  SQLES-1601: In some cases, if an error occurs during program work, temp files are not deleted. (reopen)
• SQLDE
  SQLES-1624: In some cases, NullReferencesException occurs while working in the Edit Project window.
• SQLDE
  SQLES-1625: In some cases, InvalidOperationException occurs after click on Finish in the Edit Project window.

9.3.0.137 - September 9th, 2023

Fixes

• SQLDE
  SQLES-1617: Corrected a typo in GUI and improved text in the Command line tool.

9.3.0.136 - September 5th, 2023

Fixes

• SQLDE
  SQLES-1601: In some cases, if an error occurs during program work, temp files are not deleted.
• SQLDE
  SQLES-1611: In some cases, after click on OK in the New Query/Edit Query window, the following message appears: "In order to insert data into the ... table during the synchronization, all NOT NULL fields without default values (namely ...) must be retrieved.", although it is not expected.
• SQLDE
  SQLES-1613: In some cases, after attempting to add new query to an SQL Server table via context menu, the program generated queries with excessive operators.

9.3.0.135 - August 10th, 2023

Fixes

• SQLE
  SQLES-1590: In some cases, an error occurs during creation of a foreign key when synchronizing PostgreSQL databases.

9.3.0.134 - August 2nd, 2023

Fixes

• SQLE
  SQLES-1538: The column names written in different cases are not highlighted as different on the Creation Script tab.
• SQLDE
  SQLES-1482: In some cases, when loading database schema, ArgumentException occurs in the New Data Comparison wizard if a source or target is an SQL Server 2022 backup. (reopen)
• SQLDE
  SQLES-1518: In some cases, NullReferenceException occurs when closing Export to CSV wizard.
• SQLDE
  SQLES-1584: в некоторых случаях, после нажатия кнопки Cancel в мастере синхронизации, программа зависает
• SQLDE
  SQLES-1584: In some cases, the program freezes after click on the "Cancel" button in the synchronization wizard.

9.3.0.133 - July 31th, 2023

Fixes

• SQLE
  SQLES-1581: In some cases, when comparing a PostgreSQL database with PostgreSQL database scripts (script file, script folder), the program recognizes some tables as different, although they are identical.

9.3.0.132 - July 28th, 2023

Fixes

• SQLE
  SQLES-1580: In some cases, an error with the "ERROR: syntax error at or near "."" message occurs because of the incorrect synchronization script for PostgreSQL TRIGGER objects.
• SQLDE
  SQLES-1541: In some cases, UNICODE text characters in MySQL databases are displayed incorrectly after synchronization.
• SQLDE
  SQLES-1545: In some cases, the program exports to CSV data from all tables, although only some of them were checked in the Export to CSV wizard.

9.3.0.131 - July 17th 2023

SQL Examiner Suite 2023.3: added support for the following Oracle features

See Release Notes for details.

• SQLE
  SQLES-63: 'MATERIALIZED VIEW' and 'MATERIALIZED VIEW LOG' objects.
• SQLE
  SQLES-121: 'SYNONYM' objects.
• SQLE
  SQLES-1506: 'DATABASE LINK' objects.
• SQLE
  SQLES-1460: More flexible comparison of table and index storage parameters.
• SQLES
  SQLES-1283: Blockchain and Immutable tables.
• SQLES
  SQLES-1284: Native JSON binary data type (Oracle 21c).

9.2.0.130 - July 3rd, 2023

Fixes

• SQLE
  SQLES-1531: In some cases, when comparing a script file or script folder with a PostgreSQL live database, the program parses scripts incorrectly. As a result, an error with the "ERROR: unexpected end of function definition at end of input" message occurs during synchronization.

9.2.0.129 - June 28th, 2023

Fixes

• SQLDE
  SQLES-1527: In some cases, NullReferenceException occurs during synchronization if the Rollback changes only in a table where an error occurs option is enabled.

9.2.0.128 - June 27th, 2023

New Features

• SQLDE
  SQLES-1466: Added the Ignore differences in line endings comparison option.

Improvements

• SQLE
  SQLES-1497: Allow to exclude the "DateCreated" from a snapshot.
• SQLE
  SQLES-1497: Added a new internal variable that allows to exclude the "DateCreated" property from a snapshot.

Fixes

• SQLE
  SQLES-1470: In some cases, the Options tab in the Edit Project window contains comparison options that do not match the current comparison databases.
• SQLE
  SQLES-1524: In some cases, the program processes SQL Server trigger metadata incorrectly and, as a result, creates an incorrect synchronization script.
• SQLE
  SQLES-1526: In some cases, when loading dependencies of PostgreSQL objects the "ERROR [42501]: permission denied for table pg_authid" error occurs.

9.2.0.127 - June 21st, 2023

Fixes

• SQLE
  SQLES-1318: In some cases, the program incorrectly recognizes a MySQL server version, as a result, MySqlException occurs with the "Unknown column 'S.EXPRESSION' in 'field list'" error message when loading column information.
• SQLE
  SQLES-1515: In some cases, ArgumentOutOfRangeException occurs in the New Schema Comparison wizard during a cross-platform comparison.
• SQLE
  SQLES-1516: In some cases, the program generates an incorrect synchronization script for FOREIGN KEY objects of SQL Server databases.
• SQLDE
  SQLES-1376: There are unreadable characters on the Output tab in the Export to CSV wizard.
• SQLDE
  SQLES-1392: In some cases, after clicking the Auto detect columns button in the Flat File Table Wizard, the program detects data types of some columns incorrectly.
• SQLDE
  SQLES-1513: The filter doesn't work in the Export to CSV wizard, Script Database wizard and Database Variance Report Wizard.

9.2.0.126 - June 13th, 2023

Fixes

• SQLE
  SQLES-1477: The SET configuration_parameter of PostgreSQL functions and procedures is now compared and synchronized. (reopen)

9.2.0.125 - June 9th, 2023

Fixes

• SQLE
  SQLES-1499: In some cases, when synchronizing tables with trigger functions between PostgreSQL databases, the program generates an incorrect synchronization script.

9.2.0.124 - June 6th, 2023

Fixes

• SQLE
  SQLES-1492: In some cases, NotSupportedException occurs when program loads database schema from a database snapshot.

9.2.0.123 - June 5th, 2023

Fixes

• SQLE
  SQLES-1487: When altering a varchar(n) (or nvarchar(n)) column size in an SQL Server database to varchar(MAX) (or nvarchar(MAX)), a DEFAULT constraint on the column has to be re-created.
• SQLE
  SQLES-1081: If the columns with datetime2 data type have different scales, the program doesn't recognize it as a difference.

9.2.0.122 - June 1st, 2023

Fixes

• SQLE
  SQLES-1485: It is not possible to compare an SQL Server database with <New> database.
• SQLE
  SQLES-1477: The SET configuration_parameter of PostgreSQL functions and procedures is now compared and synchronized.
• SQLDE
  SQLES-1482: In some cases, when loading database schema, ArgumentException occurs in the New Data Comparison wizard if a source or target is an SQL Server 2022 backup.

9.2.0.121 - May 31th, 2023

SQL Examiner Suite 2023.2: added support for the following PostgreSQL features

See Release Notes for details.

• SQLE
  SQLES-1188: UNLOGGED parameter for tables and sequences.
• SQLE
  SQLES-1191: OUT parameters can now be used to return data from stored procedures.
• SQLE
  SQLES-1199: STORAGE mode for columns.
• SQLE
  SQLES-1196: RULE objects.
• SQLE
  SQLES-1200: Per-attribute options for columns.
• SQLE
  SQLES-1201: Support for SET STATISTICS command.
• SQLE
  SQLES-1383: Enabled comparison of extensions in source and target databases; display warning if extensions differ.
• SQLES
  SQLES-1192, SQLES-1193: Support for multirange types.

9.1.0.120 - May 26th, 2023

Fixes

• SQLE
  SQLES-1465: In some cases, when performing partial synchronization, the differences in column comments are not taken into account.
• SQLE
  SQLES-1471: In some cases, InvalidCastException occurs when trying to synchronize PostgreSQL stored procedures.
• SQLE
  SQLES-1472: In some cases, the program doesn't detect differences between PostgreSQL stored procedures with different SECURITY options.
• SQLE
  SQLES-1474: In some cases, StackOverflowException occurs in the Script Database wizard while scripting a PostgreSQL database.
• SQLDE
  SQLES-1475: In some cases, InvalidOperationException occurs when changing settings in the Edit Project window.

9.1.0.119 - May 17th, 2023

Fixes

• SQLE
  SQLES-1454: In some cases, the program recognizes SQL Server indexes as different, although they have been synchronized.
• SQLDE
  SQLES-1442: In some cases, when synchronizing data between SQL Server and PostgreSQL databases, the program generates an incorrect synchronization script.

9.1.0.118 - May 17th, 2023

Fixes

• SQLE
  SQLES-1446: In some cases, when synchronizing PostgreSQL VIEW objects, the program generates an incorrect synchronization script.
• SQLE
  SQLES-1006: Now snapshots contain additional information about the creation date, program version and snapshot's source type (live database, script, backup).
• SQLDE
  SQLE-1019: If one of the tables to be compared has a PRIMARY KEY or a UNIQUE index and the second one has neither one nor the other, the program doesn't define the comparison key for the second table automatically.
• SQLDE
  SQLES-1442: In some cases, when comparing SQL Server and PostrgreSQL databases, the program generates an incorrect synchronization script.

9.1.0.117 - May 15th, 2023

Fixes

• SQLE
  SQLES-1341: In some cases, an incorrect schema of the foreign-key table is displayed in the Creation Script tab in the main window.
• SQLE
  SQLES-1436: In some cases, NotSupportedException occurs when a PostgreSQL database snapshot is chosen as a source or target.
• SQLE
  SQLES-1444: In some cases, when comparing a PostgreSQL script with a live database, the program recognizes source and target column data types as different although they are the same.

9.1.0.116 - May 11th, 2023

Fixes

• SQLE
  SQLES-1423: In some cases, when synchronizing SQL Server databases, the program generates the wrong order of CREATE FUNCTION commands which leads to a synchronization error.
• SQLE
  SQLES-1428: ArgumentNullException occurs in the Add Source Control Server window when setting up a connection to a local Git repository.
• SQLE
  SQLES-1430: In some cases, the program incorrectly displays user-defined functions from PostgreSQL databases in the Creation Script and Synchronization Script tabs in the main window.

9.1.0.115 - May 5th, 2023

Fixes

• SQLE
  SQLES-1421: In some cases, InvalidCastException occurs in the Script Database wizard when trying to proceed from the Specify a destination folder and a file step to the next step.
• SQLDE
  SQLES-1424: In some cases, when loading Oracle database metadata, IndexOutOfRangeException occurs with the "Unable to find specified column in result set" error message in the New Data Comparison window.

9.1.0.114 - April 28th, 2023

Fixes

• SQLE
  SQLES-1418: In some cases, when synchronizing SQL Server databases containing functions that differ but have the same signature, the program generates an incorrect synchronization script.

9.1.0.113 - April 24th, 2023

Fixes

• SQLES
  SQLES-1412: In error reports, the OS version is always Microsoft Windows NT 6.2.9200.0 regardless of the user's actual OS version.

9.1.0.112 - April 19th, 2023

Fixes

• SQLDE
  SQLES-1408: In some cases, when loading metadata from an Azure database, the System.IndexOutOfRangeException occurs.

9.1.0.111 - April 19th, 2023

Fixes

• SQLE
  SQLES-1406: In some cases, the program skips some text objects when loading metadata from an SQL Server database.
• SQLE
  SQLES-1402: In some cases, when trying to synchronize SQL Server system-versioned temporal tables, the program generates an incorrect synchronization script.

9.1.0.110 - April 17th, 2023

SQL Examiner Suite 2023.1: support for new SQL Server 2022 features

See Release Notes for details.

• SQLE
  SQLES-1278: Ordered clustered columnstore indexes.
• SQLE
  SQLES-1279: Compression of XML columns and indexes.
• SQLE
  SQLES-1280: AUTO_DROP option for statistics.
• SQLE
  SQLES-1356: GENERATED ALWAYS AS argument of the CREATE TABLE statement with TRANSACTION_ID and SEQUENCE_NUMBER parameters.
• SQLDE
  SQLES-1281: IS [NOT] DISTINCT FROM language element.
• SQLDE
  SQLES-1309: SELECT ... WINDOW clause.
• SQLES
  SQLES-1358: Support of ledger databases and tables.
• SQLES
  SQLES-1310: Azure Active Directory authentication for SQL Server.

Fixes

• SQLES
  SQLES-1387: In rare cases ArgumentOutOfRangeException occurs on the External SQL Tools tab in the Options window.

9.0.0.109 - April 11th, 2023

Fixes

• SQLES
  SQLES-1370: In some cases, the program detects a PostgreSQL server version incorrectly.

9.0.0.108 - April 7th, 2023

Fixes

• SQLDE
  SQLES-1379: Minor UI updates for Edit Project and Comparison Options windows.
• SQLES
  SQLES-1330: A minor UI improvement for Recent Comparison window.

9.0.0.107 - April 6th, 2023

Fixes

• SQLE
  SQLES-1353: When retrieving text objects information from PostgreSQL 10 or earlier versions, IndexOutOfRangeException occurs.
• SQLDE
  SQLES-1363: An excessive whitespace has been removed from the command line output.
• SQLDE
  SQLES-1351: In some cases when comparing Oracle and HANA databases, Unable to cast... exceptions occur.
• SQLDE
  SQLES-1328: When the program works in debug mode and collects logs, debug logging can be extremely slow.
• SQLES
  SQLES-1350: The custom name of a database backup is replaced with the default template-based name in the command line parameter /BackupTargetDB.
• SQLES
  SQLES-1369: The previously hidden option "Round float types..." has been made enabled for all users.

Improvements

• SQLDE
  SQLES-1305: Added the ability not to retrieve indexes when reading metadata via ODBC which eliminated excessive delays in some cases.

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 (<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 redistributable 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: 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.