Export / Import
dbFront includes the ability to export your dbFront settings, basic schema and data from any database/version and then convert and import into any other database/version.
The database export functionality is found under the Advanced Database Menu. Clicking on Export brings up a simple dialog that requires the selection of a database to export. Once a database is selected then other options will appear.
- Tables (default ALL): By default, all tables are included in the export. You can optionally override this setting and backup only a select few tables.
- Backup Data: If checked then the data will also be included in the backup. Checking this option will also display the Backup Options.
- Obfuscate (default NONE): If the data is included in the backup then you can optionally specify tables that should be obfuscated. See: Obfuscating Data
The export file stores the basic database schema, dbFront configuration and optionally the data but does not cover schema objects such as Views, Triggers or Stored Procedures.
The default destination for the export file is
The database import functionality is found under the Advanced Database Menu. Clicking on Import brings up a simple dialog that requires the selection of a destination database and the export file.
dbFront will look for the export files in the folder
- Apply Config: Apply the configuration after creating the structure and importing the data.
- Skip Database Identifiers: When import into a completely different database then you might not want database-specific properties overwritten. This option allows you to retain the [Caption, Description, LogoFile, Group, Theme and CSSFile] of the destination database.
- Import Data: Import any data found in the export file.
- Skip Missing Objects: If checked, then dbFront will ignore missing fields, tables and relationships during the import. Otherwise, dbFront will generate the SQL for the missing objects and expect their creation before the import will proceed.
Export / Import Uses
Migrating Settings into Production
The primary purpose of the Export / Import functionality is to migrate the dbFront configuration from one environment to another. This could be used to migrate Development settings into Test or Production.
- Before migrating the settings you should first migrate the database structure changes. dbFront has a basic ability to detect and recreate missing database structures, but it is best to use your server-specific tools to migrate the database structure changes.
- When migrating the dbFront configuration be sure to exclude the exporting or importing of data.
Sometimes it is necessary to migrate your database setup, structure, and data to a different server type or role. For example: Oracle Database to a SQL Server database, or a SQL Server database to a MySQL database. Any combination will work.
The Export / Import will give you instructions for creating any missing structures after which it will load the data and settings. Note: dbFront will only recreate database structures that it directly uses such as:
- Tables that it has access to,
- Columns and Types,
It is possible to use the export process as a database-agnostic backup for smaller databases but it will be slower than a regular database backup and it won't contain important database schema objects such as Views, Triggers or Stored Procedures.