Full Convert is an effective software solution that offers a user-friendly conversion process for a variety of databases including Access, Oracle, MySQL, and Excel files. With support for multiple file formats such as dBase and FoxPro, Full Convert can easily and efficiently handle the migration of database data.
One of the standout features of Full Convert is its ability to display the target database structure in a tree-like browser with multiselect, making it easy for you to navigate through even the largest databases. Furthermore, Full Convert boasts powerful actions and parameters handling, with all your actions recorded and easily executed for new data snapshots.
With each new version, Full Convert introduces revolutionary new features. Version 5 is particularly noteworthy, as it is the first version to handle databases of unlimited size. Additionally, this version is the fastest yet, with a visual indicator that lets you know when a table with large binary data is being converted at a slower pace than usual (though Full Convert can still handle over 5000 records per second).
Overall, Full Convert is an excellent tool for anyone in need of reliable and efficient database conversion software. Its user-friendly interface, powerful features, and continuous updates make it stand out in the crowded data conversion market.
Version 5.8: 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
Version 2.9:
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
Version 2.8:
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.
Version 2.6:
ODBC support fully rewritten. It is now much faster and very reliable.
Changed Table Settings behavior - global name changing options are applied even when user has defined table settings - to allow easy global uppercasing or similar situation
Added character set translation in Enterprise to Paradox reader in addition to DBF
Added parsing of FoxPro DBC file to allow for long field names
In Enterprise version, added ability to override session connection parameters using command line switches or using external file
Mapped minus character in table names to underscore character for Oracle target
License info now displays whether it is single user, site, or worldwide license
MySQL table engine is now by default preserved when converting to MySQL (as a backup for example)
Added default username to use when specifying MySQL connections - default is "root"
Added ability to overwrite index names during schema parsing. This is useful when you have indexes with same names, target databases mostly do not support that.
Added support for Oracle ROWID datatype
Added trimming of trailing spaces in the DBF source strings
Full Convert now adds size to index column when target database is MySQL and column in question is BLOB. This can happen when source VARCHAR results with target TEXT datatype for example. Size is customizable in Options dialog.
Oracle target now uses standard inserts with append hint as default. You can enable internal fast loader in Options dialog.
Oracle and Interbase/Firebird target schemas are by default now created as case-insensitive. This overrides name transforms settings in Options, unless it is set to case-sensitive, in which case global options are applied.
Saving log files now prompts whether to overwrite if the file already exists
Fixed occasional failure to override blanks in not-null fields when Oracle direct loader is used
Fixed incorrectly calculated memo length in dBase7 reader
Fixed occasional invalid trimming of column names in Oracle constraints
Fixed occasional invalid display of accented character in built-in data grid
Fixed invalid interpretation of Integer columns as autoinc in DBF reader
Version 2.4:
Advanced table settings added to Session wizard in Enterprise version. Ability to override default conversion parameters on table and column level.
Direct Oracle fast loader is now turned on by default. It enables tenfold speedup compared to traditional SQL inserts, but is not used for tables containing blobs.
Added support for FoxPro and dBase over OLEDB, for customers who want to connect this way. This has to be turned on in Options.
MySQL target is now able to dynamically reorder colums and add index if needed for auto_increment columns to work. Also, only the first auto_increment column will keep this property, all the others will have this property reset because of MySQL's limitation of one autoinc column per table.
Added ability to specify default database folder in Options dialog
Added check for online updates (latest version)
DBF reader now recognizes field nullability, hidden fields and autoinc fields
DBF reader now parses CDX files to support translation of indexes
Session saving is now enabled in trial
Fixed reset of Options on cancelling of Options dialog
Fixed handling of MySQL indexes' column length
Fixed handling of MySQL fulltext indexes
Fixed bug in trial where 5 records test mode was sometimes ignored and test mode was forced to 5 columns mode
Version 2.3:
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
Version 2.1:
Added character set conversion in Enterprise version (experimental, available only for DBF source in this version)
Further speedup of SQL Server bulk insert mode
Speedup of dropping tables in SQL Server and Access targets
Multiple identity columns in source are now detected and modified so that only first one stays identity (for targets that do not support multiple identity columns per table)
Fixed case changing behavior in table and column name modifier to support characters with accents
Integer types in Oracle target are now converted to NUMBER type (not FLOAT anymore). NUMBER has precision set according to size of Integer type.
*.fcs (Full Convert session) files are now associated with Full Convert on install
Fixed case where invalid date in DBF record caused entire record to be rejected
Fixed Access relationship parsing error where differently named local and related columns were swapped
Fixed behavior when scheduled to run as System account
Fixed handling of Oracle CLOB columns
Fixed display of Oracle database in tree list to be user@service, not user@server
Now using quotes in Oracle target only where needed
Version 2.0:
Total user interface redesign
Overall conversion speed improvements
Added welcome dialog to speed up common tasks
Added built-in scheduler to enable fully automatic conversions
Improvement of Paradox source handling (increased speed, startup time of table data reading reduced to zero, minimal and constant memory consumption even for huge tables)
Merged Paradox and FoxPro engine to minimize confusion of users as both engines use DBF files
Added interception of NULL values in Interbase/Firebird primary key columns, as primary key columns can only be NOT NULL. Default values are inserted to avoid Interbase/Firebird exceptions.
Best fit for data displayed in grid can now be limited for small tables only (configurable in Options)
Options improved
Improved logging speed of field validations errors (such as invalid dates)
Improved update of progress dialog for tables with huge blobs where database can handle only a few records per second
Improved Oracle target speed when table doesn't contain BLOBs
Delimited text file no more requires character columns to be enclosed in parentheses. VARCHAR is now default field type, used when no other type passes validation rules.
SQL sent to database is flushed before it reaches 1MB in size to avoid problem with typical setup of MySQL and BLOBs.
Fixed dropping of Access tables (dependant foreign key constraints were not dropped correctly)
Fixed detection of Access autoincrement columns
Fixed detection of Access referential integrity rules (on update/on delete)
Fixed a bug where Oracle FLOAT data type used digit instead of binary precision, resulting in less precision than desired
Fixed detection of Interbase/Firebird primary keys
Version 1.9:
Interbase/Firebird Edition introduced!
Added XML support
Separated conversion into 4 stages (create tables, transfer data, create indexes, apply constraints), so that data is always transferred, even if it does not conform correctly to unique indexes and constraint rules
All targets now save referential integrity constraints
Added support for ON DELETE and ON UPDATE rules
Added error return code so scheduled conversion can trap errors
Interbase/Firebird now handles both SQLDialects 1 and 3
Improved compatibility with Oracle 8.x (which does not support multibyte characters)
Improved conversion of default values
You can now select tables of any user in Session Wizard for Oracle source
Improved Oracle connection dialog so server and port can more easily be defined
Improved responsiveness of Cancel button in progress dialog
License keys should now work also with most exotic characters in our customers' names :)
SQL Log no longer takes up memory during conversion
Fixed case where some Excel sheets were not displayed as tables
Removed delay on typing SQL Server connection server name (network was polled for existing SQL Servers too often)
Improved detection of invalid data in source database
Removed 'Professional' and 'Standard' versions as such. 'Standard' versions are no more supported, and 'Professional' are simply Editions.
Version 1.8:
Performance much improved in SQL Server target
Improved progress dialog
Added Oracle target option: Long text columns are now by default converted to VARCHAR(4000), because Oracle limits table structure to have only one LONG column per table
Added detection/handling of multiple same columns defined in index
Fixed incorrect detection of Excel print areas as sheets
Fixed cancelling in memory optimized mode