Full 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:
1) extract columns and data to another table with all links preserved
2) merge tables
3) drop, rename, modify columns' properties
4) create indexes
5) drop unused tables
6) drop unused columns
* Execute freeform SQL
* See record counts of tables while you work
* Command-line support
* 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 a single mouse click.
Limitations in downloadable version:
5 columns or 5 records are converted from each table