Version history

April 23, 2013
Full Convert 5.24 released

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

February 22, 2013
Full Convert 5.23 released

1. Fixed ODBC table structure parsing

November 20, 2012
Full Convert 5.21 released

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

October 18, 2012
Full Convert 5.20 released

1. Numerous bugfixes

April 30, 2012
Full Convert 5.19 released

1. Completely rewritten ODBC support
2. Support for ODBC as source and for target! This means you can convert basically any popular database into any other.
3. Bug fixes

November 24, 2011
Full Convert 5.18 released

1. Added basic usage tracking to trial version to learn where are the problem areas for first-time users
2. Added auto-create of Interbase/Firebird database if it doesn't exist
3. Fixed reading of MySQL multiple column indexes
4. Fixed Interbase/Firebird minimum timestamp value
5. Fixed delimited text and XML target filename when source is Excel document with multiple sheets
6. Fixed execution of complex custom SQL script for SQL CE
7. Fixed conversion of identifier to valid identifier when it is numeric and contains dots

October 04, 2011
Full Convert 5.17 released

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

August 15, 2011
Full Convert 5.16 released

1. 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.
2. Fixed various bugs

June 16, 2011
Full Convert 5.15 released

1. Replaced crappy XlsReadWriteII Excel components with much more reliable NativeExcel components
2. Auto-detect empty Excel cells and using only used section of the sheet
3. Fixed bug in 'Interpred dates in years 0000-0099 as 1900-1999' option handling

June 13, 2011
Full Convert 5.14 released

1. Fixed nasty bug in table customization where certain settings from last table were remembered and applied to all tables

May 19, 2011
Full Convert 5.13 released

1. Updated our native database components
2. Added warning when obsolete table customization is detected
3. Fixed bug in reordering tables causing errors when using Recreate Data mode
4. Fixed bug which cause Oracle Fast Loader not to be used when table was customized

May 05, 2011
Full Convert 5.12 released

1. Optimized internal data structures for significantly faster handling of databases with many tables
2. Added notification if BULK INSERT is disabled for SQL Server target
3. Fixed Postgres 8.0 metadata reading

March 29, 2011
Full Convert 5.11 released

1. Improved handling of invalid date values for NOT NULL target columns. We will now use minimum allowed value for a specific datatype used
2. Full Convert now migrates comments for tables and columns if target database supports that feature
3. Oracle RAW(x) datatype is now converted to BINARY(x) SQL Server datatype when possible
4. Fixed bulk insert handling of SQL Server target binary data

January 10, 2011
Full Convert 5.10 released

1. 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.
2. Paradox reader no longer attempts to place a write lock on the files
3. Changed DBF file NULL value parsing - empty numeric values will now be read as NUL
4. Fixed PostgreSQL target blob data writing
5. Fixed Excel target data truncation when source database is read in chunks
6. Fixed XML target data truncation when source database is read in chunks
7. Fixed CSV target header row multiplication on each target chunk when header row writing is turned on
8. Fixed new file generated on each run - small temporary file was not deleted properly
9. Fixed datatype and defaults mapping reloading - you needed to exit the application for new mappings to be recognized. No more.
10. Fixed trial version bug causing 'can't find field' error for certain table fields
11. Fixed NULL default values for Oracle DATE fields
12. Fixed parsing of Oracle constraints when table is in non-default schema
13. Fixed crash when MySQL target user doesn't have SHOW DATABASES privilege

November 11, 2010
Full Convert 5.9 released

1. 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.
2. Added fast chunking support to PostgreSQL source
3. Changed GUID conversion to MySQL to have { and } enclosing characters removed
4. 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.
5. In trial version we won't try to show nag window when quiet mode is used (in scheduled run)
6. Fixed conversion of Oracle LONG values to SQL Server varbinary(max) - used with SQL2005+
7. Fixed conversion of SQL Server defaults containing Unicode strings
8. Fixed an error when resolving dependencies from tables not included in the conversion

September 23, 2010
Full Convert 5.8 released

1. Added support for Excel cells containing very large text blocks
2. Added support for creating new Access 2007-2010 databases
3. Added a progress dialog when refreshing target database, as with large databases it takes some time
4. Fixed datetime default value translation for Interbase/Firebird target
5. Fixed showing of created XLSX documents for target databases
6. Fixed showing of created XML documents for target databases when table is not expanded in database tree
7. Fixed automatic expansion of \r and \n characters into \r\n for SQL Server target

August 18, 2010
Full Convert 5.7 released

1. Fixed reading of Oracle materialized views
2. Fixed creation of foreign keys in Oracle in cases when source table didn't have needed indexes in place
3. Fixed rare crashes when closing the application

July 22, 2010
Full Convert 5.6 released

