Enclosing columns with [] during data validation process (to
SQL Server)
Refactoring data validation (Sybase
SQL Anywhere)
Fixing applying
-batch_max_rows option (Sybase
SQL Anywhere)
Converting DECIMAL(65,s) to DECIMAL(38,s) due to data type range limitations (MySQL to
SQL Server)
Transferring indexes (from MySQL)
Transferring foreign keys (from MySQL)
Reading IBM DB2 iSeries catalog view QSYS2.TABLES to get the table list using ODBC driver
Adding ODBC data source to SQLines Data UI
Transferring BIT(
n) data type data (MySQL to
SQL Server)
Implementing case-insensitive table name mapping (-tmapf option)
Using hex encoding internally when transferring binary data using COPY command (IBM DB2, Informix, Sybase ASA to PostgreSQL)
Fixing transferring LONG BINARY data larger 3
MB (from Sybase
SQL Anywhere)
Transferring column DEFAULT values and AUTO_INCREMENT properties including next value (from MySQL)
Fixing global data type mapping sqlines_dtmap.txt for DATETIME and INT data types (from MySQL)
Added -identity_start option to specify the start value for identity columns (by default, it is taken as the next value for the corresponding source table)
Applying column mapping and escaping for ALTER TABLE … DEFAULT statements (to Oracle,
SQL Server, PostgreSQL)
Validating BIT values 0 and 1 with BOOLEAN values 'f' and 't' (Sybase ASA to PostgreSQL)
Ordering rows using numeric, datetime and string columns for tables without unique keys or indexes (from Sybase ASA)
Fixing data validation for BIGINT data type (PostgreSQL)
Added the option -datetime_year_lte_to_null to convert DATETIME values to NULL if their year is less or equal to the specified value (from MySQL)
Transferring data of IMAGE data type (Sybase ASE to Oracle)
Fixing data validation for NUMERIC and DECIMAL datatypes comparing string representation like .50 and 0.5 (from Sybase ASA)
If table transfer failed set SET IDENTITY_INSERT
table1 OFF explicitly to prevent errors: “IDENTITY_INSERT is already ON for table '
table1'. Cannot perform SET operation for table '
table2'” for tables with identity columns (to
SQL Server)
Moving VARCHAR(max), NVARCHAR(max), IMAGE and TEXT columns to the end of SELECT list to prevent “Invalid Descriptor Index” errors (from
SQL Server)