Show/Hide Toolbars

DBA Help

To move your DBA system to a new server, perform the following steps:

Step 1 - Update your system to the latest product build before migrating

If your system is not on the latest product build, we recommend you install the latest product update on your old server.    Update on your existing server first and perform any and all Admin tasks associated with the update.  

It is important that you do not combine a product update and server migration into a single process.  The installer version for the new server must match the build version of your software.  If you are unable to update to the latest DBA version on your old server, please contact DBA support and we can provide the installer to match your build version.

Links:

Tab Product Update Installation

Step 2 – Back up your databases, custom forms, and Email history

In this step you will back up your databases, custom form layouts, and Email attachments history.  It is not necessary to back up your entire DBA Manufacturing folder.

Databases

NOTE: Before you backup your databases, make sure that all users are logged out of DBA.  This can be verified through the Admin - Current Online Users screen.

Backup Methods:

Using the DBA Backup Manager (recommended) - Use the Manual Backup process within the Backup Manager utility to back up your Main Company and System databases.   You can choose the Use Custom Path option to copy your .fbk files to a location or device to later move them to your new server in Step 4 below.

Using Windows Copy File Function - Ensure that all users are out of DBA and make a copy of EJDB.FDB and SYSTEM.FDB files, normally located in the (drive letter)\Program Files (x86)\DBAManufacturing\Database.

Custom Form Layouts (*.rtm files)

Next, back up your custom form layouts (*.rtm files) in your Reports folder, which is normally located in (drive letter)\Program Files (x86)\DBA Manufacturing\Reports.

Email Attachments

Finally, back up your EmailAttach folder, which contains your customer and supplier Email attachments history.  It is normally located in (drive letter)\Program Files (x86)\DBA Manufacturing\EmailAttach.

Step 3 - Perform a new system installation on the new server

Perform a new system installation on the new server.   The DBA installer must match the build version of our old server system. You will not need a new registration key for this process.   The key is embedded in your database and will be activated when you restore your database to the new server in Step 4.

Link:

Tab New System Installation

Verify successful installation

Log into the Sample Company to verify that the program launches and new system installation was successful.  

Step 4 - Restore the backups made in step 2

In this step you will restore the files backed up in step 2 to the new server.  

Databases (ejdb.fdb and system.fdb)

Restore Databases Using the DBA Backup Manager

Use the Restore from Backup function in the DBA Backup Manager

Copy your main company and system database .fbk files created in Step 2 to a location on your new server.

Select the radio button for From specified path and point to your main company .fbk file and restore, followed by system database .fbk file and restore

Set Restore Location to (drive letter)\Program Files (x86)\DBA Manufacturing\Database

Restore Databases Using Windows Copy File Method

Restore the ejdb.fdb and system.fdb database files to the Database folder, which is normally located in (drive letter)\Program Files (x86)\DBA Manufacturing\Database.

Custom Form Layouts (*.rtm files)

Restore custom *.rtm files to the Reports folder, which is normally located in (drive letter)\Program Files (x86)\DBA Manufacturing\Reports.

Email Attachments

Restore Email attachments to the EmailAttach folder, which is normally located in (drive letter)\Program Files (x86)\DBA Manufacturing\EmailAttach.

Step 5 - Verify System  

Launch the DBA Main Company and verify that the system launches properly and your data was successfully restored.

Step 6 - Remove and re-install Client PCs

In this step you will do the following to each of the  Client PCs that are to have access to the new server.

First, remove the old DBA Client Installation program from the computer.

Next, connect the workstation PC to the new server by performing a new DBA Client Installation.  Click the link below for installation instructions:.

Link:

Tab Client Workstations Installation

To use your old server as a workstation:

If you wish to convert the old server into a workstation, you must first remove the DBA Manufacturing program from the computer, then you can perform the client installation process.