SQL Examiner Suite 2018 change log

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

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

7.1.8.337 - April 29th, 2022

Fixes

  • SQLE
    SQLES-982: In rare cases, OdbcException with error message 'Unknown error 1142' occurs when program loads PERMISSION objects from a MySQL database during a comparison.
  • SQLDE
    SQLES-980: In rare cases, when string columns are used as comparison key, identical records in PostgreSQL databases are considered as different (appear on the Only in Source and Only in Target tabs).
  • SQLDE
    In some cases, specified by the user query synchronization settings that prohibited the deletion and updating of data in specific Oracle tables were ignored by the program, which could lead to unplanned data changes.

7.1.8.336 - March 29th, 2022

Fixes

  • SQLE
    SQLES-965: In rare cases, NullReferenceException occurs when generating a report for cross-platform comparison.
  • SQLE
    SQLES-967: If during synchronization it is necessary to recreate a table in which new columns were added with a DEFAULT that uses a function that is not in the target database, the program generates an incorrect synchronization script.
  • SQLE
    SQLES-913: In some cases, when a user opens a comparison from the Recent Comparisons list with the Customize the selected comparison option enabled, NullReferenceException occurs.
  • SQLE
    SQLES-948: In some cases, the program incorrectly processes DEFAULT objects in SQL Server databases, which leads to incorrect displaying while a preview and generating an incorrect synchronization script.
  • SQLE
    SQLES-947: When custom mapping is configured for PostgreSQL schemas with different names, SCHEMA objects are not paired, which leads to incorrect comparison and incorrect generation of synchronization scripts.
  • SQLE
    SQLES-917: The program always displays indexes on the Creation Script tab as different, no matter whether there is a difference. (MSSQL)
  • SQLE
    SQLES-916: In some cases, EXTENDED PROPERTY metadata is being loaded incorrectly from a snapshot. (MSSQL)
  • SQLE
    SQLES-908: The program trims line breaks at the beginning of text objects when loaded SQL Server database snapshots; consequently, when comparing such snapshot with a live database, it displays non-existing differences on the Creation Script tab.
  • SQLE
    SQLES-915: In some cases, text objects metadata is being loaded incorrectly. (MSSQL)
  • SQLE
    SQLES-914: Under certain conditions, when the program compares text objects in SQL Server databases, the Ignore tabs, spaces, etc. is not taken into account, which leads to incorrect comparison results. (MSSQL)
  • SQLDE
    SQLES-925: In rare cases, Skip and Stop buttons do not stop comparison but cause the program to hang.
  • SQLDE
    SQLES-943: In some cases, when synchronizing data using the CLI tool, the program terminates unexpectedly without reporting any errors.
  • SQLDE
    SQLES-950: In rare cases, when an exception occurs during data comparison, the program displays the error message, but does not offer to send an error report, although it should.
  • SQLDE
    SQLES-951: In some cases, when using the /debug option, some debug info is not written to log files.
  • SQLDE
    SQLES-824: In some cases, Exception occurs after editing a query in the Edit Query window when user switches from the Queries tab to the Comparison Keys tab.
  • SQLES
    SQLES-869: Under certain conditions, the program does not delete all created temporary files on close.
  • SQLES
    SQLES-876: Now program collects more debug info when an error occurs during comparison or synchronization.
  • SQLES
    SQLES-887: Under certain conditions, InvalidOperationException occurs during project load when user mapping was applied in the project.
  • SQLES
    SQLES-906: In rare cases, ArgumentException occurs when the program loads metadata from a database.
  • SQLES
    SQLES-952: In some cases, ArgumentNullException occurs when user starts Task Scheduler wizard.
  • SQLES
    SQLES-962: If the program was launched with the /debug parameter and a connection error occurred when connecting to a database, then it was processed incorrectly and led to a NullReferenceException.
  • SQLES
    SQLES-822: In very rare cases, InvalidOperationException occurs when user manually runs Check for Update.
  • SQLES
    SQLES-961: In very rare cases, NullReferenceException occurs when user starts New Project wizard (caused by an error in error handling when loading information about installed ORACLE instances from Windows Registry).

7.1.8.335 - December 13th, 2021

Fixes

  • SQLE
    SQLES-884: In rare cases, NullReferenceException occurs in cross-platform schema comparisons.

7.1.8.334 - November 9th, 2021

Fixes

  • SQLE
    SQLES-859: In some cases, the program incorrectly determines PostgreSQL version, which can lead to OdbcException while loading metadata
  • SQLDE
    SQLES-860: Under certain conditions, while comparing floating-point values in cross-platform comparisons, identical values are displayed as different

7.1.8.333 - November 3th, 2021

Fixes

  • SQLE
    SQLES-858: In some cases, when Partial Synchronization mode is enabled, NotImplementedException occurs while synchronizing User-Defined Table Types (MSSQL)

7.1.8.332 - October 26th, 2021

Fixes

  • SQLE
    SQLES-849: Workaround an issue when the program cannot load indexes and statistics metadata if some columns in system tables have different collations; metadata load fails with SqlException and "Cannot resolve the collation conflict between Danish_Norwegian_CI_AS and SQL_Latin1_General_CP1_CI_AS in the UNION operation." message. Different collations in system tables of a database typically mean that the database is corrupted, but the issue is not critical and can be worked around (MSSQL)
  • SQLE
    SQLES-854: In some cases, when parsing the DECLARE statement in SQL Server's text objects, the program does not detect some dependencies, leading to synchronization issues

7.1.8.331 - October 22th, 2021

Fixes

  • SQLE
    SQLES-853: When MySQL tables differ in indexes on columns used in a FOREIGN KEY constraint, which also differs in source and target, the program synchronizes these differences in the wrong order

7.1.8.330 - October 18th, 2021

Fixes

  • SQLDE
    SQLES-850: In some cases, when editing a query in the New Query window, if the query contained CROSS APPLY, an error occurred when parsing the query and the program reported a syntax error, although there were no errors in the query.

7.1.8.329 - October 12th, 2021

Fixes

  • SQLE
    SQLES-846: In some cases, when Partial Synchronization mode is enabled, program tries to create an index on previously deleted column (All databases)

7.1.8.328 - October 1th, 2021

Fixes

  • SQLDE
    SQLES-844: In some cases, the program incorrectly compares data from CSV and Oracle tables compared by a string key, due to an error, identical data is considered different (defined as Only In Source and Only In Target)

7.1.8.327 - September 28th, 2021

Fixes

  • SQLES
    SQLES-842: The program does not perform %DB substitution in file name templates
  • SQLES
    SQLES-838: In some cases, when parsing MS SQL scripts, a syntax error occurs if unshielded values that match the reserved MSSQL keywords are used as identifier names

7.1.8.326 - September 22th, 2021

Fixes

  • SQLDE
    SQLES-831: In some cases, when parsing a query to the PostgreSQL database in the Add query window, the "Incorrect syntax next to 'NULL'" error occurs
    REOPENED

7.1.8.325 - September 20th, 2021

Fixes

  • SQLDE
    SQLES-834: In some cases, an OutOfMemoryException occurs when comparing data

7.1.8.324 - September 17th, 2021

Fixes

  • SQLES
    SQLES-821: Added keyboard shortcut for menu items Edit > Previous Difference Ctrl+, and Edit > Next Difference Ctrl+.
  • SQLDE
    SQLES-833: In some cases, if the query text contains the column name with the COLLATE indication, then when parsing this query in the Add Query window, a syntax error occurs (MSSQL)
  • SQLDE
    SQLES-831: In some cases, when parsing a query in the Add Query window, the error "Incorrect syntax near 'NULL'" occurs (PostgreSQL)

7.1.8.323 - September 6th, 2021

Fixes

  • SQLES
    SQLES-816: "ERROR 42501: must be superuser to examine "server_version" when connecting to Amazon Redshift PostgreSQL
  • SQLDE
    SQLES-806: In the Edit Table window, it was inconvenient to configure custom column mapping, because they are not arranged in alphabetical order in the drop-down list and in cases of a large number of columns, the last of them were not visible, because their display went beyond the screen, and the scroll bar was missing, which made it necessary to select them blindly

7.1.8.322 - August 11th, 2021

Fixes

  • SQLDE
    SQLES-800: In some cases, when parsing a query in the New Query window, if the query text contains a call to the COUNT function with additional parameters, the program throws the error "Line N, col M: rightroundbracket expected" (All databases)

7.1.8.321 - July 9th, 2021

