Full Convert Enterprise 3.2
ull Convert 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, Microsoft SQL Server, Oracle, Access. Target database structure is displayed in tree-like browser with multiselect, allowing you to easily navigate through huge databases. Unique feature of Full Convert is powerful actions and parameters handling. All your actions are recorded and can be easily executed later for new data snapshot. There is no need to create mappings from source tables and columns to target. Benefits for you Convert instantly - setup connections, choose tables and go! Convert data, indexes and constraints (depends on database) Browse through your target database and perform advanced actions Conversion can be cancelled anytime All errors are logged Invalid field values are converted as nulls and logged on which row they occured - you can convert huge tables without stopping because of few invalid fields Examine tables' data in advanced grid, memo fields can be examined in multi-line view Multiselect - perform actions on multible objects at once View all SQL commands issued to database during conversion process for easy revision 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 Execute freeform SQL See record counts of tables while you work Command-line supportAll 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 a single mouse click.
Requirements
Changes: 3.2
Added support for MySQL LOAD DATA bulk mode
Added support for PostgreSQL COPY bulk mode
Improved process of conversion from SQL2005 to SQL2000 or earlier
Added warnings to the conversion log
Empty tables are now immediately skipped when copying data
Added handling of duplicate DBF indexes
Added autorename of duplicate DBF fields
Added visual clue icon to clear when the table is being open, when Full Convert processes data, and when the target database processes the data
Added global datatype conversion override for each target
Added preview of delimited text file in Session Wizard for easy selection of delimiter
Improved scheduler - tasks can now be repeated (even every minute if needed) for a specific time duration - and force stopped if they run too long
Bulk mode temporary files written asynchronously for best performance. We used a very nice class written by Dmitry Streblechenko (dmitrys@asu.edu) in 1997.
You can now specify client and server for for the bulk mode temporary files for each target, and override it per session
Trial does not expire anymore, to help those who need more time evaluating
DBF files are no more locked for writing during conversion
Fixed progress bar display (last write batch didn't update the progress bar)
Fixed Firebird default value parsing
