Release Notes - SQLines Data

Changes in SQLines Data tool.

Version 3.3.731

In progress. Please contact us at support@sqlines.com for updates, improvements and new features.

Transferring data from INTERVAL HOUR TO FRACTION(n) type to INTERVAL HOUR TO SECOND(n) (Informix to PostgreSQL)
Migrating primary key and unique constraints (from MySQL)
Bug fix - VARCHAR and NUMERIC data transfer (invalid datatype in OCI call error) issue (PostgreSQL to Oracle)
Bug fix - Validating tables with primary key or unique constraints (MySQL to PostgreSQL)
Bug fix - Reading TEXT values more than 4,000 bytes (from PostgreSQL)

Released on September 12, 2023.

-column_name_quotes and -object_name_quotes to specify quote characters for identifiers (columns, schemas, tables etc.) in generated SQL scripts
Remove disabled Terminate button from UI as this functionality is currently not supported
Migrating column comments from Sybase SQL Anywhere
Extended trace information when reading BLOB values from Informix
Bug fix - Extracting AUTOINCREMENT columns from Sybase SQL Anywhere if max_identity is 0 in syscolumn catalog view
Bug fix - Transferring DATETIME data on a Linux client (from SQL Server)

Released on June 27, 2023.

Bug fix - Enclosing column names containing special characters (, -, (, ) and so on) with double quotes (to Oracle)
Bug fix - Enclosing column names starting with a digit with double quotes (to Oracle)
Bug fix - Fixing error “another command is already in progress” when reading data from PostgreSQL after fetching table with 0 rows or when a fetch error happens (releasing query result resources)
Bug fix - Logging PostgreSQL libpq library use and load errors
Bug fix - Transferring Oracle DATE (was mapped to DOUBLE)
Bug fix - Oracle NLS_LANG environment variable setting
Bug fix - IBM DB2 DB2CODEPAGE environment variable setting

Released on May 28, 2023.

Migrating DATETIMEOFFSET data type (from SQL Server)
Using DATETIME YEAR TO FRACTION and INT8 columns for sorting data for validation if there are no primary key or unique columns (from Informix)
Allow specifying the target size for global data type mapping in sqlines_dtmap.txt
Migrating TEXT data type to VARCHAR(MAX) (MySQL to SQL Server)
Supporting ODBC Driver for SQL Server on Windows as SQL Server Native Client is deprecated
Adding -sql_lib and -sql_driver options to specify SQL Server client libraries and driver for Windows and Linux
Reducing memory consumption when validating data for PostgreSQL
Bug fix - Informix driver for Linux also returns fractional part of DATETIME YEAR TO FRACTION(n) as zero when binding as SQL_TIMESTAMP_STRUCT (from Informix)
Bug fix - DATETIMEOFFSET data type mapping in sqlines_dtmap.txt file (from SQL Server)
Bug fix - Truncating table.dump.txt on restart on Linux
Bug fix - Show error message if COPY FROM STDIN initialization failed (to PostgreSQL)
Bug fix - Data type missed in CREATE TABLE for a column with NUMBER data type defined as a computed column (GENERATED AS expression) (from Oracle)

Released on March 12, 2023.

Bug fix - Migrating fractional part of DATETIME YEAR TO FRACTION(n) (Informix to PostgreSQL)
Bug fix - Creating dump data file (table.dump.txt) and validation difference file (table_diff.txt) in the directory defined by -out option (they were always created in the current directory)
Bug fix - Fixing crash when extracting data from Oracle rule types (DBMS_RULE i.e. SYS.RE$NV_NODE)
Bug fix - Dumping DATETIME value to table_diff.txt file (from Informix)
Bug fix - DATETIME and TIMESTAMP data types validation (Informix to PostgreSQL)
Using one-based index for rows when dumping row differences to table_diff.txt file during data validation

Released on February 07, 2023.

Extracting Oracle SDO_GEOMETRY spatial data in WKT Spatial format (Well-Known Text)
Added -dlog option to specify name and location for executed DDL statements (default is sqldata_ddl.sql)
Bug fix - Skip creating constraints, sequences, defaults and indexes in Truncate mode (-cmd=truncate)
SQLData UI - Initializing connection windows with last active connection settings (server name, user name, database etc.)
Extending sqldata.trc metrics for rows validation mode
Bug fix - Fixing SQLData UI crash when performing data validation on tables with large number of columns (validation SELECT query more than 2048 bytes)
Bug fix - Transferring VARCHAR data (MariaDB/MySQL to MariaDB/MySQL)