Fixes

  • SQLDE
    SQLES-785: In some cases, when parsing a query to an Oracle database in the New Query window, a syntax error occurs if the query uses analytical functions (e.g. ROW_NUMBER), although in fact the query is correct

7.1.8.320 - June 24th, 2021

Fixes

  • SQLDE
    SQLES-769: In some cases, when trying to apply the WHERE filter in the Edit Table window, a TargetInvocationException occurs
  • SQLES
    SQLES-742: In some cases, calling File > Close Project led to the deletion of the closed project from the list of recent comparisons in the Recent Comparison wizard

7.1.8.319 - June 3th, 2021

Fixes

  • SQLE
    SQLES-738: When comparing Oracle databases, the program did not detect differences in the order of columns in tables, despite the fact that the Keep column order option is enabled
  • SQLE
    SQLES-754: In some cases, when trying to open a previously saved project, an InvalidCastException occurs
  • SQLE
    SQLES-741: In some cases, when reading FULLTEXT CATALOG metadata (MS SQL Server database), an exception InvalidCastException occurs
  • SQLE
    SQLES-744: In some cases, when comparing text objects (MySQL databases) that differ only by the attribute SQL SECURITY, differences are visible in the scripts on the Creation Script tab, but it is impossible to select these objects in the Object Tree, because they are blocked
  • SQLDE
    SQLES-755: In the wizard New Data Comparison at step Select Tables for Comparison the program does not allow you to select a column with the binary(N) type as a comparison key
  • SQLDE
    SQLES-757: In some cases, when synchronizing data of the BINARY type, between the MySQL database and SQL Server, the error "Implicit conversion from data type varchar to binary is not allowed" may occur. Use the CONVERT function to run this query."

7.1.8.318 - May 24th, 2021

Fixes

  • SQLDE
    SQLES-732: In some cases, when specifying a data filter in the Edit Table window on the Filter tab, the "Tablename: LineN, com: ident expected" error has been occurred
  • SQLE
    SQLES-734: In some cases, an InvalidCastException occurs when saving a project

7.1.8.317 - May 24th, 2021

Fixes

  • SQLDE
    SQLES-722: If the Use SQL Loader option is enabled in the synchronization wizard, the program does not allow you to change the path for saving synchronization files, and file saving does not occur (Oracle)
  • SQLDE
    SQLES-726: In some cases, when user tries to update an Oracle database by running the Synchronize.cmd when the Use SQL Loader option is enabled, synchronization fails with SP2-0042 error
  • SQLDE
    SQLES-730: In some cases, when synchronizing the Oracle database with the Use SQL Loader option enabled, synchronization errors may occur or LOB data after synchronization may contain extra characters

7.1.8.316 - May 13th, 2021

Improvements

  • SQLDE
    SQLES-724: When syncing using the Use SQL Loader option, the command and control files used relative file paths (Oracle)

Fixes

  • SQLE
    SQLES-702: For MySQL and Oracle databases, the program incorrectly calculated the synchronization progress displayed in Synchronize Wizard, it was always shown as 0%
  • SQLE
    SQLES-703: In some cases, when tables differ by indexes superimposed on a column with the AUTO_INCREMENT attribute, sometimes the program generated an incorrect sequence of synchronization commands, which leads to synchronization errors (MySQL)
  • SQLE
    SQLES-728: In some cases, scripts on the Creation Script tab in the main program window (MSSQL) are displayed incorrectly for the EXTENDED PROPERTY object)
  • SQLDE
    SQLES-722: If the Use SQL Loader option is enabled in the synchronization wizard, the program does not allow you to change the path for saving synchronization files, and file saving does not occur (Oracle)
  • SQLDE
    SQLES-723: When synchronizing data using the Use SQL Loader option, the path for synchronization logs in the batch file is now set explicitly to avoid possible problems with access rights to certain folders (Oracle)
  • SQLES
    SQLES-683: In some cases, when connecting to the SQL Server database, the New Project wizard showed a warning SQL Server compatibility warning, although there is no reason for this

7.1.8.315 - March 29th, 2021

Fixes

  • SQLDE
    SQLES-689: In some cases, when working with MySQL databases, when synchronizing column data with the JSON type, the program does not escape special characters when generating the synchronization script, which sometimes leads to synchronization errors

7.1.8.314 - March 26th, 2021

Fixes

  • SQLE
    SQLES-685: When processing the links of text objects, the links of internal objects (text object) were not taken into account, which in some cases led to the generation of an incorrect synchronization script (some commands were missing)

7.1.8.313 - March 3th, 2021

Fixes

  • SQLES
    SQLES-672: In some cases, when the CLI Wizard was started when creating a task in the Task Scheduler wizard, the connection settings generated by the wizard could be incorrect

7.1.8.312 - February 12th, 2021

Improvements

  • SQLE
    SQLES-656: Add support Masked Columns (MSSQL)

7.1.8.311 - December 23th, 2020

Fixes

  • SQLE
    SQLES-651: In some cases, when working with Oracle databases, when extracting the metadata of text objects, an exception ArgumentOutOfRangeException
  • SQLDE
    SQLES-653: In some cases, when working with Oracle databases, synchronization errors occur when the Batch mode and Preview synchronization script options are enabled

7.1.8.310 - December 16th, 2020

Fixes

  • SQLDE
    SQLES-650: In some cases, some of the information from the configuration file was not loaded, which is why query synchronization did not work (Oracle)

7.1.8.309 - December 15th, 2020

Fixes

  • SQLES
    SQLES-611: Logging library downloads ODP.NET drivers (Oracle)
  • SQLES
    SQLES-649: In some cases, when comparing MSSQL vs Oracle floating-point numeric values, a NullReferencesException occurred

7.1.8.308 - December 11th, 2020

Fixes

  • SQLDE
    SQLES-647: When calling Tools>Export Data the wizard did not start
  • SQLES
    SQLES-611: In some cases, the programs do not see the installed ODP.NET driver (Oracle)

7.1.8.307 - December 1th, 2020

Fixes

  • SQLDE
    SQLES-597: If columns with a string data type are used as a comparison key and the data in the key columns contains a hyphen character, then in some cases this may lead to an incorrect comparison (MSSQL only)
    REOPENED

7.1.8.306 - November 19th, 2020

Fixes

  • SQLE
    SQLES-631: When reading schema from ScriptFolder/ScriptFile sources, some FUNCTION objects are not linked to other objects (MSSQL)
    REOPENED
  • SQLDE
    SQLES-641: In some cases, an ArgumentException occurs when trying to view table data, generate a report, or synchronize it (MySQL)
  • SQLDE
    SQLES-636: Backup data from columns with the geography type in some cases, is displayed with reduced accuracy (MSSQL)

7.1.8.305 - November 16th, 2020

Fixes

  • SQLE
    SQL-639: If the source type is scripts, then parsing them does not determine the relationship between Sequence and Table, which can lead to synchronization errors (MSSQL)
  • SQLE
    SALES-637: NotImplementedException when processing UDT table type (MSSQL) dependencies

7.1.8.304 - November 10th, 2020

Fixes

  • SQLE
    SQLES-635: Index expressions were not displayed (PostgreSQL)

7.1.8.303 - November 9th, 2020

  • SQLE
    SQLES-633: All CREATE TYPE scripts do not display the precision for a custom type created based on the datetime2, datetimeoffset, time (MSSQL)
    REOPENED

7.1.8.302 - November 6th, 2020

Fixes

  • SQLE
    SQLES-633: All CREATE TYPE scripts do not display the precision for a custom type created based on the datetime2, datetimeoffset, time (MSSQL) types
  • SQLDE
    SQLES-634: Add debug info

7.1.8.301 - October 30th, 2020

Fixes

  • SQLE
    SQLES-631: In some cases, when parsing scripts of text objects using the CROSS APPLY operator, links between objects are not created, which can lead to synchronization errors (MSSQL)
  • SQLE
    SQLES-628: In some cases, when extracting the metadata of the PACKAGE and TYPE objects, a NotSupportedException occurs (Oracle)

7.1.8.300 - October 15th, 2020

Fixes

  • SQLE
    SQLES-503: When synchronizing permissions in PostgreSQL databases, an user name specified in the GRANT command was not escaped, which in some cases leads to an error during synchronization
    REOPENED

7.1.8.299 - October 13th, 2020

Fixes

  • SQLDE
    SQLES-627: In some cases (if the server version is 2000 or less), when getting a list of schemas, a SQLException (MSSQL)

7.1.8.298 - October 5th, 2020

