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.3.201 – April 8th, 2025

Fixes

• SQLDE
  SQLES-2181: In some cases a NullReferenceException occurs when resizing the "Object" column in the Object List panel of the main window.
• SQLES
  SQLES-2195: A KeyNotFoundException occurs when connecting to a MySQL database using older drivers.

9.3.3.200 – March 18th, 2025

Fixes

• SQLE
  SQLES-2186: Synchronization warnings for Oracle SEQUENCE objects are handled incorrectly, resulting in errors in the generated scripts.
• SQLES
  SQLES-2185: CLI ignores explicitly specified comparison options when the /project parameter is used, always loading them from the project settings.

9.3.3.199 – March 12th, 2025

Fixes

• SQLE
  SQLES-2182: When comparing indexes in MS SQL databases, the "Ignore case when comparing object names" option is sometimes not applied, which leads to incorrect comparison results.
• SQLDE
  SQLES-2181: In some cases a NullReferenceException occurs when attempting to resize the "Object" column in the Object List panel of the main window.

9.3.3.198 – February 26th, 2025

Fixes

• SQLE
  SQLES-2177: in certain cases a NullReferenceException occurs when processing trigger metadata in PostgreSQL databases.
• SQLE
  SQLES-2178: When reading PostgreSQL metadata, some boolean parameters may be read incorrectly, which results in invalid object scripts being displayed.
• SQLDE
  SQLES-2176: In some cases, the application generates incorrect /include parameters and also processes them incorrectly, causing unnecessary objects to be included in the selection.

9.3.3.197 – February 7th, 2025

Fixes

• SQLE
  SQLES-2163: When displaying differences in PostgreSQL functions, the application sometimes shows incorrect comparison signs for matching and differing lines.

9.3.3.196 – January 22nd, 2025

Fixes

• SQLDE
  SQLES-1863: In cross-platform projects involving MS SQL and MS Access databases, key columns are sometimes compared incorrectly, causing data to be marked as "Only in Source" and "Only in Target" instead of "Identical".
• SQLDE
  SQLES-2147: When generating data synchronization scripts for tables containing fractional numbers, a FormatException occurs in some cases.
• SQLDE
  SQLES-2148: When selecting rows from certain tables for synchronization in the main window, an ArgumentOutOfRangeException occurs in specific cases.

9.3.3.195 – January 21st, 2025

Improvements

• SQLDE
  SQLES-2146: During the data comparison stage, the application collects debug information when exceptions occur.

9.3.3.194 – January 17th, 2025

Fixes

• SQLDE
  SQLES-2143: When /include or /exclude parameters that contain regular expressions are specified in the CLI, extra tables are sometimes included in the selection due to incorrect parameter handling.

9.3.3.193 – January 13th, 2025

Fixes

• SQLDE
  SQLES-2132: When opening a project that has "Empty Database" as one of the sources, the application sometimes shows an error: "This program version does not support Odbc source type."
• SQLDE
  SQLES-2139: When the PRIMARY KEY or UNIQUE constraint exists in only one of the compared tables, the application does not automatically determine the comparison key and requires the user to specify it manually.

9.3.3.192 – December 24th, 2024

Fixes

• SQLE
  SQLES-2135: When synchronizing MySQL tables in scenarios that involve both renaming and adding columns, the application sometimes generates an invalid script, leading to synchronization errors.

9.3.3.191 – December 3rd, 2024

Fixes

• SQLDE
  SQLES-2123: When columns used in a comparison key contain NULL values, the application sometimes generates an incorrect synchronization script.

9.3.3.190 – November 28th, 2024

Fixes

• SQLE
  SQLES-2118: During cross-platform synchronization with PostgreSQL as the target database, an error may occur when inserting data: "row size exceeds the limit (8160)." This issue also affects related test scenarios.

9.3.3.189 – November 25th, 2024

Fixes

• SQLDE
  SQLES-2115: During data synchronization, the step information in the Output window is sometimes displayed with a delay.

