Previous topic: Importing Data from dBase (DBF) Files

In the previously discussed data importing example, among other items, we dragged and dropped a Firebird database file on Exportizer window with a database connected. Let's see, how we are importing data from the dragged database file into the target database.

Registering a File as a Database

Before importing data, Exportizer asks either to register the dragged Firebird file (it has an .fdb extension) as a database in Exportizer:

Asking to Register a Folder as a Database

If you want to use this file in Exportizer on the regular basis, it is better to register it. So, let's choose Yes.

Registering the Dragged Database

Register Database window appears:

Registering Firebird Database

Fill the needed connection parameters, specify a friendly database alias, and click OK.

Note: If the dragged database was already registered, just select its alias from the list of database aliases.

Choosing Import Settings

Next, Import dialog appears:

Import Firebird to SQLite Options

We see our connected SQLite database as a target database here.

Review the import options and change the needed ones. Click Next.

Table Mappings

Now, please check the source-to-target table mappings. You can change names of the target table to lowercase in a few clicks by choosing a corresponding action under Utilities button. You can also remove the mappings for the tables you do not want to import.

In the Transformation column, you can check/edit the source-to-target column mappings for each table pair. It is possible to rename columns, change their types, specify a primary key etc.

Table Mappings

Click Import. If there are no errors, you'll see the following notification:

Importing Result

See also

Practical Cases