the web front-end for your database

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.

Data Conversion

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.

Notes:

  1. Before migrating the settings you should first migrate the database structure changes.
  2. When migrating be sure to exclude  exporting or importing the data.

Options

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.

Content you want the user to see goes here.
close