9.3.3.188 – November 16th, 2024

Fixes

• SQLE
  SQLES-2076: an ArgumentOutOfRangeException sometimes occurs when clicking the content of the Creation Script tab in the main window.
• SQLDE
  SQLES-2070: When comparing large PostgreSQL tables, an error occurs: "ERROR [40001] ERROR: canceling statement due to conflict with recovery", and the application unnecessarily prompts user to submit a report despite it being an expected issue.
• SQLDE
  SQLES-2071: When comparison of tables encounters expected errors, the application sometimes incorrectly suggests submitting an error report.
• SQLDE
  SQLES-2075: When comparing tables where a comparison key includes both string columns and columns of other data types, a NotSupportedException sometimes occurs.
• SQLDE
  SQLES-2108: In cross-platform comparisons, program sometimes generates incorrect INSERT statements, which leads to synchronization errors.

9.3.3.187 – October 23rd, 2024

Fixes

• SQLE
  SQLES-2055: Synchronization scripts are generated in CLI even when they are not required.
• SQLE
  SQLES-2069: When retrieving PostgreSQL roles metadata, an ArgumentException may occur with the message "An item with the same key has already been added."
• SQLE
  SQLES-2074: When comparing a live SQL Server database with scripts that includes COLUMNSTORE INDEX objects, an ArgumentOutOfRangeException may occur.
• SQLDE
  SQLES-2023: When selecting a table in the Object List for which a comparison error occurred, an ArgumentOutOfRangeException sometimes occurs.
• SQLDE
  SQLES-2067: When clicking the column header containing DateTimeOffset data in the main window, a NotImplementedException may occur.

9.3.3.186 – October 21st, 2024

Fixes

• SQLE
  SQLES-2029: In PostgreSQL 17 and newer, some metadata queries returns unexpected results.

9.3.3.185 – October 15th, 2024

Fixes

• SQLE
  SQLES-2060: When displaying differences in PostgreSQL functions, the application sometimes shows incorrect comparison signs for matching and differing lines.

9.3.3.184 – October 8th, 2024

Fixes

• SQLE
  SQLES-2050: Sequences are sometimes not loaded from Azure databases. (reopened)

9.3.3.183 – October 8th, 2024

Fixes

• SQLE
  SQLES-2050: Sequences are sometimes not extracted from Azure databases.

9.3.3.182 – October 4th, 2024

Fixes

• SQLE
  SQLES-2026: Metadata for indexes and columns in PostgreSQL databases is sometimes processed incorrectly, leading to generation of invalid CREATE scripts for tables and indexes.

9.3.3.181 – October 3rd, 2024

Fixes

• SQLE
  SQLES-2047: In some cases, synchronization scripts include invalid SQL Server–specific existence checks even when working with other database types.
• SQLE
  SQLES-2048: Warnings about column renaming are sometimes not generated, even though they should be.

9.3.3.180 – October 1st, 2024

Fixes

• SQLE
  SQLES-2045: The script for checking the existence of a SQL Server object is sometimes generated incorrectly.

9.3.3.179 – September 30th, 2024

Fixes

• SQLE
  SQLES-2042: When comparing a database with itself, schema mapping settings are sometimes processed incorrectly.

9.3.3.178 – September 4th, 2024

Fixes

• SQLE
  SQLES-2020: When attempting to change the data type of a column in a PostgreSQL table, dependencies between the table and its views are handled incorrectly, resulting in a synchronization error such as "cannot alter type of a column used by a view or rule".

9.3.3.177 – August 30th, 2024

Fixes

• SQLDE
  SQLES-2017: When a table is compared using a string key and contains fields with large binary data, those fields are sometimes read incorrectly.

9.3.3.176 – July 17th, 2024

Fixes

• SQLE
  SQLES-1988: Collation handling in PostgreSQL behaves incorrectly in certain scenarios.

9.3.3.175 – June 27th, 2024

