Export / Import
dbFront includes the ability to export your settings, basic schema and data from any database / version and then convert and import into any other database / version.
The Import / Export functionality is found under the Advanced Database Menu.
Migrating Settings into Production
The primary purpose is to permit you to migrate dbFront configuration from one environment to another. This could be used to migrate Development settings into Production.
- Before migrating the settings you should first migrate the database structure changes. NOTE: dbFront has a basic ability to detect and recreate missing database structures, but it is best to use your own server specific tools to migrate the database structure changes.
- When migrating the dbFront configuration be sure to exclude the exporting or importing of data.
One purpose is to allow you to migrate your database setup, structure and data to a different server type or role. For example you can migrate an 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 then a regular database backup and it won't contain all of the database schema information.
The Export optionally permits you to include or exclude the data so it can be used as a quick way to send someone the dbFront settings and database structure without sending the data.