Fixes

  • SQLE
    SQLES-614: For the ‘Extended Properties’ object, the synchronization option Add object existence checks does not work (the script is generated incorrectly) (MSSQL)
  • SQLE
    SQLES-617: In some cases, an InvalidCastException (MSSQL) occurs when retrieving index metadata
  • SQLE
    SQLES-604: System triggers, roles, and schemas created when replication was enabled for MSSQL databases were retrieved

7.1.8.297 - September 30th, 2020

Fixes

  • SQLE
    SQLES-618: In some cases, the metadata of text objects was not fully extracted, some objects were skipped (Oracle)
  • SQLE
    SQLES-616: In some cases, when the Add object existence checks option was enabled, the script for creating text objects was generated incorrectly (MSSQL)
  • SQLDE
    SQLES-620: When calling Report Comparison Problem, information about the Oracle driver used was not included

7.1.8.296 - September 11th, 2020

Fixes

  • SQLDE
    SQLES-602: In some cases, when synchronizing (INSERT) large amounts of data, an OutOfMemoryException occurs (On 64-bit systems, the problem is not detected)

7.1.8.295 - September 9th, 2020

Fixes

  • SQLE
    #2329: When working with SQL Server in ALTER INDEX scripts, the table name is not escaped, which in some cases leads to an error during synchronization

7.1.8.294 - September 3th, 2020

Fixes

  • SQLDE
    SQLES-597: In some cases, when a key containing string columns is used to compare data, the comparison is performed incorrectly (MSSQL)

7.1.8.293 - Jule 10th, 2020

Fixes

  • SQLE
    SQLES-550: Error parsing function parameters (PostgreSQL)
    REOPENED

7.1.8.292 - Jule 17th, 2020

Fixes

  • SQLE
    SQLES-550: Error parsing function parameters (PostgreSQL)

7.1.8.291 - Jule 10th, 2020

Fixes

  • SQLE
    SQLES-534: In the Snapshot Wizard and Script Database, data about PostgreSQL servers was not loaded, i.e. the list of servers is always empty
  • SQLDE
    SQLES-496: Minor UI bug: Nag screen issue
  • SQLDE
    SQLES-445: UI Bug: CLI wizard > Options > Comparison Performance Options
  • SQLES
    SQLES-533: In some cases, an ArgumentException occurs when retrieving metadata about indexes

7.1.8.290 - June 30th, 2020

Fixes

  • SQLE
    SQLES-503: In some cases, when working with PostgreSQL in REVOKE scripts, the names of roles and users are not escaped
  • SQLE
    SQLES-505: In some cases, when working with PostgreSQL, there were errors in the synchronization logic (processing links) of restrictions, which caused the order of synchronization commands to be violated
  • SQLE
    SQLES-524: DEFINER clause in the code of text objects is not escaped correctly (MySQL)
  • SQLES
    SQLES-520: Disable sending notifications when checking for updates (InvalidOperationException)

7.1.8.289 - June 19th, 2020

Fixes

  • SQLDE
    SQLES-511: The CLI Wizard does not take into account the ODBC data source connection settings when creating an XML configuration if the DSN is used to connect to the ODBC data source

7.1.8.288 - June 11th, 2020

Fixes

  • SQLDE
    SQLES-493: InvalidCastException when synchronizing data from Oracle to MSSQL database when using Use Bulk Load option under certain conditions
  • SQLDE
    SQLES-483: ArgumentException when loading database metadata from Advantage Database Server using the ODBC or OLEDB driver
    REOPENED

7.1.8.287 - June 8th, 2020

Fixes

  • SQLDE
    SQLES-483: ArgumentException when loading database metadata from Advantage Database Server using the ODBC or OLEDB driver
    REOPENED

7.1.8.286 - June 5th, 2020

Fixes

  • SQLE
    SQLES-485: In some cases, GRANT permissions in MSSQL database creation SQL scripts are parsed incorrectly
  • SQLDE
    SQLES-483: ArgumentException when loading database metadata from Advantage Database Server using the ODBC or OLEDB driver
    REOPENED

7.1.8.285 - June 4th, 2020

Fixes

  • SQLE
    SQLES-473: NullReferencesException when synchronizing tables under certain conditions (MSSQL)
  • SQLE
    SQLES-32: In certain cases, the Ignore fulltext search objects and properties option does not work correctly when comparing MSSQL databases
  • SQLE
    SQLES-32: In some cases, when two MSSQL databases are being synchronized, the COMPATIBILITY_LEVEL database option is not synchronized correctly when the target server has a lower version than the source
  • SQLDE
    SQLES-81: In some cases, when saving data from a cell in the data grid to a file with Right-click: Save Field Value..., the data was saved incorrectly
  • SQLDE
    SQLES-138: The number of compared records is not calculated correctly when comparing with an empty database
  • SQLDE
    SQLES-472: The automatic selection of comparison keys does not work correctly under certain conditions (both in the GUI and in the CLI)
  • SQLDE
    SQLES-474: NullReferenceException when adding a custom mapping to the comparison when creating a new one or editing the current project
  • SQLDE
    SQLES-478: Object List does not change selected item on right-click
  • SQLDE
    SQLES-483: ArgumentException when loading database metadata from Advantage Database Server using the ODBC or OLEDB driver
  • SQLDE
    SQLES-84: Fixed some minor UI issues

7.1.8.284 - May 25th, 2020

Improvements

  • SQLES
    SQLES-382: Added the Ignore Collations option for MySQL tables and columns

Fixes

  • SQLE
    SQLES-44: Unable to restore the Current Line pane when hidden
  • SQLE
    SQLES-460: Incorrect synchronization script for PostgreSQL when column data type was changed
  • SQLDE
    SQLES-457: CLI wizard does not take the Encrypt Connection option into account when generates XML-config
  • SQLDE
    SQLES-455: InvalidCastException when read a value from numeric column on a PostgreSQL when value out of range ‘System.Decimal’
  • SQLES
    SQLES-468: Tooltip is not hidden properly in the Task Scheduler window

7.1.8.283 - May 12th, 2020

Fixes

  • SQLE
    SQLES-375: Incorrect synchronization in Partial Syncronization mode in MySQL databases
  • SQLDE
    #2663: Minor UI bug: a last key column was not fixed in the data grid

7.1.8.282 - May 7th, 2020

Fixes

  • SQLES
    SQLES-441: MSSQL version warning shown when should not
  • SQLES
    SQLES-441: UI bug: MSSQL compatibility version warning layout issue on HiDPI screens

7.1.8.281 - April 21th, 2020

Fixes

  • SQLE
    SQLES-440: PostgreSQL text objects are not synchronized correctly in certain cases

7.1.8.280 - April 16th, 2020

Fixes

  • SQLE
    SQLES-436: Exception when analyzing metadata user-defined function from a PostrgreSQL database under certain conditions

7.1.8.279 - April 13th, 2020

Fixes

  • SQLES
    SQLES-434: AggregateException occurred while handling an error when connecting to Azure SQL Database when MFA is enabled

7.1.8.278 - April 9th, 2020

Fixes

  • SQLDE
    SQLES-435: InvalidCastException when comparing boolean types with other data types under certain conditions

7.1.8.277 - April 8th, 2020

Fixes

  • SQLE
    SQLES-434: Exception when comparing foreign keys between MSSQL and MySQL

7.1.8.276 - April 7th, 2020

Improvements

  • SQLES
    SQLES-432: Connecting to Azure SQL Database without explicitly specifying App ID and Redirect URI when multi-factor authentication is enabled

7.1.8.275 - March 31st, 2020

Fixes

  • SQLES
    SQLES-429: PostgreSQL connection error if password contains certain characters

7.1.8.274 - March 13th, 2020

Fixes

  • SQLE
    SQLES-425: Exception when analyzing metadata user-defined function from a PostrgreSQL database under certain conditions

7.1.8.273 - February 18th, 2020

Improvements

  • SQLDE
    SQLES-413: Display more detailed error info (if any) when data reading error occurs
  • SQLES
    #3099: Added SSMS 2019 to the External Tools list

Fixes

  • SQLDE
    SQLES-412: Error when NULLs are returned instead of actual values when reading data from MSSQL backup

7.1.8.272 - January 22nd, 2020

Fixes

  • SQLDE
    SQLES-403: Issues in schema mapping
  • SQLDE
    SQLES-405: NullReferenceException when synchronizing data in MySQL under certain conditions
  • SQLDE
    SQLES-407: For some SQL Azure tables, the program showed a warning about the inability to insert and did not generate INSERT statements, although there is no real reason for this

7.1.8.271 - January 10th, 2020