Fixes

• SQLE
  SQLES-1978: It is not possible to globally apply the automatic resolution for the NullInsertWarning using default value across all warnings of the same type.

9.3.3.174 – June 20th, 2024

Fixes

• SQLE
  SQLES-1965: When changing a column type from date to timestamp in a PostgreSQL database, the synchronization script is generated incorrectly, leading to data loss.
• SQLDE
  SQLES-1966: In the New Data Comparison window, during metadata extraction of PostgreSQL sequences, an OdbcException with the message "ERROR: relation pg_sequence does not exist" sometimes occurs.
• SQLDE
  SQLES-1967: When comparing data with different types between source and target databases (for example, string types vs. floating point types) a NotImplementedException may occur.

9.3.3.173 – June 14th, 2024

Fixes

• SQLE
  SQLES-1959: A NullReferenceException sometimes occurs when modifying schema mappings.
• SQLE
  SQLES-1958: Git connection errors are not displayed in sufficient detail. (reopened)

9.3.3.172 – June 7th, 2024

Fixes

• SQLE
  SQLES-1957: Path names in SELECTIVE XML INDEX scripts for SQL Server databases are not properly escaped, which can cause synchronization errors.
• SQLE
  SQLES-1953: When extracting indexes metadata from SQL Server 2012 or earlier, a SqlException with the message "Invalid column name 'xml_index_type'" may occur.
• SQLE
  SQLES-1954: Synchronization of XML indexes for SQL Server 2012 or earlier can produce incorrect scripts that fail during execution.
• SQLE
  SQLES-1958: Git connection errors are not displayed in sufficient detail.
• SQLE
  SQLES-1938: A NullReferenceException sometimes occurs during SQL Server database synchronization script generation.
• SQLES
  SQLES-1930: In the CLI, when connecting to MySQL, a MySqlException with the message "Access denied for user 'user'@'XXX.XXX.XXX.XXX' (using password: YES)" sometimes occurs.

9.3.3.171 – June 4th, 2024

Improvements

• SQLE
  SQLES-1925: Added support for comparison and synchronization of SELECTIVE XML INDEX in SQL Server databases.

Fixes

• SQLE
  SQLES-1868: When parsing MS SQL scripts created by SSMS, a semantic error with the message "A '' object referenced in the 'MS_Description' extended property was not found" may occur.

9.3.2.170 – May 30th, 2024

Fixes

• SQLDE
  SQLES-1939: In the New Data Comparison window while working with Snowflake databases, an ArgumentException may occur during the table list retrieval phase. (reopened)

9.3.2.169 – May 17th, 2024

Fixes

• SQLDE
  SQLES-1939: In the New Data Comparison window, while working with Snowflake databases, an ArgumentException may occur during the table list retrieval phase.

9.3.2.168 – May 7th, 2024

Fixes

• SQLE
  SQLES-1933: When parsing PostgreSQL table scripts, a syntax error with a message like "Line N, column M: Incorrect syntax near 'USER'" may occur.
• SQLES
  SQLES-1932: If a scheduled task fails, the application sometimes terminates without creating the log and errorlog files, even though these files are specified in the task parameters.

9.3.2.167 – April 26th, 2024

Fixes

• SQLE
  SQLES-1924: When parsing PostgreSQL index scripts, a syntax error with a message like "Line N, col N: rightroundbracket expected" may occur, despite the script being valid.

9.3.2.166 – April 24th, 2024

Fixes

• SQLE
  SQLES-1920: When parsing user-defined function scripts for SQL Server databases, a syntax error with a message like "Incorrect syntax near 'INLINE'" may appear.

9.3.2.165 – April 21st, 2024

Fixes

• SQLE
  SQLES-1099: When comparing Oracle tables, columns with DEFAULT NULL constraints were previously marked as different from columns without the constraint, despite being functionally identical. These differences could not be synchronized, so the program no longer extracts or displays DEFAULT NULL constraints. (reopened)

