Enable seamless migration of database tables along with their data, facilitate the creation of indexes and foreign keys. Additionally, work with a scheduler for automated migrations, a user-friendly target database explorer, a versatile command-line interface, and customizable datatype mapping.
Full Convert Enterprise is a conversion tool intended for handling huge databases: it can take an XLS (Excel native format) file with lots of data and convert it into a Microsoft Access database, dBase, FoxPro, Oracle, Lotus, My SQL or even txt-formatted data. The program is easy to use because it has a wizard that guides you through the conversion process. It can even search for your files and determine the types of databases you have on your hard disks.
Once you find the file you want to convert, you will be asked to specify the location for the new database ane the format you want to convert the data to. Then the wizard will let you select the tables you want to include, analyzing if there are tables that don’t contain any records. This way you can choose to skip those tables and not include them in the new file, or customize each table - for instance, to convert a table but save it under another name or remove some columns or fields.
Finally, the wizard will ask you if wish to convert your database immediately or explore the target database and then convert it manually. In this step, you can choose to customize the whole project, running an SQL script before or after conversion, and set the options for the text conversion. After that, when you click the “Convert” button, the program will start the conversion.
When the process concludes, you’ll see a summary including the errors found during the process: empty tables or missing primary key values, some others may refer to data that cannot be sorted by type, non-existent SQL scripts, or non-existent tables. Finally you will see the contents of each table and you can modify the records or change the behavior of the columns. Then you can print the data, add columns, compare tables with different record counts, etc.
If your conversions are a recurrent task, you can schedule them.
v3.2 [Nov 28, 2007]
Massive data transfer speedup!
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 ([email protected]) 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
Feature-rich relational database known for its high performance and excellent concurrency