1. Added encryption support to SQL Server connection
2. Added non-standard port support to SQL Server connection
3. Added per-project setting for text file header and footer line skip count
4. Improved compatibility with Firebird 1.x
5. Improved task scheduler error reporting. Unsupported option combinations are now clearly explained.
6. Modified GUID translation to Oracle - instead of VARCHAR(38) it is now translated to RAW(16)
7. Fixed bug with Paradox graphic fields
8. Fixed saving of text connection parameters in project

June 01, 2010
Full Convert 5.5 released

1. Added support for XML schema. This allows easy conversion of standard XML datasets.
2. Added support for XML target! You can now easily export from any database to XML datasets.
3. Added 'No data' option to Customize Table dialog.
4. 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.
5. Improved schema handling - added option to recreate all schemas, use schemas as table prefixes, or ignore schema information (default)
6. 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.
7. Fixed detection of certain Oracle indexes
8. Fixed extra empty row showing up for Excel source documents with header row
9. Fixed dynamic chunk creating in cases where primary key consists of very large integral numbers (>=16 digits)

May 17, 2010
Full Convert 5.4 released

1. Improved ODBC support, removed dependency on ODBC 3.0 compliant drivers
2. Improved support for PostgreSQL 7.x
3. Added ability to use multi-character delimiters for text files
4. Removed trimming of table field names when they have dot in a name
5. Fixed parsing of dBase 3 memo fields

April 16, 2010
Full Convert 5.3 released

1. 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
2. Improved support for PostgreSQL
3. Improved support for old Oracle versions (8i)
4. Improved handling of duplicate fields in DBF tables
5. Improved speed of parsing invalid dates in DBF tables
6. 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)

January 13, 2010
Full Convert 5.2 released

1. Added automatic creation of a target database for Postgres engine
2. Added support for MySQL servers with ANSI_QUOTES configuration turned on
3. Extended NVARCHAR maximum length in MySQL to 65535 characters
4. Improved representation of connection errors to end user. We now show more user-friendly dialog with a direct link to appropriate online documentation page.
5. 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.
6. Improved chunking code to use unique indexes when table doesn't have primary key.
7. Added transfer mode display to the progress dialog. You can now see if bulk mode is used, if table is chunked or not, etc.
8. Added support for old Postgres databases (<7.4), which use old frontend protocol for communication
9. Automatically removing 8-byte image header from Paradox graphic fields
10. Improved parsing of dBase/FoxPro CDX index files (CDX)
11. Improved recognition of ODBC datatypes
12. Changed default connection mode for Oracle to "Direct TCP/IP" from current "Oracle client"
13. Fixed and improved Access table properties changing. Renaming Access tables is now instant.
14. Fixed project customization column case bug where Unchanged case cleared column case
15. Fixed handling of PostgreSQL schemas
16. Fixed conversion of certain datatypes to PostgreSQL
17. Fixed parsing of SQL Server Compact table names which caused them to fail converting.
18. Fixed Paradox long memos handling, where memos were truncated to 20.000 characters
19. Fixed dBase DBT memos reading
20. Fixed translation of MySQL bit default values to SQL Server
21. Fixed memory leaks which become an issue with databases containing over 30k tables
22. Fixed datatype and default values advanced mappings handling

September 01, 2009
Full Convert 5.1 released

1. Much improved ODBC support
2. 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.
3. Added quick help for connecting in the Project Settings
4. Fixed SQL Server IDENTITY_INSERT bug introduced in v5.0
5. Fixed handling of Null value in Paradox TIMESTAMP fields
6. Many bug-fixes throughout the application

July 13, 2009
Full Convert 5.0 released

1. 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.
2. 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.
3. 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.
4. Added support for Excel 2007 files as a target. For each project, choose whether you want Excel97 or Excel2007 output.
5. Excel doesn't have to be installed as we use native Excel read/write components for maximum speed and reliability.
6. Table Settings dialog now notifies that filter is not available for non-relational source databases
7. 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.
8. 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.
9. SQL Server Compact Edition database maximum size increased to 4GB
10. 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.
11. 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.
12. Added NDBCLUSTER table engine for MySQL target
13. 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.
14. Added support for SQL_VARIANT SQL Server data type. When you convert it to other database engines, we copy it as a BLOB.
15. Added option to generate sqlplus compatible output for Oracle target
16. 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.
17. 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.
18. 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.
19. Added 'Test Filter' button in Table Settings. Use it to see how many records your custom source table filter selects.
20. Modified Postgres database table parsing so that only the tables in the current schema are visible
21. All Interbase/Firebird user-defined BLOB types are now handled. User-defined types are handled as SUB_TYPE 0.
22. Fixed rare case when MySQL BTREE index caused parser error while analyzing table
23. Fixed handling of MySQL YEAR data type
24. Fixed handling of Postgres BOOLEAN data type
25. Fixed reading of Postgres unique/primary key attributes
26. Fixed case when constraint names were lowercased unintentionally
27. Fixed handling of DBF logical data type ('Y' values were incorrectly tagged as False)
28. Removed differences in default data type mapping in Table Settings compared to default on-the-fly mapping