9.3.2.164 – April 19th, 2024

Fixes

• SQLE
  SQLES-1913: When working with Oracle triggers, the column list was sometimes extracted incorrectly, resulting in unnecessary columns appearing in the creation scripts.
• SQLDE
  SQLES-1911: In the Different Records tab, if a cell with visually identical data is selected (not highlighted), the Preview Panel may display values as different (e.g., 0.93 vs .93), even though they are the same.

9.3.2.163 – April 11th, 2024

Fixes

• SQLE
  SQLES-1873: The program generates incorrect default values for columns with smalldatetime type when handling NullInsertWarning.
• SQLE
  SQLES-1895: Semantically identical PostgreSQL views are sometimes not recognized as equal and are unnecessarily marked for synchronization. (reopened)
• SQLE
  SQLES-1904: When parsing SQL Server table scripts, a syntax error with a message like "Incorrect syntax near 'OPTIMIZE_FOR_SEQUENTIAL_KEY'" may appear, even though there is no actual error.
• SQLES
  SQLES-1907: If a .cmd file is created using the CLI Wizard based on a project file and notification settings are configured via the GUI, those notification parameters are sometimes not included in the generated .cmd file.

9.3.2.162 – April 5th, 2024

Fixes

• SQLE
  SQLES-1895: Semantically identical PostgreSQL views are sometimes not recognized as equal and are unnecessarily marked for synchronization.
• SQLE
  SQLES-1897: When working with cross-platform projects using PostgreSQL databases, an IndexOutOfRangeException may occur during the comparison of view objects.
• SQLE
  SQLES-1898: The Ignore permissions option is not respected during the comparison of certain PostgreSQL objects, leading to incorrect synchronization scripts.

9.3.2.161 – March 28th, 2024

Fixes

• SQLE
  SQLES-1890: When comparing PostgreSQL scripts and live databases, some indexes are incorrectly shown as different despite having no actual differences.
• SQLE
  SQLES-1891: During synchronization between script folders and live PostgreSQL databases, the ALTER ... OWNER TO ... command is not generated, even when owner differences exist.
• SQLDE
  SQLES-1892: In the New Query window, parsing a PostgreSQL query that includes the clause at time zone 'tz_name' results in an error like "Incorrect syntax near 'at'", even though the syntax is valid.

9.3.2.160 – March 27th, 2024

Improvements

• SQLDE
  SQLES-1879: Now program collects debug information while deleting temporary files when the application is closing.

Fixes

• (sqle)] SQLES-1883: When extracting text objects metadata from SQL Server databases, a SqlException with the message "Invalid data for UTF8-encoded characters" may occur.
• SQLE
  SQLES-1886: When saving a PostgreSQL database snapshot, some sequence object data is not saved, causing tables to appear as different during comparison, even though no visible differences exist.
• SQLE
  SQLES-1887: Parsing PostgreSQL scripts that contain DEFAULT NULL expressions is sometimes handled incorrectly, resulting in false differences in column defaults when comparing scripts and live databases.
• SQLE
  SQLES-1889 In the Creation Script tab of the main window, the highlight indicating differences is sometimes misaligned by several lines.

9.3.2.159 – March 25th, 2024

Fixes

• SQLE
  SQLES-1881: Script generation for Oracle triggers did not properly account for the ability to specify individual columns.

9.3.2.158 – March 22nd, 2024

Fixes

• SQLDE
  SQLES-1879: Temporary data was not always fully cleaned up after closing the application.
• SQLDE
  SQLES-1878: Enum parameter values from the command line and configuration files could be distorted due to obfuscation issues; internal parsing logic required refactoring.

9.3.2.157 – March 13th, 2024

Fixes

• SQLDE
  SQLES-1863: In cross-platform projects involving SQL Server and MS Access, key comparisons were sometimes incorrect, causing data to be classified as Only in Source or Only in Target instead of Identical.

