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. 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 Field Mappings column, you can check the source-to-target column mappings for each table pair. It is possible to rename columns, change their types, specify a primary key etc.
Click Import. If there are no errors, you'll see the following notification:
- Exporting Large Tables
- Exporting Calculated Fields
- Exporting BLOBs to Individual Files
- Exporting to HTML Using Template
- Importing Database Files from Explorer