Softpedia >Windows >Internet >Servers >Database Utils >Full Convert Enterprise >  Changelog

Full Convert Enterprise Changelog

What's new in Full Convert Enterprise 21.12 Build 1661

Jan 4, 2022
  • 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

New in Full Convert Enterprise 21.08 Build 1657 (Sep 8, 2021)

  • Fixed a starting screen problem when onboarding option was turned on

New in Full Convert Enterprise 21.08 Build 1656 (Aug 31, 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

New in Full Convert Enterprise 21.08 Build 1654 (Aug 13, 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

New in Full Convert Enterprise 21.08 Build 1653 (Aug 5, 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

New in Full Convert Enterprise 21.07 Build 1652 (Aug 1, 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

New in Full Convert Enterprise 21.07 Build 1651 (Jul 30, 2021)

  • Wizard - added a new nbarding screen after wizard review page
  • Metadata fetch - added prgress indicatin fr databases where we can't fetch all metadata at nce
  • Databases - remved supprt fr Derby, H2 and HyperSQL due t bslescence f [IKVM.NET](http://ikvm.NET) library
  • Access - added a prmpt fr in-place driver dwnlad and install
  • CSV - fixed the missing clumns prblem when CSV is surce
  • Excel - fixed prcessing f files with multiple sheets
  • Gupta SQLBase - fixed missing passwrd errr

New in Full Convert Enterprise 21.07 Build 1650 (Jul 23, 2021)

  • Trial - fied a problem making the trial conversions slower (up to 50 slower) then the full version
  • Trial - fied a Foreign Key error that sometimes happened with watermarked columns
  • Console - fied email notification not sending the summary log
  • Replication - fied column mappings on specific databases
  • Summary log - added calling arguments to the log
  • FileMaker - fied missing columns

New in Full Convert Enterprise 21.07 Build 1649 (Jul 16, 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

New in Full Convert Enterprise 21.07 Build 1648 (Jul 7, 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)

New in Full Convert Enterprise 21.07 Build 1647 (Jul 3, 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

New in Full Convert Enterprise 21.06 Build 1646 (Jul 2, 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

New in Full Convert Enterprise 21.04 Build 1644 (Apr 21, 2021)

  • Fixed a MySQL query when when tables need to be escaped

New in Full Convert Enterprise 21.04 Build 1643 (Apr 16, 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

New in Full Convert Enterprise 21.04 Build 1642 (Apr 9, 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

New in Full Convert Enterprise 21.03 Build 1641 (Apr 3, 2021)

  • Fix table schema mappig

New in Full Convert Enterprise 21.03 Build 1637 (Mar 19, 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

New in Full Convert Enterprise 21.03 Build 1636 (Mar 7, 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

New in Full Convert Enterprise 21.02 Build 1635 (Feb 13, 2021)

  • Log - handle locked files (creates a new file with a datetime as a suffi)
  • Access - fied some data errors with NULL and empty strings and money
  • Ecel - when target, rows now spill into new files instead of throwing an error
  • MySQL - char and nchar columns over 255 precision now map to TET columns
  • MySQL - removed created not needed temporary indees
  • PostgreSQL - FI OVERRIDING SYSTEM VALUE error on insert on older versions
  • Redshift - various fies and improvements
  • SqlServer - fi decimal overflow error when more than 28 digits present (truncate)

New in Full Convert Enterprise 21.01 Build 1633 (Jan 14, 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 "="

New in Full Convert Enterprise 20.12 Build 1632 (Dec 14, 2020)

  • Fix settings page not going back

New in Full Convert Enterprise 20.12 Build 1631 (Dec 10, 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

New in Full Convert Enterprise 20.10 Build 1629 (Oct 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

New in Full Convert Enterprise 20.10 Build 1628 (Oct 2, 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

New in Full Convert Enterprise 20.09 Build 1626 (Sep 16, 2020)

  • Table creation in certain databases fixed

New in Full Convert Enterprise 20.08 Build 1624 (Aug 28, 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

New in Full Convert Enterprise 20.08 Build 1623 (Aug 27, 2020)

  • PostgreSQL - fix target crash

New in Full Convert Enterprise 20.08 Build 1622 (Aug 26, 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

New in Full Convert Enterprise 20.08 Build 1621 (Aug 21, 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

New in Full Convert Enterprise 18.07 Build 1468 (Jul 18, 2018)

  • Applied target casing for index column names to fix index creation issues in certain project configurations

New in Full Convert Enterprise 17.10 Build 1327 (Oct 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

New in Full Convert Enterprise 7.17 Build 1256 (Jul 31, 2017)

  • Rewritten and simplified schema mapping

New in Full Convert Enterprise 7.17 Build 1236 (Jul 21, 2017)

  • Intuit QuickBooks supported for reading via its QODBC driver

New in Full Convert Enterprise 7.16 Build 1229 (Jul 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

New in Full Convert Enterprise 7.15 Build 1225 (Jul 11, 2017)

  • JSON log with rich information added
  • Improved handling of unexpected application crashes

New in Full Convert Enterprise 7.14.1218 (Jun 13, 2017)

  • Added character set specification for CSV files
  • Improved PostgreSQL sequence creation - all valid datatypes can now be incrementing

New in Full Convert Enterprise 7.13.1191 (May 4, 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

New in Full Convert Enterprise 7.12.1141 (Mar 11, 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

New in Full Convert Enterprise 7.10.1084 (Jan 24, 2017)

  • Added ability to read views for MySQL, Interbase and Firebird source databases

New in Full Convert Enterprise 7.9.1072 (Jan 6, 2017)

  • 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

New in Full Convert Enterprise 7.8.1014 (Sep 22, 2016)

  • Added full support for SQL Express LocalDB

New in Full Convert Enterprise 7.7.993 (Aug 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

New in Full Convert Enterprise 7.6.958 (Jul 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 atatype
  • Respect SQL Server compatibility setting

New in Full Convert Enterprise 7.5.905 (Apr 27, 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

New in Full Convert Enterprise 7.4.885 (Apr 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

New in Full Convert Enterprise 7.3.857 (Mar 8, 2016)

  • Added custom WHERE clause
  • Added troubleshooting option to never disconnect (some ODBC drivers crash on disconnect)

New in Full Convert Enterprise 7.2.812 (Feb 16, 2016)

  • Improved and clarified progress screen
  • Added option to display data loading progress in circular chart
  • Bugfixes

New in Full Convert Enterprise 7.1.804 (Feb 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
  • Complete rewrite in a new technology!
  • All application areas have been greatly improved.
  • Significant performance boost.
  • Added support for following databases:
  • IBM DB2
  • Derby
  • HSQLDB
  • NexusDB
  • Pervasive PSQL
  • Progress OpenEdge
  • Sybase Adaptive Server Enterprise
  • Sybase SQL Anywhere
  • VistaDB

New in Full Convert Enterprise 6.11.1683 (Apr 17, 2015)

  • Computed columns are now skipped when copying into existing tables

New in Full Convert Enterprise 6.10 (Apr 17, 2015)

  • Added support for PostgreSQL TSVECTOR datatype

New in Full Convert Enterprise 6.9 (Apr 17, 2015)

  • Added support for PostgreSQL OID datatype

New in Full Convert Enterprise 6.8 (Apr 17, 2015)

  • Fixed a nasty SQLCE bug where opening a database could cause it to be truncated
  • Improvements in SQLite default values handling
  • Bugfixes

New in Full Convert Enterprise 6.7 (Apr 17, 2015)

  • Added ODBC dialect
  • Bugfixes

New in Full Convert Enterprise 6.6 (Apr 17, 2015)

  • 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

New in Full Convert Enterprise 6.5.1611 (May 6, 2014)

  • Respecting Firebird and Interbase maximum identifier length of 31 characters, making sure target identifiers are never duplicated
  • Updated database components
  • Bugfixes

New in Full Convert Enterprise 6.4.1600 (Mar 1, 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

New in Full Convert Enterprise 6.3.1582 (Feb 11, 2014)

  • Separate log for SQL that caused errors
  • Bugfixes

New in Full Convert Enterprise 6.2 (Oct 29, 2013)

  • Separate console application with much improved capabilities
  • Bugfixes

New in Full Convert Enterprise 6.1 (Oct 29, 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

New in Full Convert Enterprise 6.0 (Oct 3, 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

New in Full Convert Enterprise 5.24 (May 2, 2013)

  • Fixed scheduler on Windows server machines
  • Added option to disable use of UNISTR function when inserting data to Oracle

New in Full Convert Enterprise 5.23 (Feb 23, 2013)

  • Fixed ODBC table structure parsing

New in Full Convert Enterprise 5.21 (Nov 22, 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.

New in Full Convert Enterprise 5.20 (Oct 22, 2012)

  • Numerous bugfixes.

New in Full Convert Enterprise 5.19 (Oct 22, 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

New in Full Convert Enterprise 5.18 (Oct 22, 2012)

  • 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

New in Full Convert Enterprise 5.17 (Oct 22, 2012)

  • SQL Server UID field is now converted to MySQL binary(16) instead of to VARCHAR(38)
  • Fixed various bugs

New in Full Convert Enterprise 5.16 (Oct 22, 2012)

  • 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

New in Full Convert Enterprise 5.15 (Oct 22, 2012)

  • 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

New in Full Convert Enterprise 5.8 (Nov 10, 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

New in Full Convert Enterprise 5.7 (Nov 10, 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

New in Full Convert Enterprise 5.6 (Nov 10, 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

New in Full Convert Enterprise 5.5 (Nov 10, 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)

New in Full Convert Enterprise 5.4 (Nov 10, 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

New in Full Convert Enterprise 5.3 (Nov 10, 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)

New in Full Convert Enterprise 5.2 (Nov 10, 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 (

New in Full Convert Enterprise 5.1 (Nov 10, 2010)

  • 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

New in Full Convert Enterprise 5.0 (Jul 17, 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

New in Full Convert Enterprise 4.6 (May 15, 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

New in Full Convert Enterprise 4.5 (May 15, 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

New in Full Convert Enterprise 4.4 (May 15, 2009)

  • 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.

New in Full Convert Enterprise 4.3 (May 15, 2009)

  • 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

New in Full Convert Enterprise 4.2 (May 15, 2009)

  • 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

New in Full Convert Enterprise 4.1 (May 15, 2009)

  • 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

New in Full Convert Enterprise 4.0 (May 15, 2009)

  • 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

New in Full Convert Enterprise 3.3 (May 15, 2009)

  • 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

New in Full Convert Enterprise 3.2 (Nov 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

New in Full Convert Enterprise 2.16 (Jul 24, 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

New in Full Convert Enterprise 2.9 (Aug 21, 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

New in Full Convert Enterprise 2.8 (Jul 17, 2006)

  • Fixed Interbase/Firebird huge tables reading by chunks in Enterprise
  • Fixed Oracle option to change (N)CLOBs to (N)VARCHARs
  • 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.

New in Full Convert Enterprise 2.5 (Jun 8, 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

New in Full Convert Enterprise 2.3 (Mar 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