9.3.2.156 – February 28th, 2024

Fixes

• SQLE
  SQLES-1827: Retrieving metadata for Oracle user-defined types could result in a NullReferenceException.
• SQLE
  SQLES-1831: Oracle view definitions were sometimes not extracted during database comparison.
• SQLE
  SQLES-1839: Synchronization scripts for SQL Server USER objects could result in a NullReferenceException.
• SQLDE
  SQLES-1852: When parsing CSV files, column types set by the user were sometimes replaced with the types of the target columns.

9.3.2.155 – February 2nd, 2024

Fixes

• SQLE
  SQLES-1830: While retrieving privileges during Oracle schema comparison, an ArgumentException could occur with the message "An item with the same key has already been added."

9.3.2.154 – January 23rd, 2024

Fixes

• SQLE
  SQLES-1819: The value COMPILATION_ERROR was not handled for the COMPILE_STATE and STALENESS columns of the ALL_VIEWS view in Oracle.

9.3.2.153 – January 22nd, 2024

Fixes

• SQLDE
  SQLES-1813: When comparing tables where the comparison key is of string type, an IndexOutOfRangeException could occur.

9.3.2.152 – January 22nd, 2024

Fixes

• SQLE
  SQLES-1781: MySQL table scripts on the Creation Script and Synchronization Script tabs displayed incorrect precision values for some columns.
• SQLE
  SQLES-1801: Clicking the Back button on the Choose a desired script style step of the Script Database wizard could lead to an exception with the message buttonBack_Click: SaveStyle - 5.
• SQLE
  SQLDE-1817: Data retrieval from the ON_QUERY_COMPUTATION column of the ALL_MVIEWS view in Oracle versions earlier than 12.2 did not work as expected.
• SQLDE
  SQLES-1783: Parsing queries using the RIGHT and LEFT text functions could result in errors (Oracle, MySQL, PostgreSQL).
• SQLDE
  SQLES-1776: Parsing queries using the RIGHT and LEFT text functions could result in errors (SQL Server).
• SQLDE
  SQLES-1800: Clicking Script Data... in the main window could result in a NullReferenceException.

9.3.2.151 – January 11th, 2024

Improvements

• SQLDE
  SQLES-1799: When using the /debug parameter, debug information is now collected during custom index generation.

9.3.2.150 – January 10th, 2024

Fixes

• SQLDE
  SQLES-1793: Comparing MS Excel data with MySQL could cause a NullReferenceException during script generation in the synchronization wizard.
• SQLES
  SQLES-1795: Saving a project file in the x86 version of the application could result in an IOException with the message "Invalid handle."

9.3.2.149 – December 14th, 2023

Improvements

• SQLES
  SQLES-1699: File saving for metadata.xml, AppData.dat, Options.xml, and project files is now performed within transactions.

Fixes

• SQLDE
  SQLES-1766: When comparing SQL Server tables containing columns with CLR user-defined types, an error occurred with the message: "Could not load file or assembly '...' or one of its dependencies. The system cannot find the file specified."

9.3.2.148 – December 6th, 2023

Fixes

• SQLES
  SQLES-1762: CLI tool does not correctly handle the /errorlog and /log parameters in some cases, resulting in application crashes and missing log files.

9.3.2.147 – December 1st, 2023

Fixes

• SQLE
  SQLES-1764: In the New Schema Comparison window, configuring a connection to a PostgreSQL database and clicking Next could result in a TypeLoadException. (Reopened)

9.3.2.146 – December 1st, 2023

Fixes

• SQLE
  SQLES-1764: In the New Schema Comparison window, configuring a connection to a PostgreSQL database and clicking Next could result in a TypeLoadException.

9.3.2.145 – November 27th, 2023

Fixes

• SQLDE
  SQLES-1662: In the CLI Wizard, enabling Generate report but disabling Include data in the report led to incorrect command-line /config parameters, and table data was still included in the report.