February 09, 2009
Full Convert 4.6 released

1. Significantly improved conversion speed for Firebird target, around 300% increase
2. Added support for SQL Server Compact Edition, both as a source and as a target
3. Added support for SQL Server 2008 new DATE, TIME and DATETIME2 types
4. Added support for SQL Server 2008 new multi-line SQL insert command
5. Added printing support
6. Added new command-line override. When you specify -override tables_to_process=*, Full Convert will process all tables from the source
7. Added support for character fields larger than 255 characters in DBF engine
8. Added support for SQL Server XML datatype
9. Increased timeout for command execution in most targets to get rid of timeouts for long index creation
10. Improved performance of connecting to SQL Server and listing its tables
11. Improved handling of very large custom user SQL scripts so that scripts sized hundreds of MB use a minimum of RAM
12. Set default write batch records to 200 as this proved optimal for most target databases.
13. 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.
14. Auto-creating Access database will now use your default database folder instead of Desktop, if you have specified the folder in the options dialog.
15. 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.
16. Fixed trial version issue with SQL Server target where trial watermark can cause string truncation error
17. Fixed handling of tables with percent-sign in the name
18. Fixed handling of table and column names starting with a number for Interbase/Firebird target
19. Fixed case for Oracle target where parameters were not used to insert CLOB data
20. Fixed case for MySQL target where key column names were trimmed to 64 characters alltogether, instead of per-column
21. Fixed conversion from MySQL to MySQL where table engine was enforced with empty string
22. Fixed handing of datetime values where a very small values were incorrectly interpreted as NULL values

January 14, 2009
Full Convert 4.5 released

1. 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/)
2. Improved handling of invalid source data containing NULL values in NOT NULL fields
3. Paradox strings are no more right-trimmed by Full Convert
4. Fixed connection lost error on long index creation in MySQL

December 19, 2008
Full Convert 4.4 released

1. Read large table in chunks is now supported in Firebird source (but not Interbase)
2. 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.
3. Added automatic handling of certain invalid DBF data when encountered
4. Implemented memory optimizations when unpacking large (hundred MB in size) SQL scripts from file for automated execution before or after conversion
5. Improved datetime detection in Excel document cells
6. Fixed reading of large SQL Server tables in chunks when primary key was nonclustered.
7. Fixed reading of formatted paradox memos for certain versions of Paradox tables
8. Fixed conversion of SQL Server timestamp to Oracle
9. Fixed case when large Paradox memos could corrupt memory buffer
10. Interbase/Firebird client library setting was ignored (gds32.dll/fbclient.dll). Fixed.

October 20, 2008
Full Convert 4.3 released

1. Added multi-select in table selection
2. Multiple-sheet Excel documents are now handled automatically. Each sheet represents a separate table. Empty sheets are ignored.
3. 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.
4. 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.
5. 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.
6. Added custom character set definiton to MySQL options. This is useful, for example, for utf8 data.
7. Added WITH NOCHECK option for primary key creation of SQL Server target
8. Fixed execution of custom long Oracle scripts in Run Before/After Conversion
9. Fixed case where Interbase/Firebird text blob fields were converted as garbage
10. Fixed connecting to SQL Server 2000 and older in SQL Server mode authentication

October 03, 2008
Full Convert 4.2 released

1. 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.
2. Fixed handling of Oracle parameters where old parameters were not cleared correctly
3. Fixed detection of local/remote server for SQL Server when named instance is specified
4. Fixed writing of Excel files
5. Fixed case when Full Convert ignored 'Create tables' option in the new Customize dialog
6. Fixed ORA-00932: inconsistent datatypes: expected NCLOB got BLOB
7. Fixed a last-minute change causing mixed authentication to fail on SQL Server 2005
8. Fixed a case where same-named tables in different target SQL Server schemas caused internal duplicate index error in Full Convert

September 25, 2008
Full Convert 4.1 released

1. Added support for executing SQL scripts on the source database before and after conversion
2. Added support to consecutively run several files inside of the ZIP archive as external scripts. You can even specify file masks!
3. Project customization expanded and moved to separate dialogue
4. Completely rewritten Excel support. It is now faster, much more reliable and doesn't even require Excel to be installed.
5. 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.
6. Auto-refreshing scheduled tasks can now be disabled in the Scheduler
7. 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.
8. Conversion will now drop related foreign keys prior to dropping a table in SQL Server target
9. Fixed handling of text data type for SQL Server 2000
10. Fixed handling of varchar(max), nvarchar(max) and varbinary(max) data types in global override of data types in Options
11. Fixed list colors on WindowsXP
12. Fixed automatic recognition of delimited text files in Project Settings
13. Fixed Unicode writing to Oracle target
14. Clicking Copy/Append/No Data options in project customization page was forcing immediate convert

August 11, 2008
Full Convert 4.0 released

