SQL Examiner Suite full changelog

Fixes:
Fixed an issue where identical extended property creation statements for SQL Server objects appearing in different parts of a script could result in those properties being created more than once.
In some cases, the PostgreSQL data type timestamp with time zone was incorrectly transformed into timestamp with time zone(0) in synchronization scripts, which is invalid syntax.

SQLES-2298: Fixed the logic of the Add object existence checks option in add/modify/drop column scenarios for SQL Server tables.
SQLES-2223: In the Add Query window, creating a MySQL query containing expressions like INTERVAL N UNIT incorrectly reported a syntax error, although the script is valid (reopened).
SQLES-2287: In some cases, due to an error in the object filter logic, the program generated incorrect synchronization scripts.
SQLES-2290: In some cases, generating a synchronization script for SQL Server database tables caused a NullReferenceException.
SQLES-2291: In some cases, when retrieving metadata about roles in SQL Server 2000 databases, a SqlException occurred with the message "Invalid object name 'sys.sysmembers'.".
SQLES-2289: In some cases, in the Add Query or Edit Query window, if a SQL Server query contained a TRY_PARSE function call with the USING keyword, clicking OK produced a syntax error message like "Incorrect syntax near USING," even though the syntax was valid.
SQLES-2282: Incorrect script was generated for the SQL Server IsLedgerOn database option.
SQLES-2278: In some cases, syntax highlighting for differences in PostgreSQL text objects worked incorrectly.
SQLES-2271: Values of the QueryTimeout option specified in the configuration file or directly in the command line were ignored by the program, which used default values instead (reopened).
SQLES-2279: Updated outdated driver links that were offered to users for installation.
SQLES-2276: Fixed issues in the logic of loading options and exclusions.
SQLES-2276: Added the ability to set values for the LoginTimeout and QueryTimeout options in the CLI Wizard.
SQLES-2276: CLI Wizard now automatically substitutes values of LoginTimeout and QueryTimeout options from Options.
SQLES-2264: In some cases, retrieving column metadata from a PostgreSQL database caused a FormatException.
SQLES-2271: The QueryTimeout value specified in config.xml was not applied when forming the conn

SQLES-2298: Fixed the logic of the Add object existence checks option in add/modify/drop column scenarios for SQL Server tables.
SQLES-2223: In the Add Query window, creating a MySQL query containing expressions like INTERVAL N UNIT incorrectly reported a syntax error, although the script is valid (reopened).
SQLES-2287: In some cases, due to an error in the object filter logic, the program generated incorrect synchronization scripts.
SQLES-2290: In some cases, generating a synchronization script for SQL Server database tables caused a NullReferenceException.
SQLES-2291: In some cases, when retrieving metadata about roles in SQL Server 2000 databases, a SqlException occurred with the message "Invalid object name 'sys.sysmembers'.".
SQLES-2289: In some cases, in the Add Query or Edit Query window, if a SQL Server query contained a TRY_PARSE function call with the USING keyword, clicking OK produced a syntax error message like "Incorrect syntax near USING," even though the syntax was valid.
SQLES-2282: Incorrect script was generated for the SQL Server IsLedgerOn database option.
SQLES-2278: In some cases, syntax highlighting for differences in PostgreSQL text objects worked incorrectly.
SQLES-2271: Values of the QueryTimeout option specified in the configuration file or directly in the command line were ignored by the program, which used default values instead (reopened).
SQLES-2279: Updated outdated driver links that were offered to users for installation.
SQLES-2276: Fixed issues in the logic of loading options and exclusions.
SQLES-2276: Added the ability to set values for the LoginTimeout and QueryTimeout options in the CLI Wizard.
SQLES-2276: CLI Wizard now automatically substitutes values of LoginTimeout and QueryTimeout options from Options.
SQLES-2264: In some cases, retrieving column metadata from a PostgreSQL database caused a FormatException.
SQLES-2271: The QueryTimeout value specified in config.xml was not applied when forming the conn

SQLES-2298: Fixed the logic of the Add object existence checks option in add/modify/drop column scenarios for SQL Server tables.
SQLES-2223: In the Add Query window, creating a MySQL query containing expressions like INTERVAL N UNIT incorrectly reported a syntax error, although the script is valid (reopened).
SQLES-2287: In some cases, due to an error in the object filter logic, the program generated incorrect synchronization scripts.
SQLES-2290: In some cases, generating a synchronization script for SQL Server database tables caused a NullReferenceException.
SQLES-2291: In some cases, when retrieving metadata about roles in SQL Server 2000 databases, a SqlException occurred with the message "Invalid object name 'sys.sysmembers'.".
SQLES-2289: In some cases, in the Add Query or Edit Query window, if a SQL Server query contained a TRY_PARSE function call with the USING keyword, clicking OK produced a syntax error message like "Incorrect syntax near USING," even though the syntax was valid.
SQLES-2282: Incorrect script was generated for the SQL Server IsLedgerOn database option.
SQLES-2278: In some cases, syntax highlighting for differences in PostgreSQL text objects worked incorrectly.
SQLES-2271: Values of the QueryTimeout option specified in the configuration file or directly in the command line were ignored by the program, which used default values instead (reopened).
SQLES-2279: Updated outdated driver links that were offered to users for installation.
SQLES-2276: Fixed issues in the logic of loading options and exclusions.
SQLES-2276: Added the ability to set values for the LoginTimeout and QueryTimeout options in the CLI Wizard.
SQLES-2276: CLI Wizard now automatically substitutes values of LoginTimeout and QueryTimeout options from Options.
SQLES-2264: In some cases, retrieving column metadata from a PostgreSQL database caused a FormatException.
SQLES-2271: The QueryTimeout value specified in config.xml was not applied when forming the conn

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.

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.

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.

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.

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.

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.