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:
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:
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:
We see our connected SQLite database as a target database here.
Review the import options and change the needed ones. Click Next.
Now, please check the source-to-target 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:
- Exporting dBase (DBF) to SQL Script
- Exporting CSV to DBF
- Creating Schema for a Text Table
- Exporting Large Tables
- Exporting SQLite to Excel
- Exporting Excel to Firebird
- Exporting Paradox to Access
- Migrating Data from PostgreSQL to Oracle
- Exporting BLOBs to Individual Files
- Exporting to HTML Using Template
- Importing Database Files from Explorer