1. Totally new user interface! We used ribbon known from Office 2007 to simplify your workflow and improve the experience.
2. 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.
3. Added Unicode support! Full Convert can now handle all those umlauts, Chinese, Japanese, Hebrew and Arabic letters with ease!
4. 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
5. 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.
6. Added in-place edit feature into the data grid. No more need to go to other tools to modify your converted data.
7. Added datatype mapping on a global level as well and set-up rules used for all conversions.
8. 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
9. Added tips into error messages. For the common problems Full Convert will suggest actions to resolve the issue.
10. Added display of progress when Full Convert is called via command-line and immediate close switch is not specified
11. Added automatic 'Skip activation' action when trial can't reach our server due to firewall/proxy setup
12. Added schema specification in SQL Server
13. Added automatic creation of index for MySQL target Table Settings when user creates auto_increment column
14. Added direct link to customize the project
15. Added satisfaction survey to the trial version so we can easily be notified of the problems and new features requests.
16. Added notification window when the conversion is finished
17. Improved scheduler
18. Improved progress dialog can now be dragged and is no longer visible on top of other windows
19. Fixed handling of empty varchar(max) SQL Server datatype
20. Fixed handling of double datatype for DBF source tables
21. Fixed reading of disabled options intended for Enterprise in Editions
22. Fixed occasional handling of Oracle clob as blob data
23. Fixed case when Oracle sequence was not created for empty source table
24. Fixed creation of indexes in Access target
25. Fixed 'Unknown datatype' error in Oracle target
26. Fixed Interbase/Firebird WHERE clause handling in Table Settings
27. Fixed conversion of Oracle LONG RAW datatype to SQL Server 2000 target

January 29, 2008
Full Convert 3.3 released

1. Added support for Oracle 11g
2. MySQL target will now automatically convert decimal identity fields to int/bigint, depending on the size
3. Fixed occasional incomplete metadata retrieval
4. Fixed handling of NULL values in fields where target database doesn't support NULLs in specific scenarios
5. Fixed handling of MySQL mediumtext datatype

November 28, 2007
Full Convert 3.2 released

1. Added an option to require user global datatype matching for users who want absolute control over conversion
2. MySQL target now creates only required indexes as a part of create table statement and the rest later
3. Added warning when BULK mode and Table Settings are used so you can know when a table can't use BULK mode
4. Added handling of case when MySQL returns incomplete create table statement to us
5. Fixed global datatype conversion casing sensitivity
6. Fixed handling of 64-bit integer values for Interbase/Firebird target

November 16, 2007
Full Convert 3.1 released

1. Fixed handling of MySQL unsigned datatypes
2. Fixed Paradox tables reading
3. Fixed reopening of Access password protected databases
4. Fixed the WHERE condition in Table Settings which was ignored in v3.0
5. Fixed table name transforming in Session Wizard's Customize section

October 20, 2007
Full Convert 3.0 released