Fixes

  • SQLDE
    SQLES-405: Incorrect handling of synchronization errors when inserting/updating data in MySQL

7.1.8.270 - December 30th, 2019

Improvements

  • SQLE
    SQLES-401: Added the ability to compare and synchronize the state of triggers in a PostgreSQL database

7.1.8.269 - December 27th, 2019

Fixes

  • SQLES
    SQLES-402: Fixed a Check for Updates issue after switching the www.sqlaccessories.com website to HTTPS protocol.

7.1.8.268 - December 23th, 2019

Fixes

  • SQLE
    SQLES-397: In some cases, error when extracting triggers metadata from MariaDB
  • SQLE
    SQLES-397: In some cases, issue when stored procedures and user-defined functions are not compared correctly in MariaDB

7.1.8.267 - December 20th, 2019

Fixes

  • SQLDE
    SQLES-399: Schema mapping works incorrectly for ODBC and OLEDB data sources in certain cases

7.1.8.266 - December 9th, 2019

Fixes

  • SQLE
    SQLES-396: NullReferenceException when loading a project due to a schema mapping processing error

7.1.8.265 - December 4th, 2019

Fixes

  • SQLE
    SQLES-389: Incorrect extraction / comparison / synchronization of the HISTORY_RETENTION_PERIOD property of TEMPORAL tables under certain conditions
  • SQLE
    SQLES-393: Issue when comparing and synchronizing user-defined functions in PostgreSQL databases under certain conditions

7.1.8.264 - December 3rd, 2019

Fixes

  • SQLE
    SQLES-392: In some cases a synchronization error occurs due to incorrect processing relations between TABLE and VIEW objects (MSSQL)
  • SQLE
    SQLES-369: Some error when extracting metadata of stored procedures and user-defined functions in PostgreSQL versions prior to PostgreSQL 11

7.1.8.263 - November 29th, 2019

Improvements

  • SQLE
    SQLES-388: Added comparison / synchronization of the HISTORY_RETENTION_PERIOD property of TEMPORAL tables (MSSQL)

Fixes

  • SQLE
    SQLES-155: Incorrect synchronization script when re-creating PostgreSQL tables due to an incorrect INSERT script for values of an IDENTITY column

7.1.8.262 - November 22nd, 2019

Fixes

  • SQLE
    SQLES-380: Issue when connecting to MSSQL 2000
  • SQLDE
    SQLES-385: IndexOutOfRangeException when double-clicking on a column header in the Object List in the Main Window

7.1.8.261 - November 14th, 2019

Fixes

  • SQLE
    SQLES-155: IndexOutOfRangeException when retrieving table and column metadata from a PostgreSQL 12 database under certain conditions
    REOPENED
  • SQLE
    SQLES-155: In some cases, synchronization script for columns and DOMAIN objects is not generated correctly when COLLATION is explicitly defined (PostgreSQL)

7.1.8.260 - November 13th, 2019

Fixes

  • SQLDE
    SQLES-377: Synchronization script (INSERT, UPDATE statements) for a table with computed columns is not generated correctly (PostrgreSQL 12 and higher)

Fixes

  • SQLE
    SQLES-155: IndexOutOfRangeException when retrieving table and column metadata from a PostgreSQL 12 database under certain conditions
  • SQLDE
    SQLES-155: Synchronization script (INSERT statements) for a table with IDENTITY column is not generated correctly (PostrgreSQL 12)

7.1.8.259 - November 12th, 2019

Fixes

  • SQLE
    SQLES-379: In some cases, Incorrect comparison of columns with ‘AUTO_INCREMENT’ attribute in MySQL databases
  • SQLE
    SQLES-379: In some cases, bug when synchronizing DEFAULT constraint in MariaDB database
  • SQLE
    SQLES-261: In some cases an error occurred while synchronizing a table in a MySQL database with an UNIQUE index (not a PRIMARY KEY index) on an AUTO_INCREMENT column

7.1.8.258 - November 1st, 2019

Fixes

  • SQLDE
    SQLES-374: In some cases when synchronizing data returned by SQL queries, synchronizing was not worked

7.1.8.257 - October 24th, 2019

Improvements

  • SQLDE
    SQLES-372: Added the Round float types up to N digits option (default is 3)

7.1.7.256 - October 18th, 2019

Fixes

  • SQLDE
    SQLES-371: A TimeoutException is not handled when the DataReader is closed, which leads to a program crash, although the error is not critical and the program should continue to work

7.1.7.255 - October 16th, 2019

Fixes

  • SQLDE
    SQLES-366: Minor UI bug in CLI Wizard at HiDPI displays
  • SQLDE
    SQLES-367: In some cases, the program incorrectly selects the index that is used when comparing data
  • SQLDE
    SQLES-368: Error during cross-platform comparison when comparing data of type bit (MSSQL) and tinyint(1) (MySQL)

7.1.7.254 - October 8th, 2019

Improvements

  • SQLES
    SQLES-364: Added collecting of detailed debug information when InvalidOperationException occurred when loading schema mapping

7.1.7.253 - September 11th, 2019

Fixes

  • SQLE
    SQLES-351: Changes in schema mapping made in the Edit Project window are not saved

7.1.7.252 - August 14th, 2019

Fixes

  • SQLDE
    SQLES-243: Error during cross-platform comparison of the results of SQL queries to columns with types number(15,2) (Oracle) and numeric(15,2) (MSSQL)
    REOPENED

7.1.7.251 - July 22nd, 2019

Fixes

  • SQLE
    SQLES-341: SqlException Invalid column name 'is_hidden when retrieving column metadata from a MSSQL database under certain conditions
  • SQLE
    SQLES-342: Fixed a bug when synhronizing DEFAULT constraint in MySQL database under certain conditions
  • SQLDE
    Minor UI bug in Edit Query window at HiDPI displays

7.1.7.250 - July 12th, 2019

Fixes

  • SQLE
    SQLES-336: Certain table properties, HASH indexes, and CLR objects are not retrieved from Azure SQL Database under certain conditions
  • SQLDE
    SQLES-326: In some cases, synchronization progress and the remaining synchronization time are not displayed correctly

7.1.7.249 - June 27th, 2019

Fixes

  • SQLDE
    SQLES-323: When connecting to MSSQL using OLEDB or ODBC driver, schema mapping does not work properly, because of which many tables were not automatically matched for comparison
  • SQLDE
    SQLES-323: Exception when retrieving column metadata when connecting to a MSSQL database using an OLEDB driver
  • SQLES
    In rare cases, an exception when checking for program updates

7.1.7.248 - June 27th, 2019

Improvements

  • SQLDE
    SQLES-322: Improve exception handling during data extraction so that the program can continue to work in case of data extraction errors

7.1.7.247 - June 26th, 2019

Improvements

  • SQLDE
    SQLES-322: Add an additional tab that shows records that could not be read

7.1.7.246 - June 21st, 2019

Improvements

  • SQLDE
    Added collecting of detailed debug information when IndexOutOfRangeException occurred when retrieving data from databases

7.1.7.245 - June 19th, 2019

Fixes

  • SQLE
    SQLES-229: IndexOutOfRangeException when retrieving SEQUENCE object metadata from a PostgreSQL database (PostgreSQL 9.6 and older)
  • SQLES
    SQLES-178: NotV2SupportedException when update a Task Scheduler task to the Windows 10 compatible format

7.1.7.244 - June 6th, 2019

Fixes

  • SQLDE
    SQLES-314: An error occurred when BULK LOAD data into a MSSQL database under certain conditions

7.1.7.243 - June 4th, 2019

Improvements

  • SQLE
    Partial support of the PotgreSQL 10. Added support for IDENTITY columns and some properties of the SEQUENCE object

7.1.7.242 - May 31st, 2019

Improvements

  • SQLDE
    SQLES-314: Added the ability to use BULK LOAD when a table in a target MSSQL database contains columns with types geometry, geography, hierarchyId

Fixes

  • SQLDE
    SQLES-314: An incorrect warning about the impossibility of using the BULK LOAD is displayed when a table in a target MSSQL database contains computed columns

7.1.7.241 - May 24th, 2019

Improvements

  • SQLDE
    SQLES-314: Added the ability to use Use Bulk Load when loading data into Azure SQL Database
  • SQLES
    Added SSMS 2017 to the External Tools list

7.1.7.240 - May 23rd, 2019

Fixes

  • SQLE
    #2738: In some cases a synchronization error occurs due to incorrect processing relations between ASSEMBLY objects (MSSQL)
    REOPENED

7.1.7.239 - May 17th, 2019

