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 .fdb file 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. In our example, we 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:

Table Mappings

Remove the mappings for the tables you do not want to import. In the Field Mappings column, you can also check the source-to-target field mappings for each table pair.

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

Importing Result

See also

Dragging Files

Importing Data

Practical Cases