Tutte le versioni Full Convert

The changelog provides a detailed record of all updates, bug fixes, and enhancements made to the software. By regularly updating Full Convert, take advantage of the latest advancements, ensuring seamless data conversion and synchronization across various platforms and databases.

  • v23.07.1671
    July 27, 2023
    • - Conversion - a table with a problem in selecting data from the source will correctly be shown as an error
    • - Expect existing - added a fallback search values for tables and columns
    • - Access - added support for date/time extended data type
    • - Access - fixed a problem with
    • - SQL Server - added additional local and network server list locations
    • - OpenEdge - sped up reading of metadata
    • - OpenEdge - added a fallback index query if the newer one fails
    • - Oracle - upgraded the table size query so it includes LOB data
    • - Oracle - fixed some problems when
    • - Oracle RDB - fixed the connection string validation error
    • - PostgreSQL - handle decimal overflows better
    • - PostgreSQL - added support for table comments when source
    • - PostgreSQL - added support for TIME and TIMESTAMP precision
    • - SQL Server - fixed a problem when setting TIME to NULL in some cases
    • - SIARD - upgraded to SIARD 2.2 (from SIARD 2.1)
    • - SIARD - added support for foreign key actions when source
    • - SIARD - expanded the LOB file location functionality
  • v23.03.1670
    March 27, 2023
    • Excel - fixed a problem when the database is set as source
  • v23.03.1669
    March 27, 2023
    • - Conversion - fixed a problem with target schema creation
    • - Comparison - fixed a hang during comparison in some cases
    • - MySql - removed scale from the float and double data types when creating tables
    • - MySql - fixed a problem with defaults being quoted two times
    • - Redshift - fixed the argument out of range problem
  • v23.02.1668
    February 27, 2023
    • - Project options - added an option to disable the special (slower and safer) processing of self-referencing tables
    • - Database browser - improved stability, fixed displaying time zone information
    • - Error and Warning view - fixed some vertical scrollbar problems
    • - Default values - changed so manually mapped default values are set as is and not always escaped, which lead to problems
    • - Default values - fixed made mapping source case independent, and fixed some minor errors
    • - Access - fixed mapping of varbinary columns with 0 precision
    • - CockroachDb - fixed metadata read
    • - CockroachDb - fixed identity reset error and index primary key parallel execution problem
    • - DB2 LUW - optimized and speed up the measuring tables step
    • - dBase/Foxit - added an unique index when autoincrement columns recognized
    • - MySQL - fixed a problem with column default values breaking the CREATE TABLE script
    • - Oracle - fixed reading time zone information from timestamp with time zone columns
    • - Oracle - fixed importing DateTime data when LOB columns are present in the table
    • - SIARD - fixed data type mapping for FLOAT columns to be xs:double in the table *.xsd files
    • - SIARD - fixed writing timestamp values when source contains time zone information
    • - Sybase ASE - added charset support
    • - SQL Server - added support for reading of SET NULL foreign key action
    • - SQL Server - fixed a problem where IDENTITY columns could break the run
    • - SQL Server - fixed create table script where DEFAULT values would not have escaped single quote
  • v22.11.1667
    November 2, 2022
    • - Conversion - fixed a table duplication problem with some databases because of casings
    • - Conversion - do not force NOT NULL on target primary key, instead change the PK to a unique index
    • - Replication - fixed a problem with some databases when the identity column was not selected
    • - Options - fixed table name prefix
    • - Options - removed the Ultimate version options
    • - Options - moved the “Fetch metadata for selected tables” from Ultimate to Professional version
    • - Options - fixed missing columns on some databases when table creation mode is ‘Expect existing’
    • - Browse target - fixed duplication of objects
    • - Advantage - fixed some problems in metadata processing and made more robust
    • - DB2 LUW - fixed a deadlock when creating multiple indexes on the same table
    • - DB2 LUW - fixed an error in the CREATE table script with IDENTITY columns
    • - SQLite - added source support for fetching indexes
  • v22.08.1666
    August 29, 2022
    • - Conversion - default schema will now be created if missing
    • - Comparison - removed the skip equal records option and set it as a standard behavior
    • - Mapping - data type mapping now supports ranges and any size in source size declaration (e.g. ‘decimal(16..18,4..6)=bigint; varchar(*)=nvarchar(max)’)
    • - Postgres - added support for SSL certificate and key files (pem files)
    • - Postgres - improved comparison detection in Postgres versions 12+
    • - Postgres - added reserved column names
    • - Progress - added support for all index types
    • - SQLite - fixed handling of data types marked as unsigned
  • v22.07.1665
    July 27, 2022
    • - Conversion - fix column comments slipping into collation
    • - CSV, JSON - exposed data handling option in the target connection screen
    • - PostgreSQL - fixed a comparison problem with case sensitivity
    • - PostgreSQL - changed so invalid or null dates are converted to the smallest date and not to the infinity date in some cases
    • - Progress - upgraded the index detection
    • - SqlAzure - added authentication modes
  • v22.07.1664
    July 11, 2022
    • - Replication - added progress and stats while synchronizing data
    • - Update - download file size is not displayed if unknown
    • - Logs - fixed a problem where only the first missing table in the expect existing mode was reported
    • - Project options - revalidating tables after changing table creation mode
    • - Database browser - fixed a problem where viewing a target table data selected all tables for processing
    • - Firebird - fixed an error with conversion of datetime type in some cases
    • - Gupta SQLBase - fixed issue with character encoding - reading of German umlaut characters
    • - MySQL - removed trailing spaces from identifiers on sanitization
    • - NexusDB - updated the provider
    • - Oracle - fixed the ORA-01795 problem when there are more than a 1000 tables in the database
    • - Paradox - automatically set primary key columns as not null to avoid warnings
    • - PostgreSQL - enabled the Include Error Detail option in the connection string
    • - PostgreSQL - fixed a comparison problem with ordering on textual key columns in some collations
    • - SAP ASA (Sybase SQL Anywhere) - fixed connections to old ASA version 9
    • - SQLite - fixed numerous DDL parsing errors
    • - InterBase - fixed reading of column meta-data
  • v22.05.1663
    May 31, 2022
    • - Replication - fixed adding records to tables with auto-incrementing columns
    • - Database browser - fixed missing data in some cases
    • - Advantage - added an option to use local server as the server type in the connection string
    • - Advantage - detect primary key columns
    • - JSON - added as source and target database in PRO application versions and higher
    • - SQL Server Compact (SQL CE) - fixed missing driver files
    • - SQL Server Compact (SQL CE) - fixed handling of “rowversion” (timestamp) data type
    • - SQL Server Compact (SQL CE) - enable creating referential actions (foreign keys)
    • - Firebird - fix detection of auto-incrementing columns from triggers and from “generated by default as identity” syntax
    • - Firebird - speed up reading of metadata
    • - Firebird - ignore unsupported RESTRICT referential action (foreign key) when reading metadata
    • - Firebird - fixed length detection of character columns
  • v22.02.1662
    February 17, 2022
    • - Console - fix overriding source or target connections using -OSC or -OTC parameters when project file parameter is also supplied
    • - Comparison - fixed a problem with the comparison not finding some differences when ‘Detect deleted data’ was disabled
    • - Conversion - better workflow handling when the table failed to drop (skip subsequent stages for that table)
    • - Browse target - fix column duplication
    • - Advantage - fixed connecting to the local server
    • - Firebird, InterBase - fixed primary key detection
    • - Firebird, InterBase - fixed reading indexes that are associated with foreign key columns
    • - MySQL - don’t use bulk insert if the table has LOB types, as it is not stable enough
    • - Pervasive - updated drivers
    • - PostgreSQL - fixed handling of CITEXT data type for data bulk loading
    • - PostgreSQL - handled reading of ‘NaN’ decimal values (will always be read as NULL)
    • - SQL Server - fixed SET IDENTITY_INSERT OFF not being called in the case of an error while loading data
    • - SQLite - fixed reading of big numbers
  • v21.12.1661
    December 20, 2021
    • - Removed the need for metadata read on every run
    • - Console - respect project options supplied by command-line parameter
    • - Console - use TLS when sending emails
    • - Overview - added a "Show invalid tables" filter
    • - Project options - added a ‘Fetch only selected tables’ option (for databases that only have a few of selected tables)
    • - Project options - Email support - added a "Send test email" button
    • - Conversion - fixed some name deduplication problems
    • - Conversion - delta now skips tables that don't have number types as key columns
    • - Conversion - fixed a bug when converting between databases with different quotation character
    • - Conversion - enable remapping of Unicode text types
    • - Access - fixed connections using Workgroup Information File (System database) *.mdw
    • - Excel - optimized workflow for big performance gain, especially for large files and files with multiple sheets per file
    • - Firebird, InterBase - fixed a problem with fetching index metadata
    • - Firebird, InterBase - fixed reading of unique indexes metadata
    • - PostgreSQL, Cockroach, RedShift - fixed an error with geo types reporting as not supported
    • - PostgreSQL, Cockroach, RedShift - when source, fixed the reading of column default values
    • - SIARD - conform deleteAction and updateAction elements of the foreignKey element definition to the XSL schema when RESTRICT action is used
    • - SIARD - added support for SQL Server's SQL_VARIANT data type
    • - SQL Server - added support for primary XML indexes (introduced in version 12 (2014))
    • - SQL Server - added support for precision in DATETIME2 data type
    • - SQL Server - really fixed problems with meta queries when "Include views" is enabled
    • - Sybase (SAP) ASE - fixed reading data from TEXT columns - prevents truncating when data is longer than 32 kB
    • - Oracle - added warnings when big numbers cannot be represented in .NET decimal range
  • v21.11.1660
    November 19, 2021
    • - Conversion - in some databases, when the bulk loader fails, it reported all records processed, changed it to report no records processed
    • - Replication - fixed a problem with some columns always selected in specific cases
    • - Oracle - bulk loader now reports exact record count
    • - SQL Server - fixed problems with meta queries when "Include views" is enabled
  • v21.11.1659
    November 17, 2021
    • Activation - fixed an error preventing manual activation
    • Replication - fixed a problem with column selection not being saved
    • Firebird - added support for server version 4 (ODS 13)
    • Firebird - fixed embedded server not working as expected
    • MySQL - added support for foreign key actions
  • v21.10.1658
    October 25, 2021
    • - Conversion - fix index and foreign key options not respected in some database
    • - DB2 iSeries - support primary and unique constraints
    • - SQLite - added datetime data type support
    • - Sybase Advantage - fixed reading of unsupported column types breaking the metadata read
  • v21.08.1657
    August 31, 2021
    • - Fixed a starting screen problem when onboarding option was turned on
  • v21.08.1656
    August 30, 2021
    • - Trial - Fixed a problem with FKs not being created in some cases
    • - Trial - Fixed a problem columns being watermarked multiple times
    • - Console - Fixed problems when the engine type was overridden
    • - Log - SQL error log will now log all statements that fail, error log will just have the error message
    • - Azure SQL - Fixed a driver problem that prevented connections
  • v21.08.1655
    August 19, 2021
    • - DB2 iSeries - Implemented fast metadata fetch
    • - SQL Server - reverted to old driver to prolong support for CLR types
  • v21.08.1654
    August 12, 2021
    • - Massively increased performance when inserting records one at a time. Some databases have no fast insert capability and this will make data load to those targets up to 20x faster.
    • - Azure SQL - added authentication selection with full support for Azure Active Directory
    • - Sybase Advantage - removed file locking when connecting to a local database in Client mode
    • - MySQL - improved compatibility with the new driver, avoiding transaction error sometimes occurring with bulkcopy
  • v21.08.1653
    August 4, 2021
    • - MySQL - automatically using bulk copy mode when local_infile server variable is set to ON, for significant speedup and reduced memory use
    • - Custom SQL scripts can now be run on each connection instead of once to allow for connection session initialization
    • - Access, Interbase, Firebird - fixed connectivity problems
    • - Added a 'Tweet this' button for the trial users
  • v21.07.1652
    July 31, 2021
    • - Interbase - upgraded driver and fixed connection issues
    • - CockroachDB - handled various incompatibilities of CockroachDB with regards to our underlying Postgres layer
    • - SQL Anywhere - fixed connection to a database running on a local machine
    • - Pervasive PSQL - fixed character set handling and set UTF-8 as default one
  • v21.07.1651
    July 28, 2021
    • - Wizard - added a new onboarding screen after wizard review page
    • - Metadata fetch - added progress indication for databases where we can't fetch all metadata at once
    • - Databases - removed support for Derby, H2 and HyperSQL due to obsolescence of IKVM.NET library (http://ikvm.NET)
    • - Access - added a prompt for in-place driver download and install
    • - CSV - fixed the missing columns problem when CSV is source
    • - Excel - fixed processing of files with multiple sheets
    • - Gupta SQLBase - fixed missing password error
  • v21.07.1650
    July 22, 2021
    • - Trial - fixed a problem making the trial conversions slower (up to 50x slower) than the full version
    • - Trial - fixed a Foreign Key error that sometimes happened with watermarked columns
    • - Console - fixed email notification not sending the summary log
    • - Replication - fixed column mappings on specific databases
    • - Summary log - added calling arguments to the log
    • - FileMaker - fixed missing columns
  • v21.07.1649
    July 15, 2021
    • Console - fixed schema mapping overrides (-OSM command-line parameter)
    • Conversion
    • - fixed missing values in enum and set column types in the create table script
    • - fixed wrong records processed value in the review in some cases
    • - fixed wrong "No primary or unique key…" validation when tables are expected to exist
    • Replication
    • - fixed comparison with composite keys in different order than in the table
    • - fixed change detected when one column is date and the other is datetime
    • - key columns are now automatically selected when editing table keys
    • Project
    • - fixed opening of old project files
    • - removed the diff log (data is now contained in the json log)
    • Access - removed connection pooling
    • Firebird
    • - when source, added additional index detection (standard, unique)
    • - when target, fixed foreign key detection
    • FileMaker - returned as a source supported database
    • Gupta SQLBase - use SYSSQL and SYSADM system views and tables when fetching metadata to avoid security issues
    • MySQL - fixed data type detection for some cases
    • PostgreSQL - exposed partitioned tables and removed table partitions reported as tables
  • v21.07.1648
    July 6, 2021
    • - Trial - added watermark for schema columns
    • - Ingres - upgraded database driver
    • - SQLite - fixed primary key constraint parsing error
    • - SQLite - fixed database locked error (we no longer load tables in parallel)
  • v21.07.1647
    July 2, 2021
    • - Console - fixed occasional license deactivation
    • - Scheduled tasks - fixed obsolete tasks problem
    • - Conversion - fixed incrementing/identity columns not converted as such
    • - Gupta - upgraded database driver
    • - SQLite - fixed parsing error on tables with multiple reference actions defined
    • - SQLite - added source reference constraints support
    • - Sybase ASA - ignoring 'dbo' system tables
  • v21.06.1646
    July 1, 2021
    • - Wizard - fixed wizard loss of responsiveness with certain databases
    • - Foreign keys - fixed missing FKs on some databases
    • - Data truncation - fixed table deletion/truncation order
    • - Db2Luw - set the default schema to connection username
    • - MySql - fixed a crash when converting a table with a column comment
    • - Sybase ASA/ASE/IQ - fixed metadata fetch typo
  • v21.06.1645
    June 28, 2021
    • - Massive update of internal database engine
    • - Conversion throughput is doubled!
    • - Rewritten database metadata fetching allows instant table mapping and editing
    • - SIARD - table row level of BLOB message digest (MD5, SHA-1 or SHA-256) should always be represented as hexadecimal string and not base64 string. This fix affects only reading of the SIARD files. Reading and verifying table level SHA-1 and SHA-256 digests stored as hexadecimal string will now work correctly.
  • v21.04.1644
    April 19, 2021
    • Fixed a MySQL query when when tables need to be escaped
  • v21.04.1643
    April 15, 2021
    • - Handle additional types when source column value is null, but the target column is not null
    • - Custom scripts - fixed a problem with the before script
    • - Expect existing - ignore casing if no matching column is found in some databases
    • - MySQL - optimize metadata read scripts
    • - Oracle
    • - fixed VARCHAR(N CHAR)
    • - fixed a null insert problem when a value was an empty string in specific cases
    • - increased the identifier limit to 128 on versions 12.2 and up
    • - Ask for the trial user's name to improve communication
  • v21.04.1642
    April 8, 2021
    • - Oracle - fixed an error while converting to an empty database in some server versions
    • - Conversion - fixed index and foreign key creation
    • - Replication Logs
    • - added Diff log
    • - fixed some Replication Summary log data (added, table count)
  • v21.03.1641
    March 30, 2021
    • fix table schema mappig
  • v21.03.1640
    March 30, 2021
    • - Fixed some custom mapping problems
  • v21.03.1639
    March 29, 2021
    • - Replication - handled Timestamp with timezone to DateTime replication
    • - Connection - fixed so that the Project option timeout will not affect the connection timeout
    • - Scheduler - now recognizes tasks of all application types as valid
    • - Firebird - fixed the C library error
    • - Oracle - fixed some queries for specific server versions
    • - Installer
    • - fixed application remaining in the programs list on uninstall
    • - fixed remaining empty folders on uninstall
    • - fixed missing files after application upgrade in specific cases
  • v21.03.1637
    March 18, 2021
    • - Comparison - fixed review to correctly show tables in case some of the tables had errors
    • - Replication - fixed review to correctly show tables in case some of the tables had errors
    • - Connnection - clarified that SSH connections using Public Key Authentication needs a private key file
    • - Connnection - Connections report more meaningful error messages
    • MySQL
    • - fixed crash when index has a functional key part
    • - fixed target varbinary data format
    • - fixed target datetime precision truncating datetime(6)
    • Oracle - fixed some database queries for older versions
    • PostgreSQL
    • - fixed a replication index and primary key problem
    • - fixed replication and comparison of TIMESTAMP and SQL Server DATETIME2 columns
    • Siard - fixed project wizard review workers bug
  • v21.03.1636
    March 4, 2021
    • - Project wizard - optimized metadata read
    • - Open project - optimized metadata read
    • - Project options - optimized metadata read
    • - Connection - show all error messages when not able to connect
    • - Task scheduler - fixed a bug with the task selection
    • - Azure SQL - added include views as tables
    • - Derby - fixed reading of blob data types
    • - H2 - fixed a memory leak
    • - ODBC - fixed slow connecting to database
    • - MySQL - fixed column comments warning
    • - MySQL - fixed reading of primary key columns metadata
    • - MySQL - support for reading columns with GEOMETRY and GEOGRAPHY data types
    • - SIARD - fixed creating foreign keys
    • - SIARD - fixed row counts for tables
    • - SIARD - fixed nullability for columns
  • v21.02.1635
    February 11, 2021
    • - Log - handle locked files (creates a new file with a datetime as a suffix)
    • - Access - fixed some data errors with NULL and empty strings and money
    • - Access - added reading of foreign key action (on update/delete)
    • - Excel - when target, rows now spill into new files instead of throwing an error
    • - MySQL - char and nchar columns over 255 precision now map to TEXT columns
    • - MySQL - removed created not needed temporary indexes
    • - PostgreSQL - FIX OVERRIDING SYSTEM VALUE error on insert on older versions
    • - PostgreSQL - added reading of foreign key actions (on update/delete)
    • - Redshift - various fixes and improvements
    • - SqlServer - fix decimal overflow error when more than 28 digits present (truncate)
  • v21.01.1634
    January 18, 2021
    • - Optimize on demand metadata get and project validation
  • v21.01.1633
    January 13, 2021
    • - Project wizard - optimized workflow
    • - Project run - fixed disconnect error
    • - Project options - added table and column mapping (* is a wildcard, equals, starts*, *ends, *contains*, ordered by input (new line), first case insensitive match wins, eg, starts*=changedName)
    • - Conversion - new warning when index creation is skipped because there is an index with the same column sequence
    • - Conversion - create will respect deselected Incrementing option from Project options
    • - Conversion - won't try to disable identity insert when the identity is a sequence
    • - Conversion - won't try to disable identity insert when there is no source and identity (but there is a target)
    • - MS Access - fix when defaults leading with equality symbol "="
    • - Removed official support for FileMaker and QuickBooks
  • v20.12.1632
    December 14, 2020
    • - Fix settings page not going back
  • v20.12.1631
    December 9, 2020
    • - Conversion - optimized so project wizard does not get target metadata (if needed data is fetched on project options change)
    • - Conversion - where we can replace the null character with an empty string
    • - Conversion - added a delta copy option (only copy rows with larger PK than current target MAX)
    • - Comparison - optimized when only looking for inserts (and key is integral)
    • - Comparison - added Project option to ignore null characters (enabled by default)
    • - Comparison - fixed XML comparison (sometimes reported false difference)
    • - MySQL - fixed reading table comments when more than 10 tables are selected for conversion
    • - ODBC - fixed missing DSN error when Connection string selected
    • - Paradox - fixed no data shown Browse source/target
    • - Scheduler - fixed not deleting old task on save
    • - SIARD - fixed encoding of table and column comments
    • - SQL Server - fixed loading of hierarchyid target type from text source
    • - Sybase Advantage - fixed 32-bit application assembly version mismatch
  • v20.10.1630
    October 26, 2020
    • - Fixed reporting the count of copied rows when custom WHERE clause is applied
    • - Project - you can now view error details while the project is running
    • - CSV - fixed charset dropdown
    • - Access - fixed a size 0 problem when loading variable length data in some projects
    • - Access - fixed a precision and scale problem with decimal types ("type 14") in some projects
  • v20.10.1629
    October 6, 2020
    • - Trial - changed that it is always the Utimate version
    • - Project review - Fixed clearing of errors and warnings on deselected tables
    • - NexusDB - fixed index and foreign key table operation errors when more than 1 worker
  • v20.10.1628
    October 1, 2020
    • - Comparison - fix crash when special Unicode characters in data
    • - Log SqlStatements - fix crash when special Unicode characters in data
    • - Fix error on certain databases missing metadata
    • - SSH - added SSH server port input in connection info
    • - Ingres - support for writing long byte type
    • - PostgreSQL - Limit batch size when geometry type in target table
  • v20.09.1627
    September 22, 2020
    • - Restart IDENTITY problem is now reported as warning
    • - Additional where clause fixes
    • - Scheduler - fixed arguments not valid error with a missing space
    • - DB2 - split into LUW and zOS databases
    • - InterBase - fixed compatibility with older database versions
  • v20.09.1626
    September 15, 2020
    • Table creation in certain databases fixed
  • v20.09.1625
    September 15, 2020
    • - Project - Reworked progress UI for clearer info
    • - Project - on open let source and target connection errors pass so they can be corrected
    • - Project options - fixed source and target where clause not applying
    • - Settings - added debug log option
    • - Scheduler - automatically add -actcode to arguments if selected user is not the current user
    • - CockroachDB - added to the list of DBs
    • - DB2 - FOR BIT DATA columns are now automatically mapped as blob type
    • - Greenplum- added to the list of DBs
    • - MariaDB- added to the list of DBs
    • - OracleRDB - moved to PRO+
    • - PostgreSQL - added support for geography data type
    • - SIARD - fix memory issues
    • - 32bit - Fix assembly version errors
  • v20.08.1624
    August 27, 2020
    • - License - fixed problem with activation of features in some cases
    • - License - engine list in Project Wizard will update depending on the license without app restart
    • - PostgreSQL - fixed error reporting on create sequences (older server versions problem)
    • - SIARD - fixed table comments
  • v20.08.1623
    August 26, 2020
    • PostgreSQL - fix target crash
  • v20.08.1622
    August 25, 2020
    • - Project wizard - added warning on conversion if databases are the same
    • - Localization - added localizations
    • - Table creation - fixed DDL for not null, not mappable column default
    • - Firebird/Interbase - fixed reading "blob subtype 1" as encoded text
    • - MySQL - fixed/removed datetime precision for versions lower than 5.6
  • v20.08.1621
    August 20, 2020
    • - Project - added "Show last project run review"
    • - Project - added "Browse source" functionality
    • - Project options - fixed Log Autofill and Clear discards pending changes
    • - Project options - added comparison temp data folder location option as a PRO+ feature
    • - Table mapping - added case insensitive search if no table with correct project casing found
    • - Summary log - fixed and added more details for replication projects
    • - Replication review - removed explore differences (visible on comparison review only)
    • - Console app - clear project temporary files after project run
    • - Console app - added "-lw" option for logging warnings
    • - Console app - log locations are now inherited from the project file and can be overridden with arguments
    • - Excel - fixed error getting columns when there are multiple sheets in a workbook
    • - Postgres - display table sizes in bytes
    • - Progress OpenEdge - added table and column name literals if needed
    • - MSSQL - fixed network and local instance enumeration
  • v20.08.1619
    August 12, 2020
    • - Using DELETE statements instead of TRUNCATE statements to avoid referential integrity rules blocking the deletes
  • v20.08.1618
    August 6, 2020
    • - Fixed H2 BLOB data
    • - Revamped activation when no Internet connection
    • - Optimized project overview screen for very small screens
  • v20.08.1617
    August 4, 2020
    • - Fixed data replication scheduled tasks
  • v20.07.1616
    July 31, 2020
    • - Table differences by default no longer display matching records
    • - Limited the maximum space database name will take in the UI to avoid table list being pushed to the side
  • v20.07.1615
    July 30, 2020
    • - Comparison for a table now doesn't stop on the first error
    • - Table mapping - fixed not being able to exit the screen when no columns are present
    • - Table mapping - fixed column automatically selects when manual mode
    • - Validate table mapping - fixed not remapping tables when source database is changed
    • - Validate table mapping - fixed errors not removing when not present
    • - UI bugs fixes and improvements
    • - Added additional datetime parsing formats
    • - MySQL - added precision to datetime columns where versions is 5.6+
    • - MySQL - fixed comparison error when datetime column is part of a key
    • - MySQL - raised metadata read timeout
  • v20.07.1614
    July 28, 2020
    • - Fix TableMapping selection
    • - Fix Drop tables on target that do not exist
    • - Expand project opening and compare error logging
    • - ODBC - if no clustered index found use first unique index as primary key
  • v20.07.1613
    July 27, 2020
    • - Added delete if truncate fails
    • - Fixed ordering of tables by FK dependencies
    • - DB2 - fixed reading of index and foreign key metadata
    • - H2 - added reading of index uniqueness
    • - MySQL - fixed CHAR(36) column data requiring to be a valid GUID
    • - SQLite - fixed time comparison
    • - SQLite - datetime conversion now includes milliseconds
    • - SQLite - varbinary to BLOB conversion is now inserted as binary data not as a hex string
  • v20.07.1611
    July 16, 2020
    • - Remove extraneous options from replication projects
    • - Oracle version 8 and lower improvements
    • - Fix SQLite metadata read error
  • v20.07.1610
    July 16, 2020
    • - Oracle version 8 and lower improvements
    • - Fix assembly mismatch error
  • v20.07.1609
    July 15, 2020
    • - Added Update functionality
    • - Internal SQLite tables are now filtered out automatically
    • - SqlBase - Added reading of FK delete actions
    • - Added "Sort keys in memory" comparison option
    • - Fixed Oracle Server v.8 or lower connection
    • - Fixed manual table mapping existing case sensitive target columns
    • - Fixed SqlLog double logging of constraints
  • v20.07.1608
    July 7, 2020
    • - Added support for InterBase/Firebird table/column comments
    • - Fixed Firebird parallel metadata operations errors
    • - Fixed Firebird server connection (always used embedded server)
    • - Fixed Derby connections auto commit error
    • - Fixed datetime comparison - milliseconds were ignored
    • - Fixed added and deleted rows replication
  • v20.07.1607
    July 1, 2020
    • - Added Oracle system tables filter override
  • v20.06.1605
    June 30, 2020
    • - Improved internal error logging
  • v20.06.1604
    June 26, 2020
    • - Improved performance of Oracle metadata analysis
  • v20.06.1603
    June 24, 2020
    • - Fixed instant anonymous trial flow
  • v20.06.1602
    June 24, 2020
    • - New trial flow without activation codes
    • - Added trial onboarding screens
    • - Updated UI buttons and icons
    • - Added show logs to Conversion general review
    • - Added "Filter by differences" to Replication detail review
    • - Added number of errors in tables information while running a project
    • - Added error/warning links to Project detail reviews
    • - Added error/warning link buttons to tables with an error/warning
    • - Changed the error/warnings views to show distinct items with a number of instances
    • - Fixed error/warning reporting
    • - Fixed telemetry error reporting
    • - Fixed Custom key indicator on tables showing on convert projects
    • - Fixed manual table name mapping
    • - Fixed InterBase memory usage
  • v20.06.1601
    June 10, 2020
    • - Custom WHERE condition is back
    • - Fixed embedded Firebird server, and added more specific warnings
    • - Fixed Interbase/Firebird disconnect from database
    • - Fixed target table name when editing source connection in the open project
  • v20.06.1600
    June 8, 2020
    • - Simplified table mapping screen. Indexas and foreign keys can no longer be created in "expect existing table" mode
    • - Added project mapping validation button for user to check everything before the conversion takes place, as needed
    • - Fixed Firebird and Interbase currency type mapping
    • - Fixed Firebird and Interbase port connection
    • - Fixed SIARD LOB output and producer application signature
    • - Fixed clearing of errors and warnings between consecutive runs
    • - Fixed that warnings are shown on Detailed Review
    • - Fixed data copying when in "expect existing table" mode
  • v20.06.1599
    June 3, 2020
    • - Complete migration engine rewrite to support upcoming more powerful plans
    • - Massive speedup in many areas of the application, particularly project opening and metadata reading
    • - Added conversion review details screen where each table's particulars can be examined
    • - Touched up each screen to improve the information and make the application easier to use
  • v20.03.1584
    March 19, 2020
    • - Significantly reduced the number of commits for Oracle target
  • v20.03.1583
    March 2, 2020
    • - Support binary data to UTF8 text custom datatype mapping
    • - Gracefully handle the case when selected source table no longer exists
  • v20.02.1582
    February 18, 2020
    • - Fixed SIARD writer schema location
  • v20.01.1581
    January 21, 2020
    • - Fixed DB2 foreign key parsing
    • - Improved reporting of errors when reading metadata
  • v20.01.1580
    January 16, 2020
    • - Fixed reading of Ingres indexes
  • v20.01.1579
    January 16, 2020
    • - Improved handling of tables where columns have the same name in a different case
  • v20.01.1578
    January 10, 2020
    • - Fixed MySQL bit and bigint unsigned datatype handling
  • v20.01.1577
    January 10, 2020
    • - Added support for VistaDB 6
  • v19.12.1576
    December 30, 2019
    • - Fixed datatype mapping of Sybase Advantage databases
  • v19.12.1574
    December 23, 2019
    • - Improved Vertica bulk copy
  • v19.12.1573
    December 11, 2019
    • - Fixed reading of primary keys from Vertica database
  • v19.12.1572
    December 6, 2019
    • - Fixed the migration of precise Oracle float fields to Vertica
  • v19.12.1571
    December 5, 2019
    • - Fixed reading of dBase IV memo files
    • - Fixed handling of MySQL zero dates
  • v19.11.1570
    November 19, 2019
    • - Added selection of Ingres character set on its connection screen
  • v19.11.1569
    November 18, 2019
    • - Improved creation of empty databases
    • - Fixed the case where we couldn't connect to the Postgres target
  • v19.11.1568
    November 6, 2019
    • - Handled the case when user doesn't have a permission to read "postgres" database when checking if target database already exists
  • v19.11.1567
    November 4, 2019
    • - Updated MySQL driver
    • - Optimized reading of MySQL constraints
    • - Now reading Interbase/Firebird primary key names correctly
  • v19.10.1566
    October 28, 2019
    • - Fixed the support for MySQL comments
  • v19.10.1565
    October 24, 2019
    • - Removed the DB2 driver which bombs in a 32-bit version
  • v19.10.1564
    October 22, 2019
    • - Fixed handling of certain Unicode data for SQL Server target when a troubleshooting single-record insert mode is used
  • v19.10.1563
    October 22, 2019
    • - Added support for MySQL comments
  • v19.10.1562
    October 18, 2019
    • - Worked around Gupta SQLBase driver cursor limit bug
  • v19.10.1561
    October 16, 2019
    • - Fixed Firebird BIGINT datatype detection
  • v19.10.1560
    October 16, 2019
    • - Implemented automated detection of newly added columns for manually mapped tables
    • - Supported Sybase Advantage NVARCHAR columns in direct mode
  • v19.10.1559
    October 15, 2019
    • - Updated PostgreSQL metadata reading for version 12.0 system view changes
    • - Updated Gupta SQLBase connection to properly handle both local and remote connections
  • v19.10.1558
    October 14, 2019
    • - Fixed Sybase SQL Anywhere identity column handling
  • v19.10.1557
    October 14, 2019
    • - Removed rounding of the total records processed value in the logs
  • v19.10.1556
    October 8, 2019
    • - Fixed the topological sorting algorithm when "Expect tables to exist" option is used
  • v19.10.1555
    October 7, 2019
    • - Changed the table list section - it now resizes with the screen
    • - Analyzing dependencies from the target database metadata when "Expect tables to exist" option is used
    • - Fixed a rare table mapping dialog issue happening with a new project only
  • v19.10.1554
    October 5, 2019
    • - Upgraded Postgres database adapter
  • v19.10.1553
    October 4, 2019
    • - Fixed Postgres database dropdown
  • v19.10.1551
    October 2, 2019
    • - Changed Firebird default character set to UTF8 (it was None before)
  • v19.10.1550
    October 2, 2019
    • - Using identity instead of sequences for Postgres 10+
    • - Spatial data is converted as TEXT to Postgres when PostGIS is not installed to avoid breaking the conversion
  • v19.10.1549
    October 1, 2019
    • - Added support for DB2 z/OS
    • - Removed SQL script database engine as that part is better served with our other products
    • - Fixed SSH tunnelling for remote connection to locked-in environments
    • - Vector application icon is now used to benefit HiDPI screens
    • - Updated UI components
    • - Improved scheduled task error messages
    • - Improved support for maximum-precision Oracle NUMBER datatype
    • - Calling commit on every 10k records instead 100k for Oracle target
  • v19.05.1544
    May 24, 2019
    • - Updated visual components library
  • v19.05.1543
    May 22, 2019
    • - Fixed Oracle connection broken in the last build
    • - Fixed broken icons
  • v19.05.1542
    May 21, 2019
    • - Fixed error messages of the scheduled tasks
  • v19.05.1541
    May 21, 2019
    • - Updated icons throughout the application
  • v19.05.1540
    May 14, 2019
    • - Updated SQL Server Compact database driver to v4.0 (old v3.5 databases can be in-place upgraded)
  • v19.04.1539
    April 17, 2019
    • - Removed VERSION from the list of Firebird reserved words
  • v19.04.1538
    April 16, 2019
    • - Optimized SSH tunnels by no tearing the tunnels down on each re-connect
    • - Fixed SSH tunnels connections where the remote machine is connecting to the database on a 3rd machine
  • v19.03.1537
    March 25, 2019
    • - Added Oracle provider selection (Oracle managed and Devart). It's possible in the future we'll use just one again, but with Oracle's complexity we now want to offer choice to our customers.
    • - Fixed SIARD backslash path separator in LOB data
    • - Fixed specification of initial sequence values
  • v19.02.1536
    February 28, 2019
    • - Adjusted hardware fingerprinting on non-English Windows versions to avoid occasional deactivation via scheduled tasks
  • v19.02.1535
    February 27, 2019
    • - Added character set selection to Sybase Advantage direct mode
  • v19.02.1534
    February 20, 2019
    • - Improved table column DEFAULT value translations
  • v19.02.1533
    February 19, 2019
    • - Added support for huge Sybase Advantage tables
  • v19.02.1532
    February 19, 2019
    • - Added support for mixed Sybase Advantage databases (DBF/ADT)
  • v19.02.1531
    February 18, 2019
    • - Improved auto-detection of nullable columns in primary keys and adjustment of both target table definitions and data copying for these cases
  • v19.02.1530
    February 18, 2019
    • - Added JSON log to the scheduled task
    • - Reverted to Postgres sequences and removed IDENTITY for PG10+ to fix a starting value bug - will reintroduce IDENTITY later
  • v19.02.1529
    February 12, 2019
    • - Fixed name escaping of Firebird dialect 1 databases
  • v19.02.1528
    February 12, 2019
    • - Fixed the error handling certain Postgres domains
  • v19.01.1527
    January 25, 2019
    • - Improved handling of unicode characters in table and field names (Japanese etc.)
  • v19.01.1526
    January 25, 2019
    • - Added HSQLDB identity support
  • v19.01.1525
    January 24, 2019
    • - When decimal datatype is used in source database with identity attribute, Postgres target will now propagate datatype change to int/bigint for such columns, as well as affected foreign key columns
  • v19.01.1524
    January 23, 2019
    • - Upgraded Derby to v10.14.2.0
  • v19.01.1523
    January 22, 2019
    • - Added primary key detection for Progress OpenEdge database
  • v19.01.1522
    January 17, 2019
    • - Fixed SIARD slash/backslash path separator parsing
  • v19.01.1521
    January 16, 2019
    • - Fixed DBF field names character set
  • v19.01.1520
    January 10, 2019
    • - Fixed support for Firebird user roles
  • v18.12.1519
    December 21, 2018
    • - Fixed reading of certain old project files
  • v18.12.1518
    December 13, 2018
    • - Fixed SIARD restore of Oracle binary FLOAT precision
  • v18.12.1517
    December 12, 2018
    • - Added support for Interbase and Firebird user roles
    • - Fixed MySQL/MariaDB SSL connections
  • v18.12.1516
    December 9, 2018
    • - Fixed FLOAT and REAL datatype creation for SQLCE target
    • - Fixed handling of maximum database size parameter for SQLCE target
  • v18.12.1515
    December 6, 2018
    • - From now on, removing umlauts from table and column names when creating database in Firebird target
  • v18.12.1514
    December 5, 2018
    • - Changed application icon
    • - Updated UI components and database providers
    • - Optimized handling of interface element lists
  • v18.11.1513
    November 30, 2018
    • - Fixed Unicode text regression with new MySQL database provider
  • v18.11.1512
    November 28, 2018
    • - Fixed handling of Postgres INTERVAL data type
  • v18.11.1511
    November 20, 2018
    • - Fixed metadata reading of Pervasive decimal number definitions
  • v18.11.1510
    November 16, 2018
    • - Improved Oracle bulk loader to issue a commit on every 100k records instead of once at the end
  • v18.11.1509
    November 16, 2018
    • - Extended Sybase Advantage to support both client/server connections and our own direct binary file reading
  • v18.11.1508
    November 16, 2018
    • - Various fixes for Teradata target
  • v18.11.1507
    November 14, 2018
    • - Updated SQL Server reserved words list
  • v18.11.1506
    November 13, 2018
    • - Fixed parsing of Teradata TIMESTAMP precision
  • v18.11.1505
    November 13, 2018
    • - Redesigned wizard screens to make the buttons stand out more
  • v18.11.1504
    November 12, 2018
    • - Reworded project wizard final screen to make it clear there are additional customizations available
  • v18.11.1503
    November 12, 2018
    • - Fixed parsing of default values for MySQL 3.x
  • v18.11.1502
    November 9, 2018
    • - Fixed reading of certain Teradata datatypes
  • v18.11.1501
    November 8, 2018
    • - Fixed QuickBooks metadata reading
  • v18.11.1500
    November 7, 2018
    • - Fixed parsing of MySQL 3.23 metadata
  • v18.11.1499
    November 7, 2018
    • - Clarified wording on offline activation screen
  • v18.10.1498
    October 29, 2018
    • - Fixed handling of very old Postgres servers
  • v18.10.1497
    October 25, 2018
    • - Fixed handling of DB2 bigint type
  • v18.10.1496
    October 23, 2018
    • - Added reading of referential actions from Sybase SQL Anywhere
  • v18.10.1495
    October 22, 2018
    • - Fixed index type parsing in Sybase SQL Anywhere
    • - Improved analysis of default values in Sybase SQL Anywhere
  • v18.10.1494
    October 19, 2018
    • - Improved handling of BOOLEAN types in SIARD
  • v18.10.1493
    October 19, 2018
    • - Added Teradata support
    • - Fixed reading meta-data for MySQL
  • v18.10.1492
    October 16, 2018
    • - Fixed handling of certain NexusDB table column default values
  • v18.10.1491
    October 16, 2018
    • - Changed MySQL database provider to provide compatibility with all MySQL Servers versions (3.23 and later)
  • v18.10.1490
    October 12, 2018
    • - Sybase Advantage database support rewritten to use Advantage Server
    • - Fixed NexusDB list of reserved words
    • - Removed exclusive lock on log files during the conversion time, so they can be inspected while conversion is still running
  • v18.10.1489
    October 5, 2018
    • - Fixed handling of NexusDB Extended datatype
  • v18.10.1488
    October 1, 2018
    • - Added schema mapping override console parameter
  • v18.09.1487
    September 28, 2018
    • - Upgraded NexusDB database provider
  • v18.09.1486
    September 24, 2018
    • - Fixed H2 target date encoding
  • v18.09.1485
    September 20, 2018
    • - Fixed SIARD 2.1 compatibility issues
    • - Temporarily downgraded Postgres database provider as some users reported problems with the new one
  • v18.09.1484
    September 19, 2018
    • - Added support for ENUM types in Postgres
  • v18.09.1483
    September 14, 2018
    • - Fixed compatibility issues with certain Postgres server versions
  • v18.09.1482
    September 14, 2018
    • - Added support for Advantage indexes
  • v18.09.1481
    September 14, 2018
    • - Fixed automatic creation of target Postgres database when name is given in mixed-case
  • v18.09.1480
    September 6, 2018
    • - Updated supporting libraries
    • - Align SIARD 2.1 support to the specification for storing string data containing single or multiple consecutive space characters
  • v18.09.1478
    September 3, 2018
    • - Added support for SQLite autoincrement columns (integer primary key)
  • v18.08.1477
    August 21, 2018
    • - Fixed handling of certain Access driver expections
  • v18.08.1476
    August 20, 2018
    • - Added support for Amazon RedShift
  • v18.08.1475
    August 16, 2018
    • - Added support for SIARD 2.1
    • - Added int datatype to SQLite target instead of forcing bigint for all integral types
  • v18.08.1474
    August 7, 2018
    • - Improved auto-detection of Paradox and Interbase databases
  • v18.08.1473
    August 7, 2018
    • - Added missing IKVM dlls
    • - Fixed HSQLDB reserved word handling
  • v18.08.1472
    August 6, 2018
    • - Fixed Informix boolean datatype detection
    • - Fixed reading of MySQL data types from SQL script files
  • v18.08.1471
    August 1, 2018
    • - Updated support for Java databases (Derby, H2, HSQLDB)
  • v18.08.1470
    August 1, 2018
    • - Fixed certain edge cases in Paradox BCD data reading
  • v18.07.1469
    July 23, 2018
    • - Fixed reading of Paradox BCD and graphic fields
  • v18.07.1468
    July 18, 2018
    • - Applied target casing for index column names to fix index creation issues in certain project configurations
  • v18.07.1467
    July 5, 2018
    • - Improved support for Postgres timestamp with timezone type
  • v18.07.1466
    July 2, 2018
    • - Improved support for Ingres blank date configuration setting, again
  • v18.06.1465
    June 29, 2018
    • - Fixed Oracle index reading for cases when index owner is different than table owner
    • - Changed Oracle index naming, removed schema prefix from the name
  • v18.06.1464
    June 28, 2018
    • - Fixed handling of Firebird triggers with empty definition
  • v18.06.1463
    June 20, 2018
    • - Added support for Ingres blank date configuration setting
  • v18.06.1462
    June 19, 2018
    • - Fixed PostgreSQL bytea loading in single-record insert mode
  • v18.06.1461
    June 18, 2018
    • - Updated Progress reserved words
  • v18.06.1460
    June 13, 2018
    • - Improved Excel compatibility with certain combination of Microsoft Windows and .NET Framework
  • v18.06.1459
    June 12, 2018
    • - Improved Firebird compatibility with certain combination of Microsoft Windows and .NET Framework
    • - Fixed Access target bulk load
  • v18.06.1458
    June 11, 2018
    • - Fixed SIARD application descriptor
  • v18.06.1457
    June 8, 2018
    • - Added a warning when we force a column to be NOT NULL due to the fact it's a part of primary key
  • v18.06.1456
    June 6, 2018
    • - Added more required files to the installer
  • v18.06.1455
    June 5, 2018
    • - Fixed Interbase connector having a missing DLL
  • v18.06.1454
    June 5, 2018
    • - Added support for MySQL 8.0 target database creation
    • - Added support for Pervasive bit datatype
    • - Fixed Oracle cascade constraints
    • - Fixed Progress reserved words detection
  • v18.05.1453
    May 16, 2018
    • - Added support for MySQL/MariaDB OVER keyword
  • v18.05.1452
    May 15, 2018
    • - Upped .NET Framework requirement to version 4.6.1 or later (Microsoft's limitation due to the fact we are migrating most of our projects to be cross-platform for upcoming cloud solutions)
    • - Updated MySQL connector for compatibility with new MySQL 8.0 default authentication mode
  • v18.04.1451
    April 27, 2018
    • - Fixed ODBC connection string validation
  • v18.04.1450
    April 27, 2018
    • - Added handling of Firebird triggers with empty definition
  • v18.04.1449
    April 23, 2018
    • - Improved display of source database's data types in SIARD archive
  • v18.04.1448
    April 20, 2018
    • - Improved compatibility with old versions of Gupta SQLBase
  • v18.04.1447
    April 17, 2018
    • - Improved offline activation process
  • v18.04.1446
    April 16, 2018
    • - Changed internal column delimiter for Vertica target's bulk copy from pipe character to zero-byte character.
  • v18.04.1445
    April 16, 2018
    • - Improved error handling of invalid console parameters
  • v18.04.1444
    April 16, 2018
    • - Included build number in SIARD target producerApplication field
  • v18.04.1443
    April 11, 2018
    • - Improved compatibility loading of old Full Convert 5 project files
  • v18.04.1442
    April 11, 2018
    • - Turned on compression for SIARD output by default
  • v18.04.1441
    April 11, 2018
    • - Fixed Vertica bulk loading of long binary and text data
    • - Added reporting of rejected records for Vertica bulk loader
  • v18.04.1440
    April 10, 2018
    • - Implemented customizable SIARD target file compression
  • v18.04.1439
    April 10, 2018
    • - Removed "Include views" checkbox from the target connection screen as it's not relevant for target
  • v18.04.1438
    April 10, 2018
    • - Fixed creation of Oracle sequences starting with 64-bit numbers
    • - Fixed copying of very large numbers (larger than 15 decimal places) into Oracle when bulk copy is used
  • v18.04.1437
    April 10, 2018
    • - Fixed boolean type for Interbase target
  • v18.04.1436
    April 9, 2018
    • - Added codepage 949 support for Paradox
  • v18.03.1435
    March 28, 2018
    • - Fix Oracle BLOB reading memory leak
  • v18.03.1434
    March 20, 2018
    • - Added email "from" option
  • v18.03.1433
    March 16, 2018
    • - Added a button to Project options to quickly pre-fill all logs in a selected folder
  • v18.03.1432
    March 14, 2018
    • - Fixed omissions reading schemas and user-defined types in certain optimized conversion paths
  • v18.03.1431
    March 13, 2018
    • - Fixed column selected when "Expect existing tables" project option is used
    • - Fixed reinitialization of project options after active project is closed
  • v18.03.1430
    March 13, 2018
    • - Updated SQL Server and SQL Azure loaders to reduce transaction log size impact on large loads
  • v18.03.1429
    March 8, 2018
    • - Added extra logging for certain problems encountered by our users
  • v18.03.1428
    March 7, 2018
    • - Improved error messages for unexpected errors with table mapping
  • v18.03.1427
    March 6, 2018
    • - Improved error messages for unexpected errors with table mapping
  • v18.03.1426
    March 5, 2018
    • - Fixed handling of unexpectedly unmatched columns in table mapping dialog
  • v18.03.1425
    March 1, 2018
    • - Fixed incrementing columns for Access target
  • v18.02.1424
    February 27, 2018
    • - Added reading of schema name for SQL Server user-defined types
  • v18.02.1423
    February 26, 2018
    • - Added external BLOB files digest (MD5/SHA-1/SHA-256) to SIARD
  • v18.02.1422
    February 22, 2018
    • - Added project option to disable incrementing columns
  • v18.02.1420
    February 21, 2018
    • - Fix SIARD target special character encoding
  • v18.02.1419
    February 21, 2018
    • - Improved handling of missing tables in source database
  • v18.02.1418
    February 19, 2018
    • - Improved support for Oracle float with binary precision
  • v18.02.1417
    February 14, 2018
    • - Improved fallback to embedded Firebird server
  • v18.02.1416
    February 14, 2018
    • - Improved support for ODBC drivers using old ODBC specification
  • v18.02.1415
    February 12, 2018
    • - Supported creation of SIARD files with data omitted, but with correct metadata
  • v18.02.1414
    February 9, 2018
    • - Fixed table comments
  • v18.02.1413
    February 9, 2018
    • - Fixed SIARD creation from certain file-based databases
  • v18.02.1412
    February 9, 2018
    • - Fixed detection of system hard drive
    • - Added support for table and column comments for SQL Server, Oracle and Postgres targets
  • v18.02.1411
    February 8, 2018
    • - Allow multiple emails to be specified for the console notifications
    • - Made the email notification SMTP server authentication optional
  • v18.02.1410
    February 7, 2018
    • - Changed email sending component for improved reliability
  • v18.02.1409
    February 7, 2018
    • - Improve decimal value support in SIARD reader for differing regional settings
  • v18.02.1408
    February 6, 2018
    • -Preserve SIARD target connection information
  • v18.02.1407
    February 5, 2018
    • - Added console application email notifications to project options
  • v18.02.1406
    February 5, 2018
    • - Added database detection to the New project wizard
    • - Added support for drag&drop of database files to the application (only when project isn't open) to quickly start a new project
    • - Added support for offline activation in the Account screen, useful for trial customers adding registered activation code after purchase
    • - Console application now returns return code 0 when there are no errors (or there are only warnings) and non-zero for any errors
  • v18.01.1405
    January 30, 2018
    • - Improved validation of untouched connection parameters
  • v18.01.1404
    January 30, 2018
    • - Fixed Excel file listing issue happening in certain environments only
  • v18.01.1403
    January 30, 2018
    • - Fixed table selection issue introduced few days ago
  • v18.01.1402
    January 30, 2018
    • - Fixed Oracle connection issue introduced yesterday
  • v18.01.1401
    January 29, 2018
    • - Added recognition of invalid connection parameters and warning the user before connection attempt
  • v18.01.1400
    January 26, 2018
    • - Fixed SIARD XSD validation
  • v18.01.1398
    January 26, 2018
    • - Simplified GUI for SIARD External LOB folder parameter
  • v18.01.1397
    January 24, 2018
    • - Added support for relative log paths
  • v18.01.1396
    January 19, 2018
    • - Optimized internal memory usage for databases with many thousands of tables
    • - Streamlined UI for table selection in the project wizard
  • v18.01.1395
    January 18, 2018
    • - Allow reopening existing SIARD database as target, use read-only mode as this is an archival format
  • v18.01.1394
    January 18, 2018
    • - Create SIARD target database only when the file does not contain any tables
  • v18.01.1393
    January 16, 2018
    • - Added support for geography, geometry and hierarchyid datatypes for SIARD target
    • - Improved conversion review screen when fatal error happened
  • v18.01.1392
    January 15, 2018
    • - Added automatic handling of multiple worksheets in Excel files
  • v18.01.1391
    January 15, 2018
    • - Added warnings for notifications during conversion that aren't critical
  • v18.01.1390
    January 9, 2018
  • v17.12.1388
    December 19, 2017
  • v17.12.1387
    December 18, 2017
  • v17.12.1386
    December 11, 2017
  • v17.12.1385
    December 11, 2017
  • v17.12.1384
    December 8, 2017
  • v17.12.1383
    December 8, 2017
  • v17.12.1382
    December 5, 2017
  • v17.11.1379
    November 29, 2017
  • v17.11.1378
    November 27, 2017
  • v17.11.1377
    November 24, 2017
  • v17.11.1376
    November 22, 2017
  • v17.11.1375
    November 22, 2017
  • v17.11.1374
    November 20, 2017
  • v17.11.1373
    November 20, 2017
  • v17.11.1371
    November 20, 2017
  • v17.11.1370
    November 17, 2017
  • v17.11.1369
    November 17, 2017
  • v17.11.1368
    November 15, 2017
  • v17.11.1367
    November 14, 2017
  • v17.11.1365
    November 14, 2017
  • v17.11.1364
    November 14, 2017
  • v17.11.1363
    November 13, 2017
  • v17.11.1362
    November 13, 2017
  • v17.11.1361
    November 10, 2017
  • v17.11.1359
    November 10, 2017
  • v17.11.1358
    November 10, 2017
  • v17.11.1357
    November 10, 2017
  • v17.11.1356
    November 10, 2017
  • v17.11.1355
    November 10, 2017
  • v17.11.1354
    November 9, 2017
  • v17.11.1353
    November 7, 2017
  • v17.11.1352
    November 7, 2017
  • v17.11.1351
    November 7, 2017
  • v17.11.1350
    November 3, 2017
  • v17.11.1349
    November 2, 2017
    • - Added embedded Firebird servers to be able to open all Firebird files even when user has no Firebird server installed.
  • v17.10.1348
    October 31, 2017
  • v17.10.1347
    October 31, 2017
  • v17.10.1346
    October 30, 2017
  • v17.10.1345
    October 24, 2017
  • v17.10.1344
    October 23, 2017
  • v17.10.1343
    October 20, 2017
  • v17.10.1342
    October 19, 2017
  • v17.10.1341
    October 19, 2017
  • v17.10.1340
    October 19, 2017
  • v17.10.1339
    October 18, 2017
  • v17.10.1338
    October 18, 2017
  • v17.10.1337
    October 18, 2017
  • v17.10.1336
    October 17, 2017
  • v17.10.1335
    October 17, 2017
  • v17.10.1334
    October 12, 2017
  • v17.10.1333
    October 12, 2017
  • v17.10.1332
    October 11, 2017
  • v17.10.1331
    October 11, 2017
  • v17.10.1330
    October 11, 2017
  • v17.10.1329
    October 10, 2017
  • v17.10.1328
    October 9, 2017
  • v17.10.1327
    October 5, 2017
    • - New versioning scheme. Taken from Ubuntu Linux: Year.Month.Build. It makes much more sense with our continuous , almost daily, deployment of features.
    • - Oracle views can now be read as tables
    • - We can now read SQL script files and directly migrate them to target databases. Table selection, column mapping etc. are fully supported.
  • Full Convert 7.9 released
    December 29, 2016
    • - New installer
    • - Faster metadata reading for certain databases
    • - Faster Oracle bulk data loading
    • - List of scheduled tasks now updates in real-time
    • - Added LocalDB support
    • - Added support for different character sets for Pervasive
    • - Added support for new MySQL JSON datatype
    • - Added support for new Firebird bool datatype
    • - Improved Sybase Advantage file reader
    • - Fixed scheduled tasks permissions issues for certain environments
    • - Fixed logging of SQL errors
  • v7.9.1082
    January 19, 2017
  • v7.9.1081
    January 19, 2017
  • v7.9.1076
    January 19, 2017
  • v7.9.1075
    January 13, 2017
  • v7.9.1074
    January 11, 2017
  • v7.9.1073
    January 11, 2017
  • v7.9.1072
    December 30, 2016
  • v7.9.1071
    December 30, 2016
  • Full Convert 7.8 released
    September 21, 2016
    • - Added full support for SQL Express LocalDB
  • v7.8.1020
    September 26, 2016
  • v7.8.1019
    September 26, 2016
  • v7.8.1018
    September 23, 2016
  • v7.8.1017
    September 22, 2016
  • v7.8.1016
    September 22, 2016
  • v7.8.1014
    September 21, 2016
  • v7.8.1013
    September 21, 2016
  • Full Convert 7.7 released
    August 26, 2016
    • - Add support for overriding connection parameters in console
    • - Using default system proxy when communicating with Spectral Core licensing server
    • - Improved tracing to preserve data across application runs
  • v7.7.1012
    September 20, 2016
  • v7.7.1011
    September 16, 2016
  • v7.7.1010
    September 15, 2016
  • v7.7.1009
    September 15, 2016
  • v7.7.1004
    September 15, 2016
  • v7.7.1004
    September 15, 2016
  • v7.7.1003
    September 15, 2016
  • v7.7.1002
    September 9, 2016
  • v7.7.1001
    September 9, 2016
  • Full Convert 7.6 released
    July 11, 2016
    • - Massive speedup handling huge databases with hundreds of thousands of tables
    • - Support Gupta SQLBase for both reading and writing
    • - Support Ingres for both reading and writing
    • - Implemented native Sybase Advantage reader, no drivers needed
    • - Project-wide nullability enforcing
    • - Timestamp-named logs now respect specified folder
    • - We are now skipping disabled and untrusted foreign keys
    • - Fixed SQL Compact
    • - Add support for bigint data in CSV instead of promoting immediately to double datatype
    • - Respect SQL Server compatibility setting
    • - Added tracing information customer can send to developers when asked
  • Full Convert 7.5 released
    April 26, 2016
    • - Allow specification of list of tables to convert via console arguments
    • - Improve spatial data conversion
    • - Fixed running of custom SQL scripts before and after conversion
  • Full Convert 7.4 released
    April 7, 2016
    • - Optimized database structure reading to greatly reduce time needed for project loading and common operations
    • - SSL connections
    • - SSH tunnel for secure connections to remote servers
    • - Optimized options applying - table remapping only when options that affect mapping are changed
  • Full Convert 7.3 released
    March 8, 2016
    • - Added custom WHERE clause
    • - Added troubleshooting option to never disconnect (some ODBC drivers crash on disconnect)
  • Full Convert 7.20 released
    September 5, 2017
    • - Added support for FileMaker source database
  • Full Convert 7.2 released
    February 16, 2016
    • - Improved and clarified progress screen
    • - Added option to display data loading progress in circular chart
    • - Bugfixes
  • v7.20.1324
    October 3, 2017
  • v7.20.1323
    October 2, 2017
  • v7.20.1322
    October 2, 2017
  • v7.20.1321
    October 2, 2017
  • v7.20.1320
    September 30, 2017
  • v7.20.1319
    September 26, 2017
  • v7.20.1318
    September 26, 2017
  • v7.20.1317
    September 26, 2017
  • v7.20.1316
    September 25, 2017
  • v7.20.1315
    September 25, 2017
  • v7.20.1314
    September 22, 2017
  • v7.20.1311
    September 21, 2017
  • v7.20.1310
    September 21, 2017
  • v7.20.1309
    September 21, 2017
  • v7.20.1308
    September 21, 2017
  • v7.20.1307
    September 18, 2017
  • v7.20.1306
    September 18, 2017
  • v7.20.1305
    September 18, 2017
  • v7.20.1304
    September 15, 2017
  • v7.20.1303
    September 15, 2017
  • v7.20.1302
    September 13, 2017
  • v7.20.1301
    September 13, 2017
  • v7.20.1300
    September 12, 2017
  • v7.20.1299
    September 8, 2017
  • v7.20.1298
    September 8, 2017
  • v7.20.1296
    September 7, 2017
  • v7.20.1293
    September 6, 2017
  • v7.20.1292
    September 5, 2017
  • Full Convert 7.19 released
    September 4, 2017
    • - Bug fixes
  • v7.19.1290
    September 5, 2017
  • v7.19.1289
    September 5, 2017
  • v7.19.1288
    September 5, 2017
  • v7.19.1287
    September 5, 2017
  • v7.19.1286
    September 5, 2017
  • v7.19.1285
    September 5, 2017
  • v7.19.1284
    September 5, 2017
  • v7.19.1283
    September 5, 2017
  • v7.19.1278
    August 29, 2017
  • v7.19.1277
    August 29, 2017
  • v7.19.1276
    August 29, 2017
  • v7.19.1275
    August 28, 2017
  • v7.19.1274
    August 28, 2017
  • Full Convert 7.18 released
    July 31, 2017
    • - Rewritten and simplified schema mapping
  • v7.18.1270
    August 21, 2017
  • v7.18.1269
    August 21, 2017
  • v7.18.1268
    August 21, 2017
  • v7.18.1267
    August 18, 2017
  • v7.18.1266
    August 18, 2017
  • v7.18.1265
    August 16, 2017
  • v7.18.1264
    August 11, 2017
  • v7.18.1263
    August 2, 2017
  • v7.18.1262
    August 2, 2017
  • v7.18.1261
    August 2, 2017
  • v7.18.1260
    August 2, 2017
  • v7.18.1259
    July 31, 2017
  • v7.18.1258
    July 31, 2017
  • Full Convert 7.17 released
    July 21, 2017
    • - Intuit QuickBooks supported for reading via its QODBC driver
  • v7.17.1256
    July 30, 2017
  • v7.17.1255
    July 30, 2017
  • v7.17.1254
    July 28, 2017
  • v7.17.1253
    July 28, 2017
  • v7.17.1252
    July 28, 2017
  • v7.17.1251
    July 28, 2017
  • v7.17.1250
    July 28, 2017
  • v7.17.1249
    July 28, 2017
  • v7.17.1248
    July 27, 2017
  • v7.17.1247
    July 27, 2017
  • v7.17.1246
    July 27, 2017
  • v7.17.1245
    July 27, 2017
  • v7.17.1244
    July 27, 2017
  • v7.17.1243
    July 27, 2017
  • v7.17.1242
    July 27, 2017
  • v7.17.1241
    July 27, 2017
  • v7.17.1240
    July 27, 2017
  • v7.17.1239
    July 25, 2017
  • v7.17.1238
    July 25, 2017
  • v7.17.1237
    July 21, 2017
  • v7.17.1236
    July 21, 2017
  • Full Convert 7.16 released
    July 14, 2017
    • - Added full support for Vertica as source and target database
    • - Added Sybase SQL Anywhere and Sybase IQ view reading as if they are tables
  • v7.16.1235
    July 19, 2017
  • v7.16.1234
    July 19, 2017
  • v7.16.1233
    July 14, 2017
  • v7.16.1232
    July 14, 2017
  • v7.16.1230
    July 14, 2017
  • v7.16.1229
    July 14, 2017
  • Full Convert 7.15 released
    July 11, 2017
    • - JSON log with rich information added
    • - Added Sybase ASE view reading as if they are tables
    • - Improved handling of complex custom Oracle SQL scripts
    • - Improved handling of unexpected application crashes
  • v7.15.1227
    July 13, 2017
  • v7.15.1226
    July 12, 2017
  • v7.15.1225
    July 11, 2017
  • Full Convert 7.14 released
    June 12, 2017
    • - Added character set specification for CSV files
    • - Improved PostgreSQL sequence creation - all valid datatypes can now be incrementing
  • v7.14.1224
    June 22, 2017
  • v7.14.1223
    June 22, 2017
  • v7.14.1222
    June 21, 2017
  • v7.14.1221
    June 20, 2017
  • v7.14.1220
    June 20, 2017
  • v7.14.1219
    June 20, 2017
  • v7.14.1218
    June 17, 2017
  • v7.14.1217
    June 16, 2017
  • v7.14.1216
    June 15, 2017
  • v7.14.1218
    June 12, 2017
  • v7.14.1217
    June 12, 2017
  • Full Convert 7.13 released
    May 3, 2017
    • - added dBase 3 target format
    • - improved installer to not require uninstall of prior version when there is a new build in current minor release
    • - automatically fix foreign key datatype discrepancies
    • - no longer registering Interbase provider due to incompatibility with some systems and using private registration instead
    • - allowing long table names with DBF target even in old formats
    • - improved UI consistency in table listing across the application
  • v7.13.1216
    June 7, 2017
  • v7.13.1215
    June 5, 2017
  • v7.13.1214
    June 5, 2017
  • v7.13.1213
    June 5, 2017
  • v7.13.1212
    June 2, 2017
  • v7.13.1211
    June 1, 2017
  • v7.13.1210
    June 1, 2017
  • v7.13.1209
    May 28, 2017
  • v7.13.1208
    May 27, 2017
  • v7.13.1207
    May 26, 2017
  • v7.13.1206
    May 26, 2017
  • v7.13.1205
    May 26, 2017
  • v7.13.1204
    May 24, 2017
  • v7.13.1203
    May 23, 2017
  • v7.13.1202
    May 23, 2017
  • v7.13.1201
    May 23, 2017
  • v7.13.1200
    May 19, 2017
  • v7.13.1199
    May 18, 2017
  • v7.13.1198
    May 17, 2017
  • v7.13.1196
    May 14, 2017
  • v7.13.1195
    May 12, 2017
  • v7.13.1195
    May 12, 2017
  • v7.13.1194
    May 12, 2017
  • v7.13.1193
    May 8, 2017
  • v7.13.1192
    May 5, 2017
  • v7.13.1191
    May 3, 2017
  • Full Convert 7.12 released
    March 10, 2017
    • - added GUID support for HSQLDB database
    • - expanded CSV datatype detection such that numbers with leading zero and decimals with trailing zero (but not .0 exactly) are detected as text
    • - added support for SQLCE databases up to 4GB in size
    • - automatically reopen PostgreSQL connection in case when remote server closes it to avoid multiplying of reported errors
    • - automatically format time values in generated Excel documents
    • - improved handling of invalid log filenames
  • v7.12.1190
    May 3, 2017
  • v7.12.1189
    May 3, 2017
  • v7.12.1188
    May 3, 2017
  • v7.12.1187
    May 2, 2017
  • v7.12.1186
    May 2, 2017
  • v7.12.1185
    May 1, 2017
  • v7.12.1184
    April 27, 2017
  • v7.12.1183
    April 26, 2017
  • v7.12.1182
    April 26, 2017
  • v7.12.1181
    April 25, 2017
  • v7.12.1180
    April 24, 2017
  • v7.12.1179
    April 24, 2017
  • v7.12.1179
    April 13, 2017
  • v7.12.1178
    April 13, 2017
  • v7.12.1177
    April 13, 2017
  • v7.12.1176
    April 11, 2017
  • v7.12.1175
    April 10, 2017
  • v7.12.1174
    April 10, 2017
  • v7.12.1173
    April 7, 2017
  • v7.12.1172
    April 6, 2017
  • v7.12.1172
    April 6, 2017
  • v7.12.1172
    April 6, 2017
  • v7.12.1170
    April 5, 2017
  • v7.12.1168
    April 4, 2017
  • v7.12.1167
    April 4, 2017
  • v7.12.1166
    April 3, 2017
  • v7.12.1165
    April 3, 2017
  • v7.12.1164
    March 30, 2017
  • v7.12.1163
    March 29, 2017
  • v7.12.1162
    March 28, 2017
  • v7.12.1161
    March 27, 2017
  • v7.12.1160
    March 26, 2017
  • v7.12.1159
    March 24, 2017
  • v7.12.1158
    March 22, 2017
  • v7.12.1157
    March 22, 2017
  • v7.12.1155
    March 21, 2017
  • v7.12.1154
    March 21, 2017
  • v7.12.1153
    March 21, 2017
  • v7.12.1152
    March 21, 2017
  • v7.12.1151
    March 21, 2017
  • v7.12.1151
    March 21, 2017
  • v7.12.1151
    March 21, 2017
  • v7.12.1150
    March 21, 2017
  • v7.12.1149
    March 20, 2017
  • v7.12.1148
    March 20, 2017
  • v7.12.1147
    March 19, 2017
  • v7.12.1146
    March 19, 2017
  • v7.12.1145
    March 17, 2017
  • v7.12.1144
    March 17, 2017
  • v7.12.1143
    March 17, 2017
  • v7.12.1142
    March 15, 2017
  • v7.12.1141
    March 10, 2017
  • Full Convert 7.11 released
    March 2, 2017
    • - completely rewritten Excel support, several orders of magnitude speedup!
    • - added character set override option for DBF files
  • v7.11.1140
    March 9, 2017
  • v7.11.1139
    March 9, 2017
  • v7.11.1138
    March 9, 2017
  • v7.11.1137
    March 9, 2017
  • v7.11.1136
    March 9, 2017
  • v7.11.1135
    March 9, 2017
  • v7.11.1134
    March 9, 2017
  • v7.11.1133
    March 8, 2017
  • v7.11.1132
    March 8, 2017
  • v7.11.1131
    March 7, 2017
  • v7.11.1130
    March 7, 2017
  • v7.11.1129
    March 7, 2017
  • v7.11.1128
    March 6, 2017
  • v7.11.1127
    March 6, 2017
  • v7.11.1126
    March 6, 2017
  • v7.11.1125
    March 6, 2017
  • v7.11.1124
    March 3, 2017
  • v7.11.1123
    March 3, 2017
  • v7.11.1122
    March 2, 2017
  • v7.11.1121
    March 2, 2017
  • v7.11.1119
    March 2, 2017
  • Full Convert 7.10 released
    January 23, 2017
    • - Added ability to read views for MySQL, Interbase and Firebird source databases
  • Full Convert 7.1 released
    February 11, 2016
    • - All known bugs from the launch fixed
    • - Default values mapping
    • - Edit project connections anytime
    • - Allow loading project with invalid database connections and edit them post-load
  • v7.10.1118
    March 1, 2017
  • v7.10.1117
    March 1, 2017
  • v7.10.1116
    March 1, 2017
  • v7.10.1115
    March 1, 2017
  • v7.10.1114
    February 28, 2017
  • v7.10.1113
    February 28, 2017
  • v7.10.1112
    February 28, 2017
  • v7.10.1111
    February 21, 2017
  • v7.10.1110
    February 18, 2017
  • v7.10.1108
    February 18, 2017
  • v7.10.1107
    February 17, 2017
  • v7.10.1106
    February 17, 2017
  • v7.10.1105
    February 17, 2017
  • v7.10.1104
    February 16, 2017
  • v7.10.1103
    February 15, 2017
  • v7.10.1102
    February 15, 2017
  • v7.10.1101
    February 13, 2017
  • v7.10.1101
    February 13, 2017
  • v7.10.1100
    February 9, 2017
  • v7.10.1099
    February 8, 2017
  • v7.10.1097
    February 3, 2017
  • v7.10.1096
    February 2, 2017
  • v7.10.1094
    February 2, 2017
  • v7.10.1092
    January 30, 2017
  • v7.10.1089
    January 27, 2017
  • v7.10.1088
    January 27, 2017
  • v7.10.1087
    January 27, 2017
  • v7.10.1086
    January 27, 2017
  • v7.10.1084
    January 23, 2017
  • Full Convert 7.0 released
    January 22, 2016
    • Complete rewrite in a new technology!
    • All application areas have been greatly improved.
    • Significant performance boost.
    • Added support for following databases:
    • - IBM DB2
    • - Derby
    • - H2
    • - HSQLDB
    • - NexusDB
    • - Pervasive PSQL
    • - Progress OpenEdge
    • - Sybase Adaptive Server Enterprise
    • - Sybase SQL Anywhere
    • - VistaDB
  • Full Convert 6.9 released
    October 8, 2014
    • Added support for PostgreSQL OID datatype
  • Full Convert 6.8 released
    October 1, 2014
    • Fixed a nasty SQLCE bug where opening a database could cause it to be truncated
    • Improvements in SQLite default values handling
    • Bugfixes
  • Full Convert 6.7 released
    July 18, 2014
    • Added ODBC dialect
    • Bugfixes
  • Full Convert 6.6 released
    May 28, 2014
    • Improved trial activation process
    • Added number of tables to be converted (and skipped) to the project wizard to avoid confusion when table name filter is used
    • Bugfixes
  • Full Convert 6.5 released
    May 5, 2014
    • Respecting Firebird and Interbase maximum identifier length of 31 characters, making sure target identifiers are never duplicated
    • Updated database components
    • Bugfixes
  • Full Convert 6.4 released
    February 28, 2014
    • Much improved speed of reading Oracle metadata for large databases
    • Table filter in project wizard
    • Selective drop of foreign keys before dropping target table
    • Added indexes and constraints (both can be individually deselected) to table customization dialog
    • Added information of eventual fatal error to error list
    • Indexes and constraints are created separately instead in batch per table
    • Progress dialog lists information about each index and constraints as they are created
  • Full Convert 6.3 released
    February 10, 2014
    • Separate log for SQL that caused errors
    • Bugfixes
  • Full Convert 6.2 released
    October 28, 2013
    • Separate console application with much improved capabilities
    • Bugfixes
  • Full Convert 6.11 released
    November 20, 2014
    • Computed columns are now skipped when copying into existing tables
  • Full Convert 6.10 released
    October 23, 2014
    • Added support for PostgreSQL TSVECTOR datatype
  • Full Convert 6.1 released
    September 5, 2013
    • Added VisualFoxPro table selection from DBC file
    • Slightly changed conversion summary screen
    • Project customization status visible on ribbon
    • All customer issues reported after v6.0 launch fixed
  • Full Convert 6.0 released
    August 22, 2013
    • Largest update we have ever made!
    • Completely redesigned and modernized user interface
    • Instant help when connecting to databases
    • Support for any XML structure and intelligent creation of optimal target tables to represent original hierarchical structure
    • Full support for SQLite
    • dBase (DBF) is now supported as a target database
    • Encrypted Paradox tables are decrypted on the fly during conversion without even asking for a password
    • Much faster writing of BLOB data to SQL Server using BULK INSERT
    • Improved Excel engine
    • Overall improved performance and responsiveness
    • Improved conversion summary
    • Improved technical support - errors are automatically reported to developers and support tickets can be opened from the application
    • In-app upgrade
    • Bulk folder definition for each target database server computer separately
  • Full Convert 5.9 released
    November 11, 2010
    • Added checks if source and target database are the same. This is not allowed so that our users don't accidentally drop tables in source database, too.
    • Added fast chunking support to PostgreSQL source
    • Changed GUID conversion to MySQL to have { and } enclosing characters removed
    • We now automaticaly use Oracle UNISTR function when inserting Oracle data (not used in LOAD mode) when Unicode data is selected. This allows for automatic Unicode character insertion into databases with non-Unicode character set.
    • In trial version we won't try to show nag window when quiet mode is used (in scheduled run)
    • Fixed conversion of Oracle LONG values to SQL Server varbinary(max) - used with SQL2005+
    • Fixed conversion of SQL Server defaults containing Unicode strings
    • Fixed an error when resolving dependencies from tables not included in the conversion
  • Full Convert 5.8 released
    September 23, 2010
    • Added support for Excel cells containing very large text blocks
    • Added support for creating new Access 2007-2010 databases
    • Added a progress dialog when refreshing target database, as with large databases it takes some time
    • Fixed datetime default value translation for Interbase/Firebird target
    • Fixed showing of created XLSX documents for target databases
    • Fixed showing of created XML documents for target databases when table is not expanded in database tree
    • Fixed automatic expansion of \r and \n characters into \r\n for SQL Server target
  • Full Convert 5.7 released
    August 18, 2010
    • Fixed reading of Oracle materialized views
    • Fixed creation of foreign keys in Oracle in cases when source table didn't have needed indexes in place
    • Fixed rare crashes when closing the application
  • Full Convert 5.6 released
    July 22, 2010
    • Added encryption support to SQL Server connection
    • Added non-standard port support to SQL Server connection
    • Added per-project setting for text file header and footer line skip count
    • Improved compatibility with Firebird 1.x
    • Improved task scheduler error reporting. Unsupported option combinations are now clearly explained.
    • Modified GUID translation to Oracle - instead of VARCHAR(38) it is now translated to RAW(16)
    • Fixed bug with Paradox graphic fields
    • Fixed saving of text connection parameters in project
  • Full Convert 5.5 released
    June 1, 2010
    • Added support for XML schema. This allows easy conversion of standard XML datasets.
    • Added support for XML target! You can now easily export from any database to XML datasets.
    • Added 'No data' option to Customize Table dialog.
    • Improved handling of duplicate object names. We now rename target objects before conversion when duplicates are detected to avoid errors. Of course, you can still set proper names yourself in Customize Table dialog.
    • Improved schema handling - added option to recreate all schemas, use schemas as table prefixes, or ignore schema information (default)
    • Turned out that Oracle doesn't allow ROWID column name, even if it is enclosed with double quotes. Forced rename of such identifiers to ROWID_ from now on for Oracle target.
    • Fixed detection of certain Oracle indexes
    • Fixed extra empty row showing up for Excel source documents with header row
    • Fixed dynamic chunk creating in cases where primary key consists of very large integral numbers (>=16 digits)
  • Full Convert 5.4 released
    May 17, 2010
    • Improved ODBC support, removed dependency on ODBC 3.0 compliant drivers
    • Improved support for PostgreSQL 7.x
    • Added ability to use multi-character delimiters for text files
    • Removed trimming of table field names when they have dot in a name
    • Fixed parsing of dBase 3 memo fields
  • Full Convert 5.3 released
    April 16, 2010
    • Enforced index and constraints auto-renaming for Oracle and Postgres target regardless of the Options, as too many users were unaware of the option and got errors for duplicate names
    • Improved support for PostgreSQL
    • Improved support for old Oracle versions (8i)
    • Improved handling of duplicate fields in DBF tables
    • Improved speed of parsing invalid dates in DBF tables
    • Added hard limit to 10 records in SQL Server target extended inserts (SQL Server blocks hard on high batch, unlike MySQL which is very, very fast there)
  • Full Convert 5.24 released
    April 23, 2013
    • Fixed scheduler on Windows server machines
    • Added option to disable use of UNISTR function when inserting data to Oracle
  • Full Convert 5.23 released
    February 22, 2013
    • Fixed ODBC table structure parsing
  • Full Convert 5.21 released
    November 20, 2012
    • PostgreSQL identifiers are now forced to lower case because PostgreSQL does not adhere to SQL standards. This allows customers not to use quotes to reference tables later.
  • Full Convert 5.20 released
    October 18, 2012
    • Numerous bugfixes
  • Full Convert 5.2 released
    January 13, 2010
    • Added automatic creation of a target database for Postgres engine
    • Added support for MySQL servers with ANSI_QUOTES configuration turned on
    • Extended NVARCHAR maximum length in MySQL to 65535 characters
    • Improved representation of connection errors to end user. We now show more user-friendly dialog with a direct link to appropriate online documentation page.
    • Improved conversion speed for all users who use Table Settings. We now turn the fast bulk mode off only if user actually declared SQL expressions to calculate new data on the fly.
    • Improved chunking code to use unique indexes when table doesn't have primary key.
    • Added transfer mode display to the progress dialog. You can now see if bulk mode is used, if table is chunked or not, etc.
    • Added support for old Postgres databases (<7.4), which use old frontend protocol for communication
    • Automatically removing 8-byte image header from Paradox graphic fields
    • Improved parsing of dBase/FoxPro CDX index files (CDX)
    • Improved recognition of ODBC datatypes
    • Changed default connection mode for Oracle to "Direct TCP/IP" from current "Oracle client"
    • Fixed and improved Access table properties changing. Renaming Access tables is now instant.
    • Fixed project customization column case bug where Unchanged case cleared column case
    • Fixed handling of PostgreSQL schemas
    • Fixed conversion of certain datatypes to PostgreSQL
    • Fixed parsing of SQL Server Compact table names which caused them to fail converting.
    • Fixed Paradox long memos handling, where memos were truncated to 20.000 characters
    • Fixed dBase DBT memos reading
    • Fixed translation of MySQL bit default values to SQL Server
    • Fixed memory leaks which become an issue with databases containing over 30k tables
    • Fixed datatype and default values advanced mappings handling
  • Full Convert 5.19 released
    April 30, 2012
    • Completely rewritten ODBC support
    • Support for ODBC as source and for target! This means you can convert basically any popular database into any other.
    • Bug fixes
  • Full Convert 5.18 released
    November 24, 2011
    • Added basic usage tracking to trial version to learn where are the problem areas for first-time users
    • Added auto-create of Interbase/Firebird database if it doesn't exist
    • Fixed reading of MySQL multiple column indexes
    • Fixed Interbase/Firebird minimum timestamp value
    • Fixed delimited text and XML target filename when source is Excel document with multiple sheets
    • Fixed execution of complex custom SQL script for SQL CE
    • Fixed conversion of identifier to valid identifier when it is numeric and contains dots
  • Full Convert 5.17 released
    October 4, 2011
    • SQL Server UID field is now converted to MySQL binary(16) instead of to VARCHAR(38)
    • Fixed various bugs
  • Full Convert 5.16 released
    August 15, 2011
    • Changed delimited text parsing behavior. When 'quotes enclosing' is set to 'strings values', we preserve character data type instead of casting it to numbers when we can.
    • Fixed various bugs
  • Full Convert 5.15 released
    June 16, 2011
    • Replaced crappy XlsReadWriteII Excel components with much more reliable NativeExcel components
    • Auto-detect empty Excel cells and using only used section of the sheet
    • Fixed bug in 'Interpred dates in years 0000-0099 as 1900-1999' option handling
  • Full Convert 5.14 released
    June 13, 2011
    • Fixed nasty bug in table customization where certain settings from last table were remembered and applied to all tables
  • Full Convert 5.13 released
    May 19, 2011
    • Updated our native database components
    • Added warning when obsolete table customization is detected
    • Fixed bug in reordering tables causing errors when using Recreate Data mode
    • Fixed bug which cause Oracle Fast Loader not to be used when table was customized
  • Full Convert 5.12 released
    May 5, 2011
    • Optimized internal data structures for significantly faster handling of databases with many tables
    • Added notification if BULK INSERT is disabled for SQL Server target
    • Fixed Postgres 8.0 metadata reading
  • Full Convert 5.11 released
    March 29, 2011
    • Improved handling of invalid date values for NOT NULL target columns. We will now use minimum allowed value for a specific datatype used
    • Full Convert now migrates comments for tables and columns if target database supports that feature
    • Oracle RAW(x) datatype is now converted to BINARY(x) SQL Server datatype when possible
    • Fixed bulk insert handling of SQL Server target binary data
  • Full Convert 5.10 released
    January 10, 2011
    • Added handling of complex default values (function calls and expressions) to MySQL target. As MySQL doesn't support that, we now create before insert trigger and set those values there.
    • Paradox reader no longer attempts to place a write lock on the files
    • Changed DBF file NULL value parsing - empty numeric values will now be read as NUL
    • Fixed PostgreSQL target blob data writing
    • Fixed Excel target data truncation when source database is read in chunks
    • Fixed XML target data truncation when source database is read in chunks
    • Fixed CSV target header row multiplication on each target chunk when header row writing is turned on
    • Fixed new file generated on each run - small temporary file was not deleted properly
    • Fixed datatype and defaults mapping reloading - you needed to exit the application for new mappings to be recognized. No more.
    • Fixed trial version bug causing 'can't find field' error for certain table fields
    • Fixed NULL default values for Oracle DATE fields
    • Fixed parsing of Oracle constraints when table is in non-default schema
    • Fixed crash when MySQL target user doesn't have SHOW DATABASES privilege
  • Full Convert 5.1 released
    September 1, 2009
    • Much improved ODBC support
    • Added defaults mapping so you can now override your complex default values with proper native target counterparts. Options have been updated so we made a new Mappings section.
    • Added quick help for connecting in the Project Settings
    • Fixed SQL Server IDENTITY_INSERT bug introduced in v5.0
    • Fixed handling of Null value in Paradox TIMESTAMP fields
    • Many bug-fixes throughout the application
  • Full Convert 5.0 released
    July 13, 2009
    • Conversion engine rewritten so that .NET framework is no longer required. This considerably reduces installation size and memory consumption, improves conversion speed and user interface responsiveness.
    • Handling of huge databases is taken to the next level using advanced algorithm for partial data loading. Now memory consumption is low and constant, so you can convert hundreds of GB without touching any options. Converting of huge databases is now very fast as database server isn't burdened with calculating chunk positions so you typically won't even notice that tables are read in chunks during conversion.
    • Added handling of user erroneously opening a database file using Open Project button. Full Convert will now recognize the file type and start a new conversion wizard with the opened file as a source.
    • Added support for Excel 2007 files as a target. For each project, choose whether you want Excel97 or Excel2007 output.
    • Excel doesn't have to be installed as we use native Excel read/write components for maximum speed and reliability.
    • Table Settings dialog now notifies that filter is not available for non-relational source databases
    • Improved handling of TEXT target database. Full Convert now uses very little memory (and a constant amount) as output text is streamed directly to file and we take advantage of our advanced partial data loading algorithm.
    • When you open data in grid, it will now by default be best-fitted for optimal display if table has up to 5.000 records. This behavior can be changed in the Options dialog.
    • SQL Server Compact Edition database maximum size increased to 4GB
    • Added a fast SQL Server detection. It will only detect local SQL Server instances to avoid lag, and Server field will be filled right away with the first instance detected.
    • By default, from now on MySQL target uses database default for table engine (i.e. Full Convert will not specify it). It's still overridable in Options.
    • Added NDBCLUSTER table engine for MySQL target
    • If you specify MySQL database which doesn't exist as a target, Full Convert will ask if you wish it to create it for you automatically.
    • Added support for SQL_VARIANT SQL Server data type. When you convert it to other database engines, we copy it as a BLOB.
    • Added option to generate sqlplus compatible output for Oracle target
    • Added support for multiple double-quotes in CSV text files. For example: "This is ""quoted"" inside a string by specifying each quote twice" now parses properly.
    • Added option to reconnect to both source and target database on each conversion and reread the metadata if you want to make sure you have the latest info.
    • Improved progress dialog. You can now instantly cancel long-running Oracle direct-load transfers. Also, visual clue added when slow parameterized mode is used due to BLOB data in table.
    • Added 'Test Filter' button in Table Settings. Use it to see how many records your custom source table filter selects.
    • Modified Postgres database table parsing so that only the tables in the current schema are visible
    • All Interbase/Firebird user-defined BLOB types are now handled. User-defined types are handled as SUB_TYPE 0.
    • Fixed rare case when MySQL BTREE index caused parser error while analyzing table
    • Fixed handling of MySQL YEAR data type
    • Fixed handling of Postgres BOOLEAN data type
    • Fixed reading of Postgres unique/primary key attributes
    • Fixed case when constraint names were lowercased unintentionally
    • Fixed handling of DBF logical data type ('Y' values were incorrectly tagged as False)
    • Removed differences in default data type mapping in Table Settings compared to default on-the-fly mapping
  • Full Convert 4.6 released
    February 9, 2009
    • Significantly improved conversion speed for Firebird target, around 300% increase
    • Added support for SQL Server Compact Edition, both as a source and as a target
    • Added support for SQL Server 2008 new DATE, TIME and DATETIME2 types
    • Added support for SQL Server 2008 new multi-line SQL insert command
    • Added printing support
    • Added new command-line override. When you specify -override tables_to_process=*, Full Convert will process all tables from the source
    • Added support for character fields larger than 255 characters in DBF engine
    • Added support for SQL Server XML datatype
    • Increased timeout for command execution in most targets to get rid of timeouts for long index creation
    • Improved performance of connecting to SQL Server and listing its tables
    • Improved handling of very large custom user SQL scripts so that scripts sized hundreds of MB use a minimum of RAM
    • Set default write batch records to 200 as this proved optimal for most target databases.
    • We no more convert dates on each SQL insert to Oracle target. We rather change the session NLS_DATE_FORMAT and NLS_TIMESTAMP_FORMAT variables.
    • Auto-creating Access database will now use your default database folder instead of Desktop, if you have specified the folder in the options dialog.
    • Fixed calculating numeric size from DBF source. DBF defines size excluding decimals, while modern databases define it including decimals. These causes occasional numeric overflows during conversion.
    • Fixed trial version issue with SQL Server target where trial watermark can cause string truncation error
    • Fixed handling of tables with percent-sign in the name
    • Fixed handling of table and column names starting with a number for Interbase/Firebird target
    • Fixed case for Oracle target where parameters were not used to insert CLOB data
    • Fixed case for MySQL target where key column names were trimmed to 64 characters alltogether, instead of per-column
    • Fixed conversion from MySQL to MySQL where table engine was enforced with empty string
    • Fixed handing of datetime values where a very small values were incorrectly interpreted as NULL values
  • Full Convert 4.5 released
    January 14, 2009
    • Significantly improved conversion when large BLOB data is used by replacing some string routines with highly optimized code from Ralf Junker, The Delphi Inspiration (http://www.yunqa.de/delphi/)
    • Improved handling of invalid source data containing NULL values in NOT NULL fields
    • Paradox strings are no more right-trimmed by Full Convert
    • Fixed connection lost error on long index creation in MySQL
  • Full Convert 4.4 released
    December 19, 2008
    • Read large table in chunks is now supported in Firebird source (but not Interbase)
    • Added Force columns in primary key NOT NULL option for SQL Server target. This is default behavior, as SQL Server requires all PK columns to be NOT NULL. If your data contains NULL values in columns which are part of PK, you can disable this option to have all data converted.
    • Added automatic handling of certain invalid DBF data when encountered
    • Implemented memory optimizations when unpacking large (hundred MB in size) SQL scripts from file for automated execution before or after conversion
    • Improved datetime detection in Excel document cells
    • Fixed reading of large SQL Server tables in chunks when primary key was nonclustered.
    • Fixed reading of formatted paradox memos for certain versions of Paradox tables
    • Fixed conversion of SQL Server timestamp to Oracle
    • Fixed case when large Paradox memos could corrupt memory buffer
    • Interbase/Firebird client library setting was ignored (gds32.dll/fbclient.dll). Fixed.
  • Full Convert 4.3 released
    October 20, 2008
    • Added multi-select in table selection
    • Multiple-sheet Excel documents are now handled automatically. Each sheet represents a separate table. Empty sheets are ignored.
    • Line break characters inside CSV text documents are now handled correctly in the case when the new line character occurs inside of the quoted string value.
    • You can now open saved project even if an error occurs loading a saved project (for example, when database doesn't exist anymore or server IP changed). Project Settings are opened automatically so you can correct invalid information.
    • Simplified automatic character set conversion. It is now enabled by default and doesn't need a target character set to function, as we support Unicode data.
    • Added custom character set definiton to MySQL options. This is useful, for example, for utf8 data.
    • Added WITH NOCHECK option for primary key creation of SQL Server target
    • Fixed execution of custom long Oracle scripts in Run Before/After Conversion
    • Fixed case where Interbase/Firebird text blob fields were converted as garbage
    • Fixed connecting to SQL Server 2000 and older in SQL Server mode authentication
  • Full Convert 4.2 released
    October 3, 2008
    • Full Convert will no more empty target column definitions in Table Settings when you choose Recreate/Append Data mode. This way you can create project even if you plan to deploy target database structure later.
    • Fixed handling of Oracle parameters where old parameters were not cleared correctly
    • Fixed detection of local/remote server for SQL Server when named instance is specified
    • Fixed writing of Excel files
    • Fixed case when Full Convert ignored 'Create tables' option in the new Customize dialog
    • Fixed ORA-00932: inconsistent datatypes: expected NCLOB got BLOB
    • Fixed a last-minute change causing mixed authentication to fail on SQL Server 2005
    • Fixed a case where same-named tables in different target SQL Server schemas caused internal duplicate index error in Full Convert
  • Full Convert 4.1 released
    September 25, 2008
    • Added support for executing SQL scripts on the source database before and after conversion
    • Added support to consecutively run several files inside of the ZIP archive as external scripts. You can even specify file masks!
    • Project customization expanded and moved to separate dialogue
    • Completely rewritten Excel support. It is now faster, much more reliable and doesn't even require Excel to be installed.
    • We have temporarily disabled MySQL LOAD DATA feature due to bugs in the MySQL implementation regarding Unicode data. As MySQL inserts are very fast anyway, this is not really a burning issue.
    • Auto-refreshing scheduled tasks can now be disabled in the Scheduler
    • dbo Schema in SQL Server source is no more explicitly defined in target to avoid cluttering table names with unnecessary prefixes. Other schemas are copied.
    • Conversion will now drop related foreign keys prior to dropping a table in SQL Server target
    • Fixed handling of text data type for SQL Server 2000
    • Fixed handling of varchar(max), nvarchar(max) and varbinary(max) data types in global override of data types in Options
    • Fixed list colors on WindowsXP
    • Fixed automatic recognition of delimited text files in Project Settings
    • Fixed Unicode writing to Oracle target
    • Clicking Copy/Append/No Data options in project customization page was forcing immediate convert
  • Full Convert 4.0 released
    August 11, 2008
    • Totally new user interface! We used ribbon known from Office 2007 to simplify your workflow and improve the experience.
    • Editions are now discontinued. Users were often confused which Edition they need and demand for lite version of the product was far less than for the Enterprise version.
    • Added Unicode support! Full Convert can now handle all those umlauts, Chinese, Japanese, Hebrew and Arabic letters with ease!
    • Added Excel as a conversion target - you can write a whole bunch of Excel documents (one for each table) or stuff all tables as sheets in a single Excel document
    • Added ability to run custom user SQL scripts before and after each conversion. You can also specify external files (even ZIP files) to be read, unpacked and executed.
    • Added in-place edit feature into the data grid. No more need to go to other tools to modify your converted data.
    • Added datatype mapping on a global level as well and set-up rules used for all conversions.
    • Added improved error reporting. You can now send a bug report from any error message to seek for help - this is great for managing database setup
    • Added tips into error messages. For the common problems Full Convert will suggest actions to resolve the issue.
    • Added display of progress when Full Convert is called via command-line and immediate close switch is not specified
    • Added automatic 'Skip activation' action when trial can't reach our server due to firewall/proxy setup
    • Added schema specification in SQL Server
    • Added automatic creation of index for MySQL target Table Settings when user creates auto_increment column
    • Added direct link to customize the project
    • Added satisfaction survey to the trial version so we can easily be notified of the problems and new features requests.
    • Added notification window when the conversion is finished
    • Improved scheduler
    • Improved progress dialog can now be dragged and is no longer visible on top of other windows
    • Fixed handling of empty varchar(max) SQL Server datatype
    • Fixed handling of double datatype for DBF source tables
    • Fixed reading of disabled options intended for Enterprise in Editions
    • Fixed occasional handling of Oracle clob as blob data
    • Fixed case when Oracle sequence was not created for empty source table
    • Fixed creation of indexes in Access target
    • Fixed 'Unknown datatype' error in Oracle target
    • Fixed Interbase/Firebird WHERE clause handling in Table Settings
    • Fixed conversion of Oracle LONG RAW datatype to SQL Server 2000 target
  • Full Convert 3.3 released
    January 29, 2008
    • Added support for Oracle 11g
    • MySQL target will now automatically convert decimal identity fields to int/bigint, depending on the size
    • Fixed occasional incomplete metadata retrieval
    • Fixed handling of NULL values in fields where target database doesn't support NULLs in specific scenarios
    • Fixed handling of MySQL mediumtext datatype
  • Full Convert 3.2 released
    November 28, 2007
    • Added an option to require user global datatype matching for users who want absolute control over conversion
    • MySQL target now creates only required indexes as a part of create table statement and the rest later
    • Added warning when BULK mode and Table Settings are used so you can know when a table can't use BULK mode
    • Added handling of case when MySQL returns incomplete create table statement to us
    • Fixed global datatype conversion casing sensitivity
    • Fixed handling of 64-bit integer values for Interbase/Firebird target
  • Full Convert 3.1 released
    November 16, 2007
    • Fixed handling of MySQL unsigned datatypes
    • Fixed Paradox tables reading
    • Fixed reopening of Access password protected databases
    • Fixed the WHERE condition in Table Settings which was ignored in v3.0
    • Fixed table name transforming in Session Wizard's Customize section
  • Full Convert 3.0 released
    October 20, 2007
    • Massive data transfer speedup!
    • Added support for MySQL LOAD DATA bulk mode
    • Added support for PostgreSQL COPY bulk mode
    • Improved process of conversion from SQL2005 to SQL2000 or earlier
    • Added warnings to the conversion log
    • Empty tables are now immediately skipped when copying data
    • Added handling of duplicate DBF indexes
    • Added autorename of duplicate DBF fields
    • Added visual clue icon to clear when the table is being open, when Full Convert processes data, and when the target database processes the data
    • Added global datatype conversion override for each target
    • Added preview of delimited text file in Session Wizard for easy selection of delimiter
    • Improved scheduler - tasks can now be repeated (even every minute if needed) for a specific time duration - and force stopped if they run too long
    • Bulk mode temporary files written asynchronously for best performance. We used a very nice class written by Dmitry Streblechenko (dmitrys@asu.edu) in 1997.
    • You can now specify client and server for for the bulk mode temporary files for each target, and override it per session
    • Trial does not expire anymore, to help those who need more time evaluating
    • DBF files are no more locked for writing during conversion
    • Fixed progress bar display (last write batch didn't update the progress bar)
    • Fixed Firebird default value parsing
  • Full Convert suite 2.9 released
    August 17, 2006
    • Added per-session options. You can now choose to convert schema only, append data, skip indexes etc. without setting this up for all tables separately at the Table Setting dialog. Enterprise only.
    • Reading tables in chunks is now off by default in Enterprise. This maximizes speed, and users who convert huge databases can always turn this on to avoid big memory load.
    • Added ability to apply prefix to indexes and constraints, not only to tables. This is handy when loading several copies of the database into the same target database.
    • Added support for BCD datatype in Paradox
    • Added auto-refresh every 3 seconds in the Scheduler task list
    • Improved support for LONG datatype in Oracle
    • Fixed parsing of tables in MySQL. Views were treated as tables, now they are ignored.
    • Fixed Paradox reader, in rare cases table reading was ended prematurely
    • Fixed a situation where SQL Server target in certain rare circumstances mixed blob text/binary attribute
    • Fixed reading of NUMERIC datatype from DBF source. It was converted into DOUBLE, and now is marked as DECIMAL of correct precision as scale.
    • Fixed reading of CURRENCY datatype from the Access source. It was converted into DECIMAL, and now is marked as MONEY.
    • Fixed exception when "override_file" command line parameter was invalidly specified in Enterprise
    • Fixed non-initialized NULL values when using Oracle fast loader
    • Fixed hiding of the Welcome Dialog - the option in question was ignored
  • Full Convert suite 2.8 released
    July 14, 2006
    • Relaxed conditions to be able to take advantage of Oracle fast loader. Now (N)CHARs and (N)VARCHARs can be used as well.
    • Oracle target now (again) uses internal fast loader as default. You can enable standard inserts in Options dialog.
    • Fixed Interbase/Firebird huge tables reading by chunks in Enterprise
    • Fixed Oracle option to change (N)CLOBs to (N)VARCHARs
  • Full Convert suite 2.7 released
    July 4, 2006
    • Extended trial records limit to 50 and set this mode to default
    • Fixed parsing of Full Convert 1.x DBF session files
    • Fixed Table Settings in 'recreating data' mode - original table name was used for truncating, ignoring eventual user-specified name
  • Full Convert suite 2.6 released
    June 25, 2006
    • ODBC support fully rewritten. It is now much faster and very reliable.
    • Changed Table Settings behavior - global name changing options are applied even when user has defined table settings - to allow easy global uppercasing or similar situation
    • Added character set translation in Enterprise to Paradox reader in addition to DBF
    • Added parsing of FoxPro DBC file to allow for long field names
    • In Enterprise version, added ability to override session connection parameters using command line switches or using external file
    • Mapped minus character in table names to underscore character for Oracle target
    • License info now displays whether it is single user, site, or worldwide license
    • MySQL table engine is now by default preserved when converting to MySQL (as a backup for example)
    • Added default username to use when specifying MySQL connections - default is "root"
    • Added ability to overwrite index names during schema parsing. This is useful when you have indexes with same names, target databases mostly do not support that.
    • Added support for Oracle ROWID datatype
    • Added trimming of trailing spaces in the DBF source strings
    • Full Convert now adds size to index column when target database is MySQL and column in question is BLOB. This can happen when source VARCHAR results with target TEXT datatype for example. Size is customizable in Options dialog.
    • Oracle target now uses standard inserts with append hint as default. You can enable internal fast loader in Options dialog.
    • Oracle and Interbase/Firebird target schemas are by default now created as case-insensitive. This overrides name transforms settings in Options, unless it is set to case-sensitive, in which case global options are applied.
    • Saving log files now prompts whether to overwrite if the file already exists
    • Fixed occasional failure to override blanks in not-null fields when Oracle direct loader is used
    • Fixed incorrectly calculated memo length in dBase7 reader
    • Fixed occasional invalid trimming of column names in Oracle constraints
    • Fixed occasional invalid display of accented character in built-in data grid
    • Fixed invalid interpretation of Integer columns as autoinc in DBF reader
  • Full Convert suite 2.5 released
    May 22, 2006
    • Added support for dBase7 format
    • Added ability to deselect incorrectly defined fields in Table Settings
    • Direct loader for Oracle now also handles blanks in not-null fields
    • In Enterprise version, reading of large tables in chunks always fetched 50.000 records at a time. It now uses a value defined in Options.
    • In Enterprise version, added APPEND hint to Oracle loading modes definition
    • DBF tables with more than 255 columns are now supported
    • Fixed occasional incorrect interpretation of SQL Server column nullability property
  • Full Convert suite 2.4 released
    April 25, 2006
    • Advanced table settings added to Session wizard in Enterprise version. Ability to override default conversion parameters on table and column level.
    • Direct Oracle fast loader is now turned on by default. It enables tenfold speedup compared to traditional SQL inserts, but is not used for tables containing blobs.
    • Added support for FoxPro and dBase over OLEDB, for customers who want to connect this way. This has to be turned on in Options.
    • MySQL target is now able to dynamically reorder colums and add index if needed for auto_increment columns to work. Also, only the first auto_increment column will keep this property, all the others will have this property reset because of MySQL's limitation of one autoinc column per table.
    • Added ability to specify default database folder in Options dialog
    • Added check for online updates (latest version)
    • DBF reader now recognizes field nullability, hidden fields and autoinc fields. This has to be enabled in Options.
    • DBF reader now parses CDX files to support translation of indexes
    • Session saving is now enabled in trial
    • Added fix for Oracle's inability to insert empty string in not null field. Oracle inserts NULL instead, so Full Convert now inserts a single space in such cases.
    • Fixed reset of Options on cancelling of Options dialog
    • Fixed handling of MySQL indexes' column length
    • Fixed handling of MySQL fulltext indexes
    • Fixed bug in trial where 5 records test mode was sometimes ignored and test mode was forced to 5 columns mode
  • Full Convert suite 2.3 released
    March 22, 2006
    • Added creation of unique constraints to Interbase/Firebird tables where needed for foreign key recreation
    • Added creation of unique constraints to Oracle tables where needed for foreign key recreation
    • Added support for Oracle timestamp data type
    • Fixed handling of Interbase/Firebird tables containing quotes in their name
    • Fixed handling of Interbase/Firebird BLOB sub types
    • Fixed parsing of MySQL tables containing spaces in their name
    • Fixed reading of Oracle float type precision
  • Full Convert suite 2.2 released
    March 14, 2006
    • Direct Oracle fast loader (huge speed gains) is now available in Enterprise version
    • Enhanced ODBC connection. Username, password and compatibility mode are added.
    • Fixed Memo fields handling of DBF VFP3 tables
    • Fixed datetime fields erroneous handling of DBF tables introduced in our direct DBF reader
    • Fixed connect error on attempt to open password protected Access database
  • Full Convert suite 2.19 released
    September 26, 2007
    • Added ability to directly type in the name of PostgreSQL and SQL Server databases in the Session Wizard
    • Fixed Interbase/Firebird blob sub_type handling
    • Fixed PostgreSQL login bug
    • Fixed PostgreSQL blob writing bug
    • Fixed Access password handling
  • Full Convert suite 2.18 released
    August 31, 2007
    • Fixed MySQL tinyint interpretation as bool
    • Fixed Lotus1-2-3 handling
    • Fixed Interbase/Firebird index creation
    • Fixed reading tables in chunks
  • Full Convert suite 2.17 released
    August 14, 2007
    • Added ability to directly type in the name of MySQL database in the Session Wizard, for users who can't connect with a blank database to get a list of available ones
    • Fixed missing PostgreSQL access DLLs. We have added missing DLLs to our release
    • Fixed 'Data copying for existing tables' error for new projects
  • Full Convert suite 2.16 released
    July 7, 2007
    • Added support for PostgreSQL as both source and target (Enterprise required for the target)
    • Added filter in Table Settings. You can now specify the "WHERE clause" to filter out the source data for any table. This is only supported for relational source databases.
    • Speed up of MySQL connection time by not using slow information_schema to read metadata
    • Added advanced options to the Session Wizard (Enterprise only): Select tables with different size, Data copying for existing tables, Clear All Table Settings
    • Added an option to auto-save error log
    • Changed trial mode. No more records/column limitation, now we simply stamp the data with ***TRIALMODE*** every few records
    • Improved compatibility with SQL Server 6.5
    • TEXT datatype is now by default converted to VARCHAR(MAX) if SQL2005 is used as a target
    • BLOBs are now by default converted to VARCHAR(MAX) if size is larger than 8000 characters and SQL2005 is used as a target
    • Added support for 'USING BTREE' clause in MySQL index definition
    • Full Convert won't automatically rename identifiers which are reserved words in target database anymore. There is an option to turn this behavior on.
    • Scientific number notation is not used anymore for SQL Server target because SQL2005 no longer supports it in BULK INSERT by default
    • Oracle sequence and trigger names are now trimmed to 30 characters
    • Fixed connection issue when SQL Server is running on a different port than default
    • Fixed the problem where Access and SQL Server data only preserved 4 digits behind decimal point
    • Fixed occasional errors with BULK INSERT of BLOB and DATETIME data on SQL Server target
    • Fixed the handling of case when Interbase doesn't fill-in certain metadata values
    • Fixed parsing of Access indexes
  • Full Convert suite 2.15 released
    April 23, 2007
    • Added support for Oracle sequences and corresponding triggers to Enterprise
    • Added support for Interbase/Firebird DEFAULT values
    • Added support for different type of quoting in delimited text files
    • Added compatible mode for connection to SQL Server 6.5 and earlier
    • Oracle parser will now skip over SDO_GEOMETRY fields
    • Enforced Oracle date format to a fixed format to avoid problems with varying configurations
    • Removed single quote as a string delimiter in delimited text parser. Now only double quotes delimit strings, which helps to parse files where strings are not enclosed with quotes, yet contain single quotes.
    • Fixed escaping of double quote in a MySQL target. It isn't quoted anymore.
    • Fixed issues with defaults and SQL Server VARCHAR(MAX) columns
    • Fixed Session Wizard appearance on large-fonts displays
    • Fixed certain cases where Oracle target could miss a constraint
  • Full Convert suite 2.14 released
    March 12, 2007
    • Added support for BINARY, VARBINARY types in MySQL
    • Added support for VARCHAR(MAX), NVARCHAR(MAX), VARBINARY(MAX) in SQL Server
    • Added Text as target engine to Enterprise for easy conversion of source database to delimited text
    • Added auto-translation of character set to Enterprise (from dBase, FoxPro and Paradox sources)
    • Added graceful fallback to DML in Oracle target when Direct mode is used
    • Added ability to resize Session Wizard, handy when you have large table names
    • Added graceful bypass of handling of mysql.proc in case that user doesn't have proper SELECT privileges for MySQL connections
    • Added detection of installed OLEDB providers. SQL Server connection now automatically uses SQLNCLI instead of SQLOLEDB if available.
    • Added detection of maximum allowed packet size for MySQL target, so Full Convert will take advantage of increased packet size if available
    • Added selection of protocol for Interbase/Firebird connection
    • The dialog is shown to user to use 'Read large tables in chunks' when OutOfMemory exception is encountered
    • Removed legacy database connections (dBase and FoxPro over OLEDB) as they are superseded by a direct reader 'dBase and FoxPro (DBF)'
    • Removed MySQLscript engine from the source engine list as it ended there by mistake
    • SQL Server statistics are no more being interpreted as indexes for a table
    • Fixed the Table Settings - when Append Data was selected, the option was not remembered
  • Full Convert suite 2.13 released
    February 16, 2007
    • Added support for Access 2007
    • Added quick-select of local SQLExpress
    • Added "quiet" command-line switch which hides the application window
    • Added ability to override Interbase/Firebird library from default GDS32.DLL
    • Improved Interbase/Firebird structure reading. Option to read full Interbase/Firebird schema at once has been removed.
    • Fixed TXT import where character "\r" was left at the end of the last field in line
    • Fixed DBF memo reading in certain versions of DBF
  • Full Convert suite 2.12 released
    November 24, 2006
    • Added optional parsing of SQL Server views as if they were tables. Enterprise only.
    • Added default SYSDBA/masterkey username/password for the Interbase/Firebird connection
    • Added recognition whether Interbase or Firebird is used and graceful override of functionality unsupported in Interbase. For example, read large table in chunks in supported in Firebird, but not in Interbase.
    • Added workaround for Interbase/Firebird bug where server does not support direct reference of columns named as reserved words.
    • Added option to skip primary key creation for Oracle target
    • Changed code signing to Verisign instead of Thawte in preparation for "Certified for Windows Vista" logo program when Windows Vista is released
    • Fixed unsupported CLOB syntax in Oracle versions less than 10
  • Full Convert suite 2.11 released
    October 10, 2006
    • Rewritten delimited text file handling. It is now not cached anymore, resulting in great memory consumption saving. Full Convert now handles text files of hundreds of GB of size easily.
    • Added option to skip prefix and suffix lines in the delimited text file. This allows to bypass header comment and summary info, for example.
    • Added reports of the source and target tables with their record counts (Enterprise only)
    • Greatly speeded up Oracle and SQL Server standard SQL inserts. You can tweak Options (Insert data in batches) and vary number of records inserted per batch to maximize throughput on your machine.
    • Added auto select in Session Wizard. Enterprise only.
    • Added recognition of all reserved words in target databases. If a table or column name is a reserved word, an underscore character will be appended in the generated target name.
    • Added optional parsing of Oracle views as if they were tables. Enterprise only.
    • Fixed data throughput calculation not to include opening of the table, only data copying
    • Removed dependency of the generated DATETIME SQL string on the system regional settings
    • Fixed handling of tables with quotes in the name in the Table Settings
    • Fixed built-in optional conversion of LONG to VARCHAR/CLOB in Oracle 8
    • Fixed occasional trimming of last character in the last DBF table field
    • Fixed detection of deleted DBF records
    • Fixed Oracle fast loader inability to find table when preserve table and column case is selected in Options
  • Full Convert suite 2.10 released
    September 1, 2006
    • Added support for Views in ODBC. Enterprise only.
    • Force close of the application during conversion is now properly handled and this event is logged in the error log
    • Fixed interpretation of Oracle DATE datatype as DATETIME in the other database engines
  • Full Convert suite 2.1 released
    February 9, 2006
    • Added character set conversion in Enterprise version (experimental, available only for DBF source for now)
    • Further speedup of SQL Server bulk insert mode
    • Speedup of dropping tables in SQL Server and Access targets
    • Multiple identity columns in source are now detected and modified so that only first one stays identity (for targets that do not support multiple identity columns per table)
    • Fixed case changing behavior in table and column name modifier to support characters with accents
    • Integer types in Oracle target are now converted to NUMBER type (not FLOAT anymore). NUMBER has precision set according to size of Integer type.
    • *.fcs (Full Convert session) files are now associated with Full Convert on install
    • Fixed case where invalid date in DBF record caused entire record to be rejected
    • Fixed Access relationship parsing error where differently named local and related columns were swapped
    • Fixed behavior when scheduled to run as System account
    • Fixed handling of Oracle CLOB columns
    • Fixed display of Oracle database in tree list to be user@service, not user@server
    • Now using quotes in Oracle target only where needed
  • Full Convert suite 2.0 released
    January 16, 2006
    • Total user interface redesign
    • Overall conversion speed improvements
    • Added welcome dialog to speed up common tasks
    • Added built-in scheduler to enable fully automatic conversions
    • Improvement of Paradox source handling (increased speed, startup time of table data reading reduced to zero, minimal and constant memory consumption even for huge tables)
    • Merged Paradox and FoxPro engine to minimize confusion of users as both engines use DBF files
    • Added interception of NULL values in Interbase/Firebird primary key columns, as primary key columns can only be NOT NULL. Default values are inserted to avoid Interbase/Firebird exceptions.
    • Best fit for data displayed in grid can now be limited for small tables only (configurable in Options)
    • Options improved
    • Improved logging speed of field validations errors (such as invalid dates)
    • Improved update of progress dialog for tables with huge blobs where database can handle only a few records per second
    • Improved Oracle target speed when table doesn't contain BLOBs
    • Delimited text file no more requires character columns to be enclosed in quotes. VARCHAR is now default field type, used when no other type passes validation rules.
    • SQL sent to database is flushed before it reaches 1MB in size to avoid problem with typical setup of MySQL and BLOBs.
    • Installation files are now signed
    • Fixed dropping of Access tables (dependant foreign key constraints were not dropped correctly)
    • Fixed detection of Access autoincrement columns
    • Fixed detection of Access referential integrity rules (on update/on delete)
    • Fixed a bug where Oracle FLOAT data type used digit instead of binary precision, resulting in less precision than desired
    • Fixed detection of Interbase/Firebird primary keys
  • Full Convert 1.9 released (Interbase/Firebird Edition introduced)
    August 30, 2005
    • Interbase/Firebird Edition introduced!
    • Added XML support
    • Separated conversion into 4 stages (create tables, transfer data, create indexes, apply constraints), so that data is always transferred, even if it does not conform correctly to unique indexes and constraint rules
    • All targets now save referential integrity constraints
    • Added support for ON DELETE and ON UPDATE rules
    • Added error return code so scheduled conversion can trap errors
    • Interbase/Firebird now handles both SQL Dialects 1 and 3
    • Improved compatibility with Oracle 8.x (which does not support multi-byte characters)
    • Improved conversion of default values
    • You can now select tables of any user in Session Wizard for Oracle source
    • Improved Oracle connection dialog so server and port can more easily be defined
    • Improved responsiveness of Cancel button in progress dialog
    • License keys should now work also with most exotic characters in our customers' names :)
    • SQL Log no longer takes up memory during conversion
    • Fixed case where some Excel sheets were not displayed as tables
    • Removed delay on typing SQL Server connection server name (network was polled for existing SQL Servers too often)
    • Improved detection of invalid data in source database
    • Removed 'Professional' and 'Standard' versions as such. 'Standard' versions are no more supported, and 'Professional' are simply Editions.
  • Full Convert 1.8 released
    June 13, 2005
    • Fixed Interbase/Firebird error with mixed-case table names
    • Performance much improved in SQL Server target
    • Improved progress dialog
    • Fixed cancelling in memory optimized mode
    • Added Oracle target option: Long text columns are now by default converted to VARCHAR(4000), because Oracle limits table structure to have only one LONG column per table
    • Added detection of multiple same columns defined in index
    • Fixed incorrect detection of Excel print areas as sheets
  • Full Convert 1.7 released
    May 5, 2005
    • Added memory optimized mode for huge tables (tens of millions of records) to Enterprise version. This mode slows down conversion a bit, but uses small memory footprint. Supported source databases:
    • MySQL
    • FoxPro
    • Oracle
    • Access (must have primary key defined to take advantage of this feature)
    • SQL Server (must have primary key defined to take advantage of this feature)
    • Fixed MySQL partial index recognition
  • Full Convert 1.6 released (Access Edition introduced)
    March 27, 2005
    • Fixed invalid handling of SQL Server timestamp column
    • Fixed conversion of strings containing ASCII value of zero characters. They are now replaced with spaces allowing SQL to be executed properly.
    • Fixed occasional Interbase/Firebird server list error
    • Fixed truncating of decimal values to 2 decimal places
    • Fixed unicode column types detection in databases not supporting unicode
    • Fixed numerous Access target bugs
    • Fixed ignoring of MySQL table type option - InnoDB was always used.
    • Access Edition introduced!
    • Added ability to supress invalid field value errors to speed up conversion when there are many
    • Added ability to force Unicode or Non-Unicode columns to target database
    • Fixed Oracle blob and clob columns reading
    • Fixed incorrect setting of Paradox 00:00 time values to NULL
    • Fixed occasional wrong conversion of decimal datatype as integer from Interbase source
  • Full Convert 1.5 released
    March 8, 2005
    • Fixed long varchar columns converting to MySQL
    • Fixed Oracle multiple-columns foreign keys handling
    • Fixed SQL Server foreign keys handling
    • Fixed Browse For Folder dialog incompatibility with certain systems
    • Improved Lotus 1-2-3 handling
    • Fixed invalid numbers handling in Paradox
    • Fixed NCHAR2, NVARCHAR2 and FLOAT handling in Oracle
    • Fixed incorrect multibyte character column length detection in Oracle
    • Changed folder browser behavior to automatically position to current folder
  • Full Convert 1.4 released
    February 11, 2005
    • Oracle Edition introduced!
    • Paradox primary keys are now created in target database
    • Conversion process is now cancellable
    • Added command-line support for easy batch/scheduling
    • Added Export to text in Enterprise version
    • Added option to ignore default values. Usable for situations when default value is incompatible with target database
    • Edit SQL dialog is now color-coded
    • Fixed certain cases invalid Paradox blob field handling
    • Fixed incompatibility with Oracle 8
    • Fixed occasional incorrect Interbase/Firebird character column length detection
    • Fixed MySQL 4.1 authorization problems
    • User interface is improved
    • Direct connection to Oracle supported. Oracle Client software is not required anymore.
    • Added ability to drop recycle bin objects in Oracle database
    • Trial version is not row-limited anymore. This will provide good insight in conversion speed for user's specific installation.
    • Fixed Batch insert problem for Oracle target database. (Invalid character error)
    • Numerous smaller Oracle incompatibilities fixed
  • Full Convert 1.3 released
    January 16, 2005
    • Added ODBC sources support
    • Added option to log all SQL commands during conversion in Enterprise version - SQL is displayed syntax colored
    • Added option to convert non-scaled decimals (numerics) to integers
    • Added conversion summary dialog
    • Added ability to go to specific record in table using Ctrl+G or using context menu on table data grid
    • Changed options behavior for changing case in Options - now tables and columns can have separate settings
    • Split logs to summary, error log and SQL log. Each can be saved separately. (SQL log is available in Enterprise version only)
    • Added exact reporting for invalid fields - this, combined with 'Go to record', enables you to easily find invalid data
    • Fetching record count for Paradox tables is now almost instant
    • Fixed incorrect timestamp handling for Paradox tables
    • Fixed incorrect null reporting for Paradox boolean fields
    • Fixed incorrect date handling for FoxPro tables
    • Fixed multiple tables drop
    • Fixed index creation failure in trial version when trying to create index of column skipped in trial
    • Fixed handling of tables with parentheses in name
    • Fixed incorrect parsing of table structure on case sensitive SQL Servers
  • Full Convert 1.2 released
    December 2, 2004
    • Initial SQL Server Edition release
    • Initial Enterprise version release
    • Full support for MySQL 4.1
    • Added FoxPro support
    • Session wizard allows examining record counts of source data before importing (Professional, Enterprise)
    • Session wizard allows skipping of empty source tables (Professional, Enterprise)
    • Oracle dialog now supports authentication mode selection and lists available services
    • Added Options dialog
    • Added option to prepend prefix to target table
    • Added option to change case of tables and columns
    • Added option to display optimal column width in data grid
    • Added option to always display tables' record count
    • Added option to select target table type in MySQL
    • Added option to select number of records inserted per commit in MySQL
    • Rewritten handling of Paradox files for much better speed and accuracy
    • Rewritten handling of delimited text files for much better speed and accuracy
    • Added ability to view long text in grid cells
    • Fixed importing of indexes from SQL Server database
    • Indexes are now imported from Access databases
    • Increased number of allowed columns in trial from 3 to 5
  • Full Convert 1.1 released
    October 7, 2004
    • Improved session wizard
    • Improved handling of Paradox files
    • Fixed width text files supported
    • Added passwords and system database support to Access connection
  • Full Convert - initial release
    October 1, 2004
  • Full Convert online help is now available.
    February 11, 2005
  • New Full Convert online tutorials are now available.
    March 15, 2005