Fixes

  • SQLE
    #2738: In some cases a synchronization error occurs due to incorrect processing relations between ASSEMBLY objects (MSSQL)

7.1.7.238 - May 14th, 2019

Fixes

  • SQLES
    #3097: MSSQL on Linux: an error while creating backup before synchronization because of incorrectly formed path

7.1.7.237 - May 6th, 2019

Fixes

  • SQLDE
    SQLES-303: IndexOutOfRangeException when parsing some CSV files under certain conditions
    REOPENED

7.1.7.236 - April 26th, 2019

Fixes

  • SQLDE
    SQLES-303: NullReferenceException when parsing a CSV file if key columns contains NULL values
    REOPENED

7.1.7.235 - April 24th, 2019

Fixes

  • SQLDE
    SQLES-303: NullReferenceException when parsing a CSV file if key columns contains NULL values
    REOPENED
  • SQLDE
    SQLES-303: An error when building index while parsing a CSV file under certain conditions
    REOPENED

7.1.7.234 - April 19th, 2019

Fixes

  • SQLE
    #2753: An error in some cases when saving/loading a database snapshot to/from Git
  • SQLDE
    #2676: Incorrect synchronization script under certain conditions when Batch mode option is enabled (MSSQL)

7.1.7.233 - April 17th, 2019

Fixes

  • SQLDE
    SQLES-303: NullReferenceException when parsing a CSV file if key columns contains NULL values
    REOPENED

7.1.7.232 - April 15th, 2019

Fixes

  • SQLDE
    SQLES-303: NullReferenceException when parsing a CSV file if key columns contains NULL values
  • SQLDE
    #2676: NullReferenceException in some cases when Preview synchronization script option is enable in the Synchronize wizard

7.1.7.231 - April 12th, 2019

Fixes

  • SQLE
    #2710: An error when comparing the EDITIONABLE property of text objects in Oracle databases if source or target database does not support this property
  • SQLE
    SQLES-300: An error when connecting to Git in certain cases
  • SQLDE
    SQLES-301: In certain cases changes performed within a transaction was not rolled back on error when Batch mode option is enabled

7.1.7.230 - April 5th, 2019

Fixes

  • SQLES
    SQLES-298: An error when using Task scheduler in Windows XP/2003

7.1.7.229 - April 2nd, 2019

Fixes

  • SQLE
    SQLES-286: An error occurred when re-creating a table with an IDENTITY column in a MSSQL database in certain cases

7.1.7.228 - March 25th, 2019

Fixes

  • SQLE
    SQLES-286: An error when handling the NullInsertWarning in the CLI (MSSQL)

7.1.7.227 - March 22nd, 2019

Improvements

  • SQLE
    SQLES-286: Added the NullInsertWarningMode option to the CLI which manages how program handles changing column definition from NULL to NOT NULL when there are existing ‘NULL’ values in the column

Fixes

  • SQLE
    SQLES-275: An error when synchronizing stored procedures and user-defined functions in MySQL databases in certain cases

7.1.7.226 - March 18th, 2019

Improvements

  • SQLDE
    #2663: Display more detailed error message when connection using an OLEDB provider was unsuccessful

Fixes

  • SQLE
    #3026: An error 'Timeout period elapsed prior and max pool size was reached to obtaining a connection from the pool' when connection to a MySQL database is opened before synchronization

7.1.7.225 - March 12th, 2019

Improvements

  • SQLES
    SQLES-98: Under the hood updates: refactoring of exception handling while synchronizing MySQL databases

7.1.7.224 - March 6th, 2019

Fixes

  • SQLES
    #3090: An error when opening previously saved comparison project if source or target database is Azure SQL Database with MFA

7.1.7.223 - March 5th, 2019

Fixes

  • SQLDE
    SQLES-284: Values in columns with types BINARY_FLOAT and BINARY_DOUBLE in an Oracle database are not compared correctly

7.1.7.222 - February 26th, 2019

Improvements

  • SQLES
    Added support for MFA when connecting to an Azure SQL Database

7.1.6.221 - February 25th, 2019

Fixes

  • SQLE
    SQLES-281: In some cases, ALTER DATABASE statements in SQL script are parsed incorrectly (MSSQL)

7.1.6.220 - February 21st, 2019

Improvement

  • SQLE
    #3089: Added an ability to specify column renaming settings in the CLI Wizard

7.1.6.219 - February 13th, 2019

Improvements

  • SQLE
    #3089: Added an ability to specify column renaming settings in CLI (the /ColumnRenamingOptions parameter has been added)

Fixes

  • SQLE
    #3088: Issues while mcoparing constraints in cross-platform comparisons when comparing MSSQL and Oracle databases

7.1.6.218 - February 12th, 2019

Fixes

SQLE
#3088: Issues while comparing tables in cross-platform comparisons when comparing MSSQL and Oracle databases

7.1.6.217 - February 8th, 2019

Improvements

SQLE
#3076: In some cases, the synchronization script returned incorrect metadata for text objects, resulting in a text object synchronization error (MySQL)

7.1.6.216 - February 6th, 2019

Improvements

  • SQLES
    #3026: Added an ability to specify a value of the Pooling parameter in Windows Registry and pass this value to connection string when connecting to an MySQL database

Fixes

  • SQLE
    #3087: Separate commands with $$ delimiter instead of ; when synchronizing text objects in MySQL databases

7.1.6.215 - February 4th, 2019

Fixes

  • SQLE
    SQLES-272: ArgumentNullException when retrieving indexes metadata from an Oracle database under certain conditions
    REOPENED

7.1.6.214 - February 1st, 2019

Fixes

  • SQLE
    SQLES-272: ArgumentNullException when retrieving indexes metadata from an Oracle database under certain conditions
  • SQLDE
    SQLES-260: In some cases, when opening projects created in newer versions of the program, a NullReferenceException occurs

7.1.6.213 - January 23rd, 2019

Fixes

  • SQLES
    #2880: The /Encoding parameter processed incorrectly in CLI
  • SQLES
    SQLES-264: Issues when synchronizing tables in MSSQL databases with different cluster indexes

7.1.6.212 - January 14th, 2019

Fixes

  • SQLE
    #3085: The CLI Wizard incorrectly saves some options to an XML configuration file
  • SQLE
    #3085: Problems reading parameters from the XML configuration file in some cases. Now the attribute names in the XML configuration file are not case sensitive
  • SQLE
    #3085: Script updating options are applied incorrectly in CLI

7.1.6.211 - January 11th, 2019

Fixes

  • SQLE
    SQLES-264: Issues when synchronizing a COLUMNSTORE INDEX in MSSQL databases under certain conditions
  • SQLE
    #2753: An issue when retrieving a SQL script by a version from a Source Control system

7.1.6.210 - December 26th, 2018

Fixes

  • SQLE
    SQLES-264: Some issues when compare and synchronize with an MSSQL Database

7.1.6.209 - December 24th, 2018

Fixes

  • SQLDE
    SQLES-263: Cannot synchronize data returned by an SQL query when target database is on MyMSSQL

7.1.6.208 - December 21st, 2018

Improvements

  • SQLES
    SQLES-218: In the message about the need to install the MySQL Connector. NET advise the current driver version

Fixes

  • SQLE
    SQLES-258: The synchronization script is not generated correctly if during the synchronization process it is necessary to recreate a table with the HISTORY_TABLE attribute or due to a change in the type of a key column (MSSQL)
    REOPENED

7.1.6.207 - December 17th, 2018

Fixes

  • SQLE
    SQLES-258: NullReferenceException in certain cases when comparing a live MSSQL database and SQL creation scripts which contain a table definition with the ‘HISTORY_TABLE’ attribute

7.1.6.206 - December 14th, 2018

Fixes

  • SQLE
    #3076: In some cases parameters of stored procedures and user-defined functions are duplicated when retrieving text objects metadata from a MySQL database

7.1.6.205 - December 13th, 2018

Fixes

  • SQLE
    SQLES-258: Incorrect results when comparing a live MSSQL database and SQL creation scripts which contain a table definition with the HISTORY_TABLE attribute
  • SQLE
    SQLES-258: The SQL creation script is displayed incorrectly for tables with the HISTORY_TABLE attribute
  • SQLE
    SQLES-258: The synchronization script is not generated correctly when a table with the HISTORY_TABLE or SYSTEM_VERSIONING attributes are synchronized (MSSQL)

7.1.6.204 - December 11th, 2018