1. Massive data transfer speedup!
2. Added support for MySQL LOAD DATA bulk mode
3. Added support for PostgreSQL COPY bulk mode
4. Improved process of conversion from SQL2005 to SQL2000 or earlier
5. Added warnings to the conversion log
6. Empty tables are now immediately skipped when copying data
7. Added handling of duplicate DBF indexes
8. Added autorename of duplicate DBF fields
9. 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
10. Added global datatype conversion override for each target
11. Added preview of delimited text file in Session Wizard for easy selection of delimiter
12. 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
13. Bulk mode temporary files written asynchronously for best performance. We used a very nice class written by Dmitry Streblechenko (dmitrys@asu.edu) in 1997.
14. You can now specify client and server for for the bulk mode temporary files for each target, and override it per session
15. Trial does not expire anymore, to help those who need more time evaluating
16. DBF files are no more locked for writing during conversion
17. Fixed progress bar display (last write batch didn't update the progress bar)
18. Fixed Firebird default value parsing

September 26, 2007
Full Convert suite 2.19 released

1. Added ability to directly type in the name of PostgreSQL and SQL Server databases in the Session Wizard
2. Fixed Interbase/Firebird blob sub_type handling
3. Fixed PostgreSQL login bug
4. Fixed PostgreSQL blob writing bug
5. Fixed Access password handling

August 31, 2007
Full Convert suite 2.18 released

1. Fixed MySQL tinyint interpretation as bool
2. Fixed Lotus1-2-3 handling
3. Fixed Interbase/Firebird index creation
4. Fixed reading tables in chunks

August 14, 2007
Full Convert suite 2.17 released

1. 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
2. Fixed missing PostgreSQL access DLLs. We have added missing DLLs to our release
3. Fixed 'Data copying for existing tables' error for new projects

July 07, 2007
Full Convert suite 2.16 released

1. Added support for PostgreSQL as both source and target (Enterprise required for the target)
2. 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.
3. Speed up of MySQL connection time by not using slow information_schema to read metadata
4. Added advanced options to the Session Wizard (Enterprise only): Select tables with different size, Data copying for existing tables, Clear All Table Settings
5. Added an option to auto-save error log
6. Changed trial mode. No more records/column limitation, now we simply stamp the data with ***TRIALMODE*** every few records
7. Improved compatibility with SQL Server 6.5
8. TEXT datatype is now by default converted to VARCHAR(MAX) if SQL2005 is used as a target
9. BLOBs are now by default converted to VARCHAR(MAX) if size is larger than 8000 characters and SQL2005 is used as a target
10. Added support for 'USING BTREE' clause in MySQL index definition
11. Full Convert won't automatically rename identifiers which are reserved words in target database anymore. There is an option to turn this behavior on.
12. Scientific number notation is not used anymore for SQL Server target because SQL2005 no longer supports it in BULK INSERT by default
13. Oracle sequence and trigger names are now trimmed to 30 characters
14. Fixed connection issue when SQL Server is running on a different port than default
15. Fixed the problem where Access and SQL Server data only preserved 4 digits behind decimal point
16. Fixed occasional errors with BULK INSERT of BLOB and DATETIME data on SQL Server target
17. Fixed the handling of case when Interbase doesn't fill-in certain metadata values
18. Fixed parsing of Access indexes

April 23, 2007
Full Convert suite 2.15 released

1. Added support for Oracle sequences and corresponding triggers to Enterprise
2. Added support for Interbase/Firebird DEFAULT values
3. Added support for different type of quoting in delimited text files
4. Added compatible mode for connection to SQL Server 6.5 and earlier
5. Oracle parser will now skip over SDO_GEOMETRY fields
6. Enforced Oracle date format to a fixed format to avoid problems with varying configurations
7. 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.
8. Fixed escaping of double quote in a MySQL target. It isn't quoted anymore.
9. Fixed issues with defaults and SQL Server VARCHAR(MAX) columns
10. Fixed Session Wizard appearance on large-fonts displays
11. Fixed certain cases where Oracle target could miss a constraint

March 12, 2007
Full Convert suite 2.14 released

1. Added support for BINARY, VARBINARY types in MySQL
2. Added support for VARCHAR(MAX), NVARCHAR(MAX), VARBINARY(MAX) in SQL Server
3. Added Text as target engine to Enterprise for easy conversion of source database to delimited text
4. Added auto-translation of character set to Enterprise (from dBase, FoxPro and Paradox sources)
5. Added graceful fallback to DML in Oracle target when Direct mode is used
6. Added ability to resize Session Wizard, handy when you have large table names
7. Added graceful bypass of handling of mysql.proc in case that user doesn't have proper SELECT privileges for MySQL connections
8. Added detection of installed OLEDB providers. SQL Server connection now automatically uses SQLNCLI instead of SQLOLEDB if available.
9. Added detection of maximum allowed packet size for MySQL target, so Full Convert will take advantage of increased packet size if available
10. Added selection of protocol for Interbase/Firebird connection
11. The dialog is shown to user to use 'Read large tables in chunks' when OutOfMemory exception is encountered
12. Removed legacy database connections (dBase and FoxPro over OLEDB) as they are superseded by a direct reader 'dBase and FoxPro (DBF)'
13. Removed MySQLscript engine from the source engine list as it ended there by mistake
14. SQL Server statistics are no more being interpreted as indexes for a table
15. Fixed the Table Settings - when Append Data was selected, the option was not remembered

February 16, 2007
Full Convert suite 2.13 released

1. Added support for Access 2007
2. Added quick-select of local SQLExpress
3. Added "quiet" command-line switch which hides the application window
4. Added ability to override Interbase/Firebird library from default GDS32.DLL
5. Improved Interbase/Firebird structure reading. Option to read full Interbase/Firebird schema at once has been removed.
6. Fixed TXT import where character "\r" was left at the end of the last field in line
7. Fixed DBF memo reading in certain versions of DBF

November 24, 2006
Full Convert suite 2.12 released

1. Added optional parsing of SQL Server views as if they were tables. Enterprise only.
2. Added default SYSDBA/masterkey username/password for the Interbase/Firebird connection
3. 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.
4. Added workaround for Interbase/Firebird bug where server does not support direct reference of columns named as reserved words.
5. Added option to skip primary key creation for Oracle target
6. Changed code signing to Verisign instead of Thawte in preparation for "Certified for Windows Vista" logo program when Windows Vista is released
7. Fixed unsupported CLOB syntax in Oracle versions less than 10

October 10, 2006
Full Convert suite 2.11 released

1. 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.
2. Added option to skip prefix and suffix lines in the delimited text file. This allows to bypass header comment and summary info, for example.
3. Added reports of the source and target tables with their record counts (Enterprise only)
4. 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.
5. Added auto select in Session Wizard. Enterprise only.
6. 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.
7. Added optional parsing of Oracle views as if they were tables. Enterprise only.
8. Fixed data throughput calculation not to include opening of the table, only data copying
9. Removed dependency of the generated DATETIME SQL string on the system regional settings
10. Fixed handling of tables with quotes in the name in the Table Settings
11. Fixed built-in optional conversion of LONG to VARCHAR/CLOB in Oracle 8
12. Fixed occasional trimming of last character in the last DBF table field
13. Fixed detection of deleted DBF records
14. Fixed Oracle fast loader inability to find table when preserve table and column case is selected in Options

September 01, 2006
Full Convert suite 2.10 released

1. Added support for Views in ODBC. Enterprise only.
2. Force close of the application during conversion is now properly handled and this event is logged in the error log
3. Fixed interpretation of Oracle DATE datatype as DATETIME in the other database engines

August 17, 2006
Full Convert suite 2.9 released

1. 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.
2. 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.
3. 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.
4. Added support for BCD datatype in Paradox
5. Added auto-refresh every 3 seconds in the Scheduler task list
6. Improved support for LONG datatype in Oracle
7. Fixed parsing of tables in MySQL. Views were treated as tables, now they are ignored.
8. Fixed Paradox reader, in rare cases table reading was ended prematurely
9. Fixed a situation where SQL Server target in certain rare circumstances mixed blob text/binary attribute
10. Fixed reading of NUMERIC datatype from DBF source. It was converted into DOUBLE, and now is marked as DECIMAL of correct precision as scale.
11. Fixed reading of CURRENCY datatype from the Access source. It was converted into DECIMAL, and now is marked as MONEY.
12. Fixed exception when "override_file" command line parameter was invalidly specified in Enterprise
13. Fixed non-initialized NULL values when using Oracle fast loader
14. Fixed hiding of the Welcome Dialog - the option in question was ignored

July 14, 2006
Full Convert suite 2.8 released

1. Relaxed conditions to be able to take advantage of Oracle fast loader. Now (N)CHARs and (N)VARCHARs can be used as well.
2. Oracle target now (again) uses internal fast loader as default. You can enable standard inserts in Options dialog.
3. Fixed Interbase/Firebird huge tables reading by chunks in Enterprise
4. Fixed Oracle option to change (N)CLOBs to (N)VARCHARs

July 04, 2006
Full Convert suite 2.7 released

1. Extended trial records limit to 50 and set this mode to default
2. Fixed parsing of Full Convert 1.x DBF session files
3. Fixed Table Settings in 'recreating data' mode - original table name was used for truncating, ignoring eventual user-specified name

June 25, 2006
Full Convert suite 2.6 released

1. ODBC support fully rewritten. It is now much faster and very reliable.
2. 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
3. Added character set translation in Enterprise to Paradox reader in addition to DBF
4. Added parsing of FoxPro DBC file to allow for long field names
5. In Enterprise version, added ability to override session connection parameters using command line switches or using external file
6. Mapped minus character in table names to underscore character for Oracle target
7. License info now displays whether it is single user, site, or worldwide license
8. MySQL table engine is now by default preserved when converting to MySQL (as a backup for example)
9. Added default username to use when specifying MySQL connections - default is "root"
10. 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.
11. Added support for Oracle ROWID datatype
12. Added trimming of trailing spaces in the DBF source strings
13. 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.
14. Oracle target now uses standard inserts with append hint as default. You can enable internal fast loader in Options dialog.
15. 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.
16. Saving log files now prompts whether to overwrite if the file already exists
17. Fixed occasional failure to override blanks in not-null fields when Oracle direct loader is used
18. Fixed incorrectly calculated memo length in dBase7 reader
19. Fixed occasional invalid trimming of column names in Oracle constraints
20. Fixed occasional invalid display of accented character in built-in data grid
21. Fixed invalid interpretation of Integer columns as autoinc in DBF reader

May 22, 2006
Full Convert suite 2.5 released

1. Added support for dBase7 format
2. Added ability to deselect incorrectly defined fields in Table Settings
3. Direct loader for Oracle now also handles blanks in not-null fields
4. 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.
5. In Enterprise version, added APPEND hint to Oracle loading modes definition
6. DBF tables with more than 255 columns are now supported
7. Fixed occasional incorrect interpretation of SQL Server column nullability property

April 25, 2006
Full Convert suite 2.4 released

1. Advanced table settings added to Session wizard in Enterprise version. Ability to override default conversion parameters on table and column level.
2. 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.
3. Added support for FoxPro and dBase over OLEDB, for customers who want to connect this way. This has to be turned on in Options.
4. 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.
5. Added ability to specify default database folder in Options dialog
6. Added check for online updates (latest version)
7. DBF reader now recognizes field nullability, hidden fields and autoinc fields. This has to be enabled in Options.
8. DBF reader now parses CDX files to support translation of indexes
9. Session saving is now enabled in trial
10. 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.
11. Fixed reset of Options on cancelling of Options dialog
12. Fixed handling of MySQL indexes' column length
13. Fixed handling of MySQL fulltext indexes
14. Fixed bug in trial where 5 records test mode was sometimes ignored and test mode was forced to 5 columns mode

March 22, 2006
Full Convert suite 2.3 released

1. Added creation of unique constraints to Interbase/Firebird tables where needed for foreign key recreation
2. Added creation of unique constraints to Oracle tables where needed for foreign key recreation
3. Added support for Oracle timestamp data type
4. Fixed handling of Interbase/Firebird tables containing quotes in their name
5. Fixed handling of Interbase/Firebird BLOB sub types
6. Fixed parsing of MySQL tables containing spaces in their name
7. Fixed reading of Oracle float type precision

March 14, 2006
Full Convert suite 2.2 released

1. Direct Oracle fast loader (huge speed gains) is now available in Enterprise version
2. Enhanced ODBC connection. Username, password and compatibility mode are added.
3. Fixed Memo fields handling of DBF VFP3 tables
4. Fixed datetime fields erroneous handling of DBF tables introduced in our direct DBF reader
5. Fixed connect error on attempt to open password protected Access database

February 09, 2006
Full Convert suite 2.1 released

1. Added character set conversion in Enterprise version (experimental, available only for DBF source for now)
2. Further speedup of SQL Server bulk insert mode
3. Speedup of dropping tables in SQL Server and Access targets
4. 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)
5. Fixed case changing behavior in table and column name modifier to support characters with accents
6. Integer types in Oracle target are now converted to NUMBER type (not FLOAT anymore). NUMBER has precision set according to size of Integer type.
7. *.fcs (Full Convert session) files are now associated with Full Convert on install
8. Fixed case where invalid date in DBF record caused entire record to be rejected
9. Fixed Access relationship parsing error where differently named local and related columns were swapped
10. Fixed behavior when scheduled to run as System account
11. Fixed handling of Oracle CLOB columns
12. Fixed display of Oracle database in tree list to be user@service, not user@server
13. Now using quotes in Oracle target only where needed

