Home > Full Convert > Tutorials
Convert your database quickly and reliably.
- As easy as 1-2-3: select your database, choose tables and go!
- Data, indexes and table relationships (foreign keys) are automatically translated
- You can get a data throughput of up to 20 thousand records per second
- Large database? No problem! You will be able to handle gigabytes and gigabytes of data
Convert Paradox to Access
We will now migrate Paradox database to Microsoft Access in under five minutes.
Purpose of this tutorial is to show you basic use of Full Convert. Setup can be saved for repeated migration, so conversion can be reopened and completed in a matter of seconds. Please note that Full Convert has powerful scheduler built-in, so you can choose to automatically convert your databases in a time that suits you and in predefined intervals.
Purpose of this tutorial is to show you basic use of Full Convert. Setup can be saved for repeated migration, so conversion can be reopened and completed in a matter of seconds. Please note that Full Convert has powerful scheduler built-in, so you can choose to automatically convert your databases in a time that suits you and in predefined intervals.
Connecting to databases
As we start Full Convert, main form is empty.
Let's create new conversion session. Welcome dialog has "Create new conversion" item for this purpose.
Here we will choose Paradox database from the list of available source database formats and fill in connection properties. You can simply click ellipsis (...) button to select a folder containing your DB files (Paradox databases are consisted of DB files) through the Browse For Folder dialog. For this purpose, we will select DBDEMOS database.
Clicking Next, we need to select our desired target database (as Enterprise version supports multiple targets), or simply fill in connection properties if you are owner of Full Convert Edition.
We will now select tables for conversion. Please note that you can count rows of tables to easily see where data actually resides. Clicking "Unselect empty" moves all empty tables to 'Do not convert' list.
Clicking "Next" button brings us to the last page in the wizard, the summary. By default, "I want to convert immediately." option is selected. This is what we want. Otherwise, you can also choose to only explore target database at this point (as Full Convert has full-fledged database/data explorer built-in) and simply press "Convert!" button on toolbar when ready.
So, pressing "Convert!" button immediately begins the conversion process.
Conversion
You can cancel conversion process anytime. For smaller databases we are done in few seconds.
After conversion is finished you will be presented with a summary, which you can save. All eventual errors will be shown in a separate tab.
Detailed summary
Owners of Enterprise version can also inspect and save SQL script generated during the conversion. Possible use for this is further manual inspection of data or use of our automated conversion process in any other desirable application.
Navigating the target database
Navigating structure tree shows us what the target database looks like now. You are now free to do further modifications on structure, rename columns or change their type, drop obsolete columns, extract part of a table to new table etc.
This is the end of this basic tutorial. Advanced actions are covered in advanced tutorials.
January 29, 2008
Full Convert 3.3 released
To see detailed version history of this application, please click here.
A great tool with simply impeccable service, Full Convert
allowed us to port a client's existing database to our new system with
minimal effort in no time.
Highly recommended!
Nick Thomson, MonsterVision