Fixes

  • [(sqlite)] SQLITE-257: In some cases, the rows between the MSSQL and Oracle databases are compared incorrectly (the data may have been mistakenly recognized as different from each other).
  • SQLDE
    SQLES-257: In some cases horizontal scroll bar does not scroll data grid

7.1.6.203 - December 07th, 2018

Improvements

  • SQLE
    SQLES-255: Compare and synchronize ‘IDENTITY’ columns from a MSSQL database as SERIAL columns in a PostgreSQL database in cross-platform comparisons
  • SQLE
    SQLES-255: When setting up custom data type mapping, verify that such a mapping is possible (all databases)

Fixes

  • SQLE
    SQLES-255: After synchronization in cross-platform projects, synchronized objects are shown as different

7.1.6.202 - November 30th, 2018

Fixes

  • SQLE
    #2820: InvalidCastException in certain cases when synchronizing UNIQUE constraints in PostgreSQL databases

7.1.6.201 - November 28th, 2018

Fixes

  • SQLE
    SQLES-251: When synchronizing an Oracle database, there are column synchronization errors if the modified table has the compression feature enabled.
  • SQLE
    SQLES-251: In some cases there is an error ‘Edit Project’ because of which some comparison options did not apply after editing them
  • SQLE
    SQLES-249: In some cases for live PostgreSQL databases, the relationships between objects used in views are ignored
  • SQLE
    SQLES-225: Error in feature metadata extraction script for PostgreSQL 11 database
  • SQLE
    SQLES-225: For a live PostgreSQL database, the connection between the column and Sequence was not established
  • SQLE
    #2663: Now InvalidIdentifierWarning will be shown only for cross-platform projects
  • SQLE
    #3027: For PostgreSQL databases, there was an error in the method for determining the number of table entries needed to recreate a table

7.1.6.200 - November 22nd, 2018

Fixes

  • SQLE
    SQL-250: In some cases (when using hexadecimal numeric constants), calculated identical columns could be considered different when comparing MSSQL databases

7.1.6.199 - November 19th, 2018

Fixes

  • SQLE
    #2994: In some cases, when recreating a table, the old data were not transferred

7.1.6.198 - November 16th, 2018

Fixes

  • SQLDE
    SQLES-243: Errors when caching OracleDecimal data. Refactoring the OracleDecimal comparison method

7.1.6.197 - November 15th, 2018

Improvements

  • SQLDE
    SQLES-197: Accelerating data reading from tables containing OracleNumber with great accuracy for Oracle database

Fixes

  • SQLE
    SQLES-245: A table will not be recreated if existing data is truncated when columns are changed (Oracle)
  • SQLE
    SQLES-245: If it was necessary to recreate tables (in Oracle database) some columns were lost because of error in partial synchronization operation
  • SQLDE
    SQLES-243: Error during cross-platform comparison data with Oracle number(15,2) and MSSQL numeric(15,2) types

7.1.6.196 - November 12th, 2018

Fixes

  • SQLE
    SQLES-242: In cases when the user does not have enough rights to extract metadata from the 'mysql.proc' table, the program shows a notification (MySQL)
    REOPENED

7.1.6.195 - November 9th, 2018

Fixes

  • SQLE
    SQLES-242: In some cases, when the user did not have enough permissions to access the 'mysql.proc' table, a MySqlException occurred (MySQL 5.5 and higher)
  • SQLDE
    #2663: InvalidCastException when retrieving column metadata for OLE DB sources
  • SQLES
    SQLES-218: Under certain conditions the Retrieval of the RSA public key is not enabled for insecure connections error occurred when connecting using MySQL Connector Net 8.0.10 and higher

7.1.6.194 - November 8th, 2018

Fixes

  • SQLE
    SQLES-241: Errors when updating and parsing scripts containing temporal table (MSSQL)
  • SQLE
    SQLES-241: Extended Properties scripts comparison and mapping error in MSSQL databases (Program could consider them different, or vice versa the same, although this is not the case)
  • SQLE
    SQL-241: MSSQL has an error when writing table scripts using FILESTREAM and FULL TEXT INDEX (now the constraints are written together with the table)
  • SQLDE
    #2663: InvalidCastException in some cases in cross-platform comparisons (all database types)
  • SQLDE
    #2663: For Oracle servers, no debugging information was collected about Precision and Scale for columns

7.1.6.193 - October 22nd, 2018

Fixes

  • SQLDE
    SQLES-232: When synchronizing data from tables containing ‘columnstore index’ in some cases errors were observed (MSSQL)

7.1.6.192 - October 19th, 2018

Fixes

  • SQLES
    SQLES-235: ArgumentOutOfRangeException when saving tasks in the Task Scheduler wizard if the ‘repeat’ option was used (all database types)

7.1.6.191 - October 17th, 2018

Fixes

  • SQLES
    SQLES-235: RemotingException when loading tasks in the Task Scheduler wizard

7.1.6.190 - October 16th, 2018

Improvements

  • SQLE
    SQLES-228: Added new option Ignore DATA_COMPRESSION to compare tables and indexes (MSSQL)
  • SQLDE
    SQLES-227: Added /BackupOptions:Compress,CopyOnly, which controls parameters of MSSQL backup created before synchronization

Fixes

  • SQLDE
    SQLES-222: When reading data from backup, it returns ‘NULL’ instead of real bit values (MSSQL)
  • SQLES
    SQLES-220: The Active Directory - Password setting was not correctly displayed in HiDPI (SQL Azure)
  • SQLES
    SQLES-221: For the CLI Wizard, the /encrypt parameter required for MySQL sources that require an SSL connection was not added to the generated command line
  • SQLES
    SQLES-221: Under certain conditions the UseTransaction option is not displayed in the CLI Wizard GUI and does not appear in the result (config/cmd file) of the CLI Wizard (MSSQL)
  • SQLE
    SQLES-221: OdbcException on function metadata extraction for versions below 9.2 (PostgreSQL)

7.1.5.189 - September 21st, 2018

Fixes

  • SQLES
    SQLES-217: In some cases, the scripts of the EXTENDED PROPERTY object in the main program window on the Creation Scripts tab were displayed incorrectly (MSSQL)
  • SQLES
    SQLES-217: Extended Properties mapping and synchronization error (MSSQL)
  • SQLES
    SQLES-216: In some cases there was incorrect processing of dependencies (between objects ‘TABLE’ and ‘PARTITION SCHEMA’), which led to table synchronization error (MSSQL)
  • SQLE
    Small bug fixes and improvements

7.1.5.188 - September 14th, 2018

Fixes

  • SQLES
    SQLES-214: In some rare cases, when extracting metadata from an MSSQL backup, an ArgumentOutOfRangeException was thrown
  • SQLES
    SQLES-205: Warn user when connecting to an unsupported version of the PostgreSQL

7.1.5.187 - September 12th, 2018

Fixes

  • SQLDE
    SQLES-210: It was impossible to map an ‘UNIQUEIDENTIFIER’ column and an ‘UUID’ column when compared MSSQL and PostgreSQL databases
  • SQLES
    SQLES-211: In some cases views were not recreated when parent tables were dropped and then recreated during synchronization of MSSQL databases

7.1.5.186 - September 4th, 2018

Fixes

  • SQLE
    #3059: In some cases, the scripts of the TRIGGER object were not updated properly (the ENABLE/DISABLE TRIGGER command was missing in the scripts) (MSSQL)

7.1.5.185 - August 13th, 2018

Fixes

  • SQLES
    SQLES-202: An exception that caused passwords stored in ‘AppData.dat’ to disappear. Refactoring was done to minimize the causes of this problem

7.1.5.184 - August 3rd, 2018

Fixes

  • SQLES
    SQLES-200: OleDbException when loading data from an Excel spreadsheet that uses data filters

7.1.5.183 - July 20th, 2018

Fixes

  • SQLES
    SQLES-196: In some cases, the scheme was mapping incorrectly when loading scheme mapping settings from a project file (all databases types)

7.1.5.182 - July 18th, 2018

Fixes

  • SQLES
    SQLES-193: At the source configuration step, the SQL Azure ComboBox contained duplicate server names

7.1.5.181 - July 4th, 2018

Fixes

  • SQLE
    SQLES-185: Refactoring the system to speed up ‘ForeignKey’ metadata extraction (MSSQL)

7.1.5.180 - July 2nd, 2018

Fixes

  • SQLE
    SQLES-185: Long extraction of metadata on ‘ForeignKey’ (MySQL)
    REOPENED

7.1.5.179 - June 29th, 2018