January 16, 2006
Full Convert suite 2.0 released

1. Total user interface redesign
2. Overall conversion speed improvements
3. Added welcome dialog to speed up common tasks
4. Added built-in scheduler to enable fully automatic conversions
5. 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)
6. Merged Paradox and FoxPro engine to minimize confusion of users as both engines use DBF files
7. 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.
8. Best fit for data displayed in grid can now be limited for small tables only (configurable in Options)
9. Options improved
10. Improved logging speed of field validations errors (such as invalid dates)
11. Improved update of progress dialog for tables with huge blobs where database can handle only a few records per second
12. Improved Oracle target speed when table doesn't contain BLOBs
13. 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.
14. SQL sent to database is flushed before it reaches 1MB in size to avoid problem with typical setup of MySQL and BLOBs.
15. Installation files are now signed
16. Fixed dropping of Access tables (dependant foreign key constraints were not dropped correctly)
17. Fixed detection of Access autoincrement columns
18. Fixed detection of Access referential integrity rules (on update/on delete)
19. Fixed a bug where Oracle FLOAT data type used digit instead of binary precision, resulting in less precision than desired
20. Fixed detection of Interbase/Firebird primary keys

August 30, 2005
Full Convert 1.9 released (Interbase/Firebird Edition introduced)

1. Interbase/Firebird Edition introduced!
2. Added XML support
3. 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
4. All targets now save referential integrity constraints
5. Added support for ON DELETE and ON UPDATE rules
6. Added error return code so scheduled conversion can trap errors
7. Interbase/Firebird now handles both SQL Dialects 1 and 3
8. Improved compatibility with Oracle 8.x (which does not support multi-byte characters)
9. Improved conversion of default values
10. You can now select tables of any user in Session Wizard for Oracle source
11. Improved Oracle connection dialog so server and port can more easily be defined
12. Improved responsiveness of Cancel button in progress dialog
13. License keys should now work also with most exotic characters in our customers' names :)
14. SQL Log no longer takes up memory during conversion
15. Fixed case where some Excel sheets were not displayed as tables
16. Removed delay on typing SQL Server connection server name (network was polled for existing SQL Servers too often)
17. Improved detection of invalid data in source database
18. Removed 'Professional' and 'Standard' versions as such. 'Standard' versions are no more supported, and 'Professional' are simply Editions.