• SQLDE
  SQLES-1757: In the CLI Wizard, clicking Next on the Choose data sources step could cause a NullReferenceException.

9.3.2.144 – November 17th, 2023

Fixes

• SQLDE
  SQLES-1743: The console could crash while comparing MySQL databases due to a MySqlException with the message: "Transaction characteristics can't be changed while a transaction is in progress."

9.3.2.143 – November 15th, 2023

Fixes

• SQLE
  SQLES-1715: In the Open Project wizard, the content in the Configure Advanced Settings step did not match the selected tab (Filter, or Options, or Schemas).
• SQLE
  SQLES-1728: While comparing MySQL databases using the CLI tool, the application could crash with a KeyNotFoundException: "Keyword 'address' not found."
• SQLE
  SQLES-1729: The CLI tool does not properly process /ScriptFolder1 and /ScriptFolder2 parameters, resulting in the error: "The second data source was not specified."
• SQLE
  SQLES-1730: When parsing MySQL table scripts, syntax errors like "Incorrect syntax near 'ADD'" were incorrectly reported even when syntax was valid.
• SQLDE
  SQLES-1641: Synchronization of Oracle data with the Fix current/last sequence values option enabled could generate invalid scripts, causing an ORA-32793 error: "cannot alter a system-generated sequence."
• SQLDE
  SQLES-1709: Synchronization of PostgreSQL databases could result in a script failure due to: "column 'infinity' does not exist."
• SQLDE
  SQLES-1710: Comparing float values between SQL Server and PostgreSQL in cross-platform scenarios could result in an OverflowException.
• SQLDE
  SQLES-1719: In some data comparison scenarios, the application did not halt on critical errors and continued execution with invalid results.
• SQLDE
  SQLES-1720: When using the console to synchronize MySQL and SQL Server databases with the DirectDataCopy option enabled, an error occurred: "Incorrect syntax near ''."
• SQLES
  SQLES-1732: In some cases, a NullReferenceException occurred while using the console to compare MySQL databases.

9.3.2.142 – October 27, 2023

Improvements

• SQLES
  SQLES-1703: Added ability to remove servers and logins from dropdowns in the UI.

Fixes

• SQLE
  SQLES-1684: PostgreSQL columns wrongly marked as different storage mode.
• SQLDE
  SQLES-1641: When sycndhronizing Oracle databases when "Fix current/last sequence values" option is enabled invalid sync scripts generated (error: ORA-32793).
• SQLDE
  SQLES-1704: NullReferenceException during sync involving new table creation.
• SQLES
  SQLES-1635: PostgreSQL Release Candidate servers were misidentified, causing metadata load failures.
• SQLES
  SQLES-1697: Wrong authentication mode shown in CLI Wizard for MS SQL sources.
• SQLES
  SQLES-1705: App froze when Cancel was clicked in Add Server dialog.

9.3.1.141 – October 20, 2023

Improvements

• SQLE
  SQLES-1689: Added support for ALTER TABLE name CLUSTER ON index_name.

Fixes

• SQLE
  SQLES-1683: Prevented creation of already existing roles during PostgreSQL sync.
• SQLE
  SQLES-1692: Oracle CHECK constraints like COLUMN IS NOT NULL were not loaded.
• SQLE
  SQLES-1681: Fixed parsing issues in PostgreSQL CREATE TABLE statements.

9.3.0.140 – October 17, 2023

Fixes

• SQLE
  SQLES-1682: Computed columns in PostgreSQL were falsely flagged as different.
• SQLDE
  SQLES-1687: Slow retrieval of PostgreSQL FOREIGN KEY metadata.
• SQLDE
  SQLES-1691: UI freeze on clicking Recompare with a filter in Edit Table.

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. (reopened)
• 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. (reopened)
• 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. (reopened)
• SQLDE
  SQLES-1518: In some cases, NullReferenceException occurs when closing Export to CSV wizard.
• 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. (reopened)

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

Improvements

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

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.

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.