Release Notes - SQLines Data

Version 3.3.731

In progress. Please contact us at 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)

Version 3.3.730

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)

Version 3.3.717

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

Version 3.3.713

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)

Version 3.3.711

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

Version 3.3.710

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)