June 13, 2005
Full Convert 1.8 released

1. Fixed Interbase/Firebird error with mixed-case table names
2. Performance much improved in SQL Server target
3. Improved progress dialog
4. Fixed cancelling in memory optimized mode
5. 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
6. Added detection of multiple same columns defined in index
7. Fixed incorrect detection of Excel print areas as sheets

May 05, 2005
Full Convert 1.7 released

1. 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:
2. MySQL
3. FoxPro
4. Oracle
5. Access (must have primary key defined to take advantage of this feature)
6. SQL Server (must have primary key defined to take advantage of this feature)
7. Fixed MySQL partial index recognition

March 27, 2005
Full Convert 1.6 released (Access Edition introduced)

1. Fixed invalid handling of SQL Server timestamp column
2. Fixed conversion of strings containing ASCII value of zero characters. They are now replaced with spaces allowing SQL to be executed properly.
3. Fixed occasional Interbase/Firebird server list error
4. Fixed truncating of decimal values to 2 decimal places
5. Fixed unicode column types detection in databases not supporting unicode
6. Fixed numerous Access target bugs
7. Fixed ignoring of MySQL table type option - InnoDB was always used.
8. Access Edition introduced!
9. Added ability to supress invalid field value errors to speed up conversion when there are many
10. Added ability to force Unicode or Non-Unicode columns to target database
11. Fixed Oracle blob and clob columns reading
12. Fixed incorrect setting of Paradox 00:00 time values to NULL
13. Fixed occasional wrong conversion of decimal datatype as integer from Interbase source