Fixes

  • SQLE
    SQLES-191: Semantic error when parsing ALTER DATABASE SET COMPATIBILITY_LEVEL script (MSSQL)
  • SQLDE
    SQLES-181: In some cases, incorrect display of data comparison progress if Flat Files is involved
  • SQLDE
    SQLES-181: Incorrect processing of file mask when working with flat files

7.1.5.178 - June 22nd, 2018

Fixes

  • SQLES
    SQLES-189: Reports are always generated with ANSI encoding, without user settings in the program

7.1.5.177 - June 15th, 2018

Fixes

  • SQLES
    SQLES-174: Refactoring methods for processing file name patterns

7.1.5.176 - June 14th, 2018

Fixes

  • SQLE
    SQLES-185: Long extraction of metadata on ‘ForeignKey’ (MySQL)
  • SQLE
    SQLES-180: Incorrect application of the filter in the Object Tree
  • SQLDE
    SQLES-184: Some error in processing the path to “BCP.exe” (MSSQL)
  • SQLES
    SQLES-174: In the Synchronization Wizard, empty folders were created during manual editing of the backup directory (MSSQL)

7.1.5.175 - June 8th, 2018

Fixes

  • SQLES
    SQLES-174: The template for creating a backup path before syncing was not applied correctly, resulting in incorrect recording of the backup file path (MSSQL)

7.1.5.174 - June 6th, 2018

Fixes

  • SQLE
    SQLES-170: When using the Script Database wizard, the Package object was not completely scripted (Oracle)

7.1.5.173 - June 4th, 2018

Fixes

  • SQLE
    SQLES-172: In some rare cases, there was incorrect name validation when synchronizing indexes and constraints

7.1.5.172 - June 1st, 2018

Fixes

  • SQLE
    #2874: In some cases, when parsing the metadata of PACKAGE objects, errors or exceptions occurred (Oracle)

7.1.5.171 - May 30th, 2018

Fixes

  • SQLES
    SQLES-168: In some cases there were problems connecting to the server. Added ability to connect without SSL by default, as well as the ability to enable/disable SSL connection in the GUI

7.1.5.170 - May 23rd, 2018

Fixes

  • SQLE
    SQLES-151: In some rare cases, when parsing the metadata of text objects, a NullReferenceException occurred (PostgreSQL)
  • SQLE
    SQLES-161: In some cases, errors occurred when synchronizing CLR Procedure objects (MSSQL)

7.1.5.169 - May 8th, 2018

Fixes

  • SQLDE
    SQLES-150: When extracting metadata, the program did not extract (did not determine) whether the column has DEFAULT. For this reason, previously, in some cases, during synchronization, warnings about possible problems with table synchronization could be displayed, although this is not true

7.1.5.168 - May 7th, 2018

Fixes

  • SQLE
    SQLES-146: System.NullReferenceException when parsing text objects from snapshots (MSSQL)

7.1.5.167 - May 3rd, 2018

Improvements

  • SQLES
    SQLES-143: When the console start as scheduled tasks, the console window is immediately minimized (minimized)

Fixes

  • SQLES
    SQLES-143: In some cases, the connection string to SQL Azure was formed incorrectly, which could lead to connection errors

7.1.5.166 - April 30th, 2018

Fixes

  • SQLDE
    SQLES-133: If there is a backup in the comparison, it is possible to select columns that are not included in this backup as a comparison key (MSSQL)

7.1.5.165 - April 27th, 2018

Fixes

  • SQLE
    SQLES-130: In some cases of COLUMNSTORE INDEX synchronization the NullReferenceExceptionerror occurs
  • SQLDE
    #3031: When connecting to Specify Schemas, the total number of records in the tables may be incorrectly determined in some cases (Oracle)
  • SQLES
    #3023: When trying to connect to SQL Azure via Active Directory - Password authentication mode, some error occurs
  • SQLES
    #2663: Text error in the update installation window

7.1.5.164 - April 13th, 2018

Fixes

  • SQLE
    #3028: In some cases, a synchronization error occurred when using the Ignore Constraints option
    REOPENED

7.1.5.163 - April 12th, 2018

Fixes

  • SQLE
    #3028: In some cases, a synchronization error occurred when using the Ignore Constraints option

7.1.5.162 - April 10th, 2018

Fixes

  • SQLE
    #2814: In some cases, the script for extracting information about table columns contains an error (Oracle)
  • SQLDE
    #2905: If the SQL Compact database file was used in parallel in any other program, the NullReferencesExceptionexception occurs when trying to connect to the MSSQL Compact database

7.1.5.161 - April 5th, 2018

Fixes

  • SQLES
    #3026: In some cases, user can't connect via .NET Connector (MySQL)

7.1.5.160 - April 4th, 2018

Fixes

  • SQLES
    #2859: Cannot connect under SYS user (Oracle)
  • SQLES
    #3026: In some cases, when connecting to the MySQL database, a connection error occurred

7.1.5.159 - April 3rd, 2018

Fixes

  • SQLDE
    SQLES-14: Views are displayed in the Tables category (PostgreSQL)
  • SQLES
    SQLES-98: Timeout period elapsed prior and max pool size was reached to obtaining a connection from the pool (MySQL)

7.1.5.158 - March 29th, 2018

Improvement

  • SQLES
    #3023: Added a new method authentication (Azure AD Authentication) when connecting to the MSSQL database

Fixes

  • SQLDE
    #3022: The default comparison key is not defined correctly (MSSQL Compact)
  • SQLDE
    #3024: If a DataSource of the Flat File type was supplemented with new data files, re-comparing the data did not work correctly

7.1.4.157 - March 23rd, 2018

Improvement

  • SQLE
    #2820: Added extraction / comparison / synchronization methods for the Constraint, WHEN, Deferrable, FROM, FOR EACH properties of the DB object (PostgreSQLTrigger)
  • SQLE
    #2820: Added support Domain (PostgreSQL)

Fixes

  • SQLDE
    #3020: In some cases, when the user activated the Use bulk load synchronization option, the configuration file or a set of command-line parameters could be formed incorrectly (it contained incorrect paths to the utility bcp.exe)
  • SQLDE
    #3021: When switching to another table in Object List, the contents of the Find window are not updated

7.1.4.156 - March 21st, 2018

Fixes

  • SQLE
    #2820: The WINDOW, LEAKPROOF, STRICT, ROWS attributes are not extracted, compared, or synchronized for the FUNCTION object (PostgreSQL)
  • SQLDE
    #3017: When opening the project, the value of the Encrypt connection option is not loaded (PostgreSQL)

7.1.4.155 - March 19th, 2018

Fixes

  • SQLE
    #3017: Previously, the state (value) of the Encrypt connection connection setting was not saved in the project. This could lead to connection problems when opening the project again

7.1.4.154 - March 15th, 2018

Fixes

  • SQLDE
    #3016: In some cases, when comparing MSSQL vs Access data, when string data types were used as the comparison key, the data comparison was incorrect.

7.1.4.153 - March 13th, 2018

Improvement

  • SQLE
    #3015: Added option Use names in constraint definitions in CLI Wizard

Fixes

  • SQLE
    #3015: An issue with Ignore WITH NOCHECK property in Console mode

7.1.4.152 - March 7th, 2018

Fixes

  • SQLE
    #3014: An issue with MSSQL rules synchronization under certain conditions
  • SQLES
    #3013: In some cases, the About window does not display the username

7.1.4.151 - March 6th, 2018

Fixes

  • SQLE
    #3012: In the case of Standard Edition the ProvidersLoader is used
  • SQLDE
    #3007: In some cases, when creating a task in the Task Scheduler wizard, the settings of filters for extracted data for tables are lost
    REOPENED
  • SQLES
    #3011: Some index and column synchronization error (MSSQL Compact)

7.1.4.150 - March 5th, 2018

Improvement

  • SQLES
    #3009: Added % status to the names of created reports

Fixes

  • SQLE
    #2791: Incorrect display of some GUI controls in HiDPI mode
  • SQLES
    #3010: Some error in index synchronization (MSSQL)

7.1.3.149 - March 2nd, 2018

Improvement

  • SQLES
    #3007: Added ability to copy filters when editing a project

Fixes

  • SQLE
    #3010: In some cases a synchronization error occurs due to incorrect processing relations between INDEX and FOREIGN KEY objects (MSSQL)
  • SQLE
    #2997: If the columns in the tables differ in property VISIBLE/INVISIBLE, then the synchronization ignores these differences (Oracle)

7.1.3.148 - March 1st, 2018

