Full Convert Enterprise 4.6

Full Convert Enterprise 4.6 is a useful software which provides powerful and comfortable way to convert data of many databases.

Source databases supported: Microsoft Access, dBase, FoxPro, Microsoft Excel, Interbase/Firebird, Lotus 1-2-3, MySQL, Oracle, Paradox, SQL Server, Text files, ODBC, XML.

Target databases supported: MySQL, SQL Server, Oracle, PostgreSQL, Access, Interbase/Firebird. Target database structure is displayed in tree-like browser with multiselect, allowing you to easily navigate through huge databases.

Major Features:

1. Convert instantly - setup connections, choose tables and go!
2. Convert data, indexes and constraints (depends on database)
3. Browse through your target database and perform advanced actions
4. Command-line support
5. Conversion can be cancelled anytime
6. All errors are logged
7. Invalid field values are converted as nulls and logged on which row they occurred - you can convert huge tables without stopping because of few invalid fields
8. Examine tables' data in advanced grid, memo fields can be examined in multi-line view
9. Multiselect - perform actions on multiple objects at once
10. View all SQL commands issued to database during conversion process for easy revision
11. Change structure of database with ease
    • Extract columns and data to another table with all links preserved
    • Merge tables
    • Drop, rename, modify columns' properties
    • Create indexes
    • Drop unused tables
    • Drop unused columns
12. Execute freeform SQL
13. See record counts of tables while you work
14. All your actions are recorded and stored in encrypted session file - on next conversion you can choose to simply convert, or to convert and execute all recorded actions - you can automatically convert and change structure to desired with single click

Enhancements:

• 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