To move your DBA system to a new server, perform the following steps:
Step 1 - You must have an installer that matches your current product build number
Do not attempt to perform a product update and server migration at the same time. Focus either on updating your program or installing a matching build version on your new server and migrating. A product update often has Admin tasks and issues to work through that should not be done at the same time as a server migration.
If your system is not on the latest product build, we recommend you install the latest product update on your old server if possible. Update on your existing server first and perform any and all Admin tasks associated with the update.
If you choose to migrate without updating your current system first, the installer version for the new server must match the build version of your software. Please contact DBA support and we can provide the installer to match your build version.
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.
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.
•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.
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.
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
▪Make sure the system database is restored using the system.fdb file name
▪Make sure your main company database is restored using the ejdb.fdb file name
•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.
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:.
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.