Full Convert provides powerful and comfortable way to convert data of many databases. Source databases supported: Microsoft Acces, dBase, FoxPro, Microsoft Excel, Interbase/Firebird, Lotus 1-2-3, MySQL, Oracle, Paradox, SQL Server, Text file, 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 connection, 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.
Changes in this version:
Massive data transfer speedup!Added support for MySQL LOAD DATA bulk modeAdded support for PostgreSQL COPY bulk modeImproved process of conversion from SQL2005 to SQL2000 or earlierAdded warnings to the conversion logEmpty tables are now immediately skipped when copying dataAdded handling of duplicate DBF indexesAdded autorename of duplicate DBF fieldsAdded visual clue icon to clear when the table is being open, when Full Convert processes data, and when the target database processes the dataAdded global datatype conversion override for each targetAdded preview of delimited text file in Session Wizard for easy selection of delimiterImproved scheduler - tasks can now be repeated (even every minute if needed) for a specific time duration - and force stopped if they run too longBulk 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 sessionTrial does not expire anymore, to help those who need more time evaluatingDBF files are no more locked for writing during conversionFixed progress bar display (last write batch didn't update the progress bar)Fixed Firebird default value parsing
System requirements:
Win98, MySQL 3.23/SQL Server 6.5/Oracle 8.1
( By Spectral Core GmbH - Full Convert Interbase/Firebird Edition Publisher )