Fixes

  • SQLDE
    #3008: In some cases, when comparing the data, the error There is insufficient system memory in resource pool default occurs, which caused the program to crash
  • SQLDE
    #3007: In some cases, when creating a task in the Task Scheduler wizard, the settings of the extracted data filters for tables are lost

7.1.3.147 - March 1st, 2018

Fixes

  • SQLE
    In some cases, an error "There is already an object named 'IssueName' in the database" occurs during synchronization. (MSSQL)
  • SQLES
    #3006: UnauthorizedAccessException, when running console applications “SQLECmd.exe” and “SQLDECmd.exe”

7.1.3.146 - February 27th, 2018

Fixes

  • SQLDE
    #3004: Stylistic error when creating text with CLI Wizard
  • SQLDE
    #3003: Empty strings are treated as NULL (MySQL)

7.1.3.145 - February 22nd, 2018

Fixes

  • SQLDE
    #2956: OutOfMemoryException, in some cases, when comparing data
  • SQLDE
    #3001: Now all system objects are not retrieved, compared, or synchronized (Oracle)

7.1.3.144 - February 16th, 2018

Improvement

  • SQLE
    #2997: Code was optimized for better performance while comparing live database

Fixes

  • SQLDE
    #2998: The synchronization script is not generated correctly if the table contains calculated columns (Oracle)

7.1.3.143 - February 14th, 2018

Fixes

  • SQLE
    #2996: An issue with synchronize MySQL stored procedures and functions with user variables (MySQL)
  • SQLDE
    #2995: Error reading empty columns from MS Excel when comparing it with other databases
  • SQLDE
    #2971: In some cases the DateTime values were formed incorrectly in the synchronization script (MSSQL)

7.1.3.142 - February 12th, 2018

Fixes

  • SQLDE
    #2993: Inability to use SQL Loader (Oracle)
  • SQLDE
    #2988: An issue with reading hierarchyID columns from SQL Backups (MSSQL)

7.1.3.141 - January 30th, 2018

Fixes

  • SQLDE
    #2984: Error when parsing backups data of geometry type and geography type (MSSQL)
  • SQLE
    #2986: Minor stylistic text errors in the UI

7.1.3.140 - January 29th, 2018

Fixes

  • SQLE
    #2984: In some cases an error occurs when parsing metadata Encrypted Text Objects (MSSQL)
  • SQLDE
    #2986: Code was optimized for better performance while comparing live databases

7.1.3.139 - January 24th, 2018

Improvement

  • SQLE
    #2986: Added ability to decrypt encrypted text objects from MSSQL database (only for Professional Edition) (MSSQL)

Fixes

  • SQLE
    #2987: Incorrect number of statements in Oracle batch command
  • SQLE
    #2826: There are no column names in the ‘INCLUDE’ index property while comparing SQL backups (MSSQL)
  • SQLDE
    #2985: Incorrect string key columns comparing under certain conditions (MSSQL)

7.1.2.138 - January 12th, 2018

Improvement

  • SQLDE
    #2956: Added /EnableMemUsageMonitoring parameter to collect statistics on memory usage by the program
  • SQLDE
    #2956: The code was optimized to work better with memory when reading and comparing data

7.1.2.137 - December 28th, 2017

Improvement

  • SQLE
    #2956: Added ability to see the number of completed synchronization tasks in console mode
  • SQLDE
    #2956: Code was optimized for better performance while comparing SQL Backups (MSSQL)

Fixes

  • SQLE
    #2982: In some cases, when you open a project, some of the project settings are not loaded
  • SQLE
    System.ArgumentOutOfRangeException when select text in creation script under certain conditions
  • SQLE
    #2663: Minor UI bug
  • SQLES
    #2980: Issue with show information messages without line breaks in log

7.1.1.136 - December 22th, 2017

Fixes

  • SQLE
    #2978: The Ignore schemas option does not work properly when comparing PostgreSQL databases

7.1.1.135 - December 21st, 2017

Improvement

  • SQLE
    Added support for EnterpriseDB PostgreSQL
  • SQLDE
    Improved the logic responsible for deleting temporary files after closing the program which improved the overall performance of the program

Fixes

  • SQLE
    #2976: EnterpriseDB server version is incorrectly determined (PostgreSQL)
  • SQLES
    ‘Item was already added’ error when comparing databases under certain conditions (PostgreSQL)

7.1.0.134 - December 14th, 2017

Fixes

  • SQLE
    #2974: Issue when connecting to Team Foundation Server on visualstudio.com
  • SQLE
    #2952: Minor bug fixes and improvements

7.1.0.133 - December 12th, 2017

Improvement

  • SQLDE
    Added Script created by comments to the database synchronization scripts (PostgreSQL)

Fixes

  • SQLE
    #2968: PostgreSQL does not use its own set of options, but from a cross-platform comparison (PostgreSQL)
  • SQLDE
    #2973: Error in synchronization a MSSQL bit column to a PostgreSQL boolean column (PostgreSQL)
  • SQLES
    #2972: System.ObjectDisposedException during Get Database List process under certain conditions

7.1.0.132 - December 4th, 2017

Fixes

  • SQLE
    Incorrect name of Ignore FK Action ON DELETE / ON UPDATE option in CLI Wizard

7.1.0.131 - December 1st, 2017

Improvement

  • SQLES
    #2950: For some users, not all local database instances were displayed in the MSSQL settings window)

Fixes

  • SQLE
    In the New Project wizard, the options on the Options tab were displayed incorrectly (if a DBMS other than the current one was previously opened)
  • SQLE
    #2961: Issue with error in parsing scripts contained spatial index (MSSQL)
  • SQLDE
    #2958: Incorrect work of PageDown/PageUp/Home/End buttons in data grid
  • SQLDE
    #2956: Some unhandled exceptions that cause the program to crash
  • SQLES
    #2967: In some cases, wrong parameter in Oracle connection under certain conditions (Oracle)
  • SQLES
    In some cases, the connection string was formed with an error
  • SQLES
    In some cases, program settings stored in the registry are written incorrectly
  • SQLES
    If the panels are outside the boundary of the screen, their normal location is not restored

7.1.0.130 - November 29th, 2017

Fixes

  • SQLE
    Issue caused by getting wrong branch names in Git
  • SQLDE
    In some cases, SQL tab shows query input field for source that is empty or not live database
  • SQLDE
    Error in Edit Table window on Filter tab when one of the sources is not a live database (FlatFile or Backup)
  • SQLES
    System.OutOfMemoryException program crashes in comparison process reproduced on some computers

7.1.0.129 - November 27th, 2017

Improvement

  • SQLE
    Added Ignore Foreign Keys Actions ON DELETE / ON UPDATE project option
  • SQLDE
    Improve automatic column mapping - ignore spaces and underscores

7.1.0.128 - November 24th, 2017

Improvements

  • SQLES
    Added Priority Support and Upgrade Protection expiration date among license info in the About window.
  • SQLDE
    Smoother scrolling in the data grid in the Main screen

Fixes

  • SQLE
    Parameters of stored procedures are parsed incorrectly (MSSQL)
  • SQLE
    InvalidOperationException when user changed orientation of the panels in GUI
  • SQLE
    NullReferenceException when calling the MiddleAbstractObject.Diff
  • SQLDE
    An error occurred when the user interrupted the comparison
  • SQLDE
    Issue with comparing Oracle FLOAT Columns contained large numbers
  • SQLDE
    ArgumentOutOfRangeException when user copied data from the data grid under certain conditions
  • SQLDE
    Exception when user swithced to the Preview Pane for a skipped table
  • SQLDE
    ArgumentOutOfRangeException when program determined comparison progress under certain conditions
  • SQLDE
    NullReferecence exception in Export to CSV form
  • SQLES
    Incorrect name of the log file
  • SQLES
    Programs did not properly detected installed version of the MySQL .NET Connector
  • SQLES
    Some minor UI bugs

7.1.0.127 - November 17th, 2017

Fixes

  • SQLDE
    In some cases, the connection string to Oracle sources was formed incorrectly, which could lead to connection errors
  • SQLDE
    In the Export to CSV wizard, the name template for the exported files worked with errors in some cases

7.1.0.126 - November 15th, 2017

Fixes

  • SQLES
    Minor UI bug. In certain cases, a font selected by the user to display the SQL code in the code redactor was reset to the default font)

7.1.0.125 - November 15th, 2017

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

  • Product:  SQL Examiner, SQL Data Examiner
  • Edition:  All
  • Version:  2018
  • Published:  2017-11-14
  • Last Updated:  2022-05-02

Do not see what you are looking for?
Please submit a support request

Table of contents