Export / Import
dbFront now includes the ability to export your settings 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.
You can use this as a database agnostic backup but it will be slower then a regular database backup and it won't contain all of the details and structures.
Note: This functionality is not intended for full data backups of datasets measuring more then 2 gig. If your dataset is larger then you will need to exclude the 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.
Migrating Settings into Production
A second purpose is to permit you to migrate dbFront settings 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.
- When migrating be sure to exclude exporting or importing the data.
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.