How do I migrate all of my dbFront work over to another server?

Question

I installed dbFront on my local computer and now I would like to transfer/move it and all my connection preferences to another server. How do I do this?

Answer 1

dbFront now has the ability to export the database settings to a file which can then be transferred to another server and imported.

The process to migrate your settings to a new server are shown below. The default folders are show in brackets.

a) Setup dbFront and check configuration.

1. Install dbFront on the new server and register it. (Automatic 30 day license to test and validate)
2. Compare dbFrontService.exe.config, compare old with new. (c:\program files(x86)\dbFront\dbFrontService.exe.config)
3. Compare web.config, compare old with new. (c:\inetpub\dbFront\web.config)

b) Copy Database Configuration

1. Create the database connections on the new server.
2. Export the settings from the old server. You will need to specify a database. See: Export/Import
3. Ensure that only the settings are being exported.
4. Import the settings at the new server. You will need to specify the destination database.

c) Copy Support Files

There are additional files that may also need to be moved.

• Excel Templates (c:\data\dbFront\Excel)
• Crystal Reports (c:\data\dbFront\CrystalReport)
• Quick Reports Templates (c:\data\dbFront\Reporting)
• Custom Icons or CSS files (possibly c:\inetpub\dbFront\, images\, css\)

For more details see: Export/Import