March 15, 2005
New Full Convert online tutorials are now available.

March 08, 2005
Full Convert 1.5 released

1. Fixed long varchar columns converting to MySQL
2. Fixed Oracle multiple-columns foreign keys handling
3. Fixed SQL Server foreign keys handling
4. Fixed Browse For Folder dialog incompatibility with certain systems
5. Improved Lotus 1-2-3 handling
6. Fixed invalid numbers handling in Paradox
7. Fixed NCHAR2, NVARCHAR2 and FLOAT handling in Oracle
8. Fixed incorrect multibyte character column length detection in Oracle
9. Changed folder browser behavior to automatically position to current folder

February 11, 2005
Full Convert 1.4 released

1. Oracle Edition introduced!
2. Paradox primary keys are now created in target database
3. Conversion process is now cancellable
4. Added command-line support for easy batch/scheduling
5. Added Export to text in Enterprise version
6. Added option to ignore default values. Usable for situations when default value is incompatible with target database
7. Edit SQL dialog is now color-coded
8. Fixed certain cases invalid Paradox blob field handling
9. Fixed incompatibility with Oracle 8
10. Fixed occasional incorrect Interbase/Firebird character column length detection
11. Fixed MySQL 4.1 authorization problems
12. User interface is improved
13. Direct connection to Oracle supported. Oracle Client software is not required anymore.
14. Added ability to drop recycle bin objects in Oracle database
15. Trial version is not row-limited anymore. This will provide good insight in conversion speed for user's specific installation.
16. Fixed Batch insert problem for Oracle target database. (Invalid character error)
17. Numerous smaller Oracle incompatibilities fixed

February 11, 2005
Full Convert online help is now available.

January 16, 2005
Full Convert 1.3 released

1. Added ODBC sources support
2. Added option to log all SQL commands during conversion in Enterprise version - SQL is displayed syntax colored
3. Added option to convert non-scaled decimals (numerics) to integers
4. Added conversion summary dialog
5. Added ability to go to specific record in table using Ctrl+G or using context menu on table data grid
6. Changed options behavior for changing case in Options - now tables and columns can have separate settings
7. Split logs to summary, error log and SQL log. Each can be saved separately. (SQL log is available in Enterprise version only)
8. Added exact reporting for invalid fields - this, combined with 'Go to record', enables you to easily find invalid data
9. Fetching record count for Paradox tables is now almost instant
10. Fixed incorrect timestamp handling for Paradox tables
11. Fixed incorrect null reporting for Paradox boolean fields
12. Fixed incorrect date handling for FoxPro tables
13. Fixed multiple tables drop
14. Fixed index creation failure in trial version when trying to create index of column skipped in trial
15. Fixed handling of tables with parentheses in name
16. Fixed incorrect parsing of table structure on case sensitive SQL Servers

December 02, 2004
Full Convert 1.2 released

1. Initial SQL Server Edition release
2. Initial Enterprise version release
3. Full support for MySQL 4.1
4. Added FoxPro support
5. Session wizard allows examining record counts of source data before importing (Professional, Enterprise)
6. Session wizard allows skipping of empty source tables (Professional, Enterprise)
7. Oracle dialog now supports authentication mode selection and lists available services
8. Added Options dialog
9. Added option to prepend prefix to target table
10. Added option to change case of tables and columns
11. Added option to display optimal column width in data grid
12. Added option to always display tables' record count
13. Added option to select target table type in MySQL
14. Added option to select number of records inserted per commit in MySQL
15. Rewritten handling of Paradox files for much better speed and accuracy
16. Rewritten handling of delimited text files for much better speed and accuracy
17. Added ability to view long text in grid cells
18. Fixed importing of indexes from SQL Server database
19. Indexes are now imported from Access databases
20. Increased number of allowed columns in trial from 3 to 5

October 07, 2004
Full Convert 1.1 released

1. Improved session wizard
2. Improved handling of Paradox files
3. Fixed width text files supported
4. Added passwords and system database support to Access connection

October 01, 2004
Full Convert - initial release