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 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.
Keywords: database, conversion, convert, migration, migrate, data, databases, Access, dBase, FoxPro, Excel
Recent Changes: Added support for PostgreSQL as both source and target (Enterprise required for the target)
Added filter in Table Settings. You can now specify the "WHERE clause" to filter out the source data for any table. This is only supported for relational source databases.
Speed up of MySQL connection time by not using slow information_schema to read metadata
Added advanced options to the Session Wizard (Enterprise only): Select tables with different size, Data copying for existing tables, Clear All Table Settings
Added an option to auto-save error log
Changed trial mode. No more records/column limitation, now we simply stamp the data with ***TRIALMODE*** every few records
Improved compatibility with SQL Server 6.5
TEXT datatype is now by default converted to VARCHAR(MAX) if SQL2005 is used as a target
BLOBs are now by default converted to VARCHAR(MAX) if size is larger than 8000 characters and SQL2005 is used as a target
Added support for 'USING BTREE' clause in MySQL index definition
Full Convert won't automatically rename identifiers which are reserved words in target database anymore. There is an option to turn this behavior on.
Scientific number notation is not used anymore for SQL Server target because SQL2005 no longer supports it in BULK INSERT by default
Oracle sequence and trigger names are now trimmed to 30 characters
Fixed connection issue when SQL Server is running on a different port than default
Fixed the problem where Access and SQL Server data only preserved 4 digits behind decimal point
Fixed occasional errors with BULK INSERT of BLOB and DATETIME data on SQL Server target
Fixed the handling of case when Interbase doesn't fill-in certain metadata values
Fixed parsing of Access indexes
Install Support: Install and Uninstall
Supported Languages: English
Additional Requirements: Win98, MySQL 3.23/SQL Server 6.5/Oracle 8.1
PAD file URL: http://www.spectralcore.com/download/fullconvert-ib.xml