Move Ajera databases to a new server

There are many reasons to move your Ajera databases to a new server. For example, when you purchase a new server, reorganize your network structure, or move SQL to a different drive on the same server. Moving Ajera is a simple process of creating, copying, and restoring database backups.

Before you begin

• Regardless of which version of Ajera you use, the steps to move Ajera to a new server are exactly the same. The installation routine verifies your current version and installs that version to the new server.
• Verify that you are set up with the Administrator role in your original Ajera database.

To move Ajera to a new server

1. Log into the Ajera database you want to move.
2. Back up each database to the \Ajera\Backups folder on your Ajera server.

When you create a backup file, name the file so that it indicates which company you are backing up (for example, MainCompany.BAK, 2_Company2.BAK, and 3_Company3.BAK).

When you back up your data, the Database Backup window lists only the data for the Ajera database you are currently logged into.

3. Using Windows Explorer, copy your \Ajera\Backups folder to a secure location where you can access it from both the current and new servers.
   

4. Install Ajera onto the new server.
5. After completing the installation, copy your Backups subfolder back to their appropriate locations.
6. Log into the new Ajera database using the administrator login ID and password.
7. Recreate your current database structure on your new server. Refer to Step 1 - Create a new database for more information.

8. Restore the database backups you copied to the new server.
9. Repeat the above steps to restore each additional databases.