Migrate Triofox Database Using Triofox Migration Tool

Requirements before migration 

* Ensure you can connect to the Target Database from the Triofox Server with the corresponding database management tool. 

* Back up the Triofox Server.

* Back up the current database. 

* On Triofox server, backup the registries: 
HKEY_LOCAL_MACHINE\SOFTWARE\Gladinet\Enterprise
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Gladinet\Enterprise

The registries here contain the database connection information. If you want to restore the connection to the old one, please restore the two registries.

* Avoid having any users writing to the Triofox database during migration. 

The database being used by the current Triofox server can be found on the Cluster Control Panel >> Worker Nodes page.

In the latest Triofox, the database information is available in the "System Info".

Start

From the Triofox server, launch the browser and navigate to: http://localhost/management/migratedatabase.aspx

You should see the following screen: 

Select the Target Database (For this example, MySQL is selected from the Database dropdown)

Fill out the Target Database Configuration screen with the Database server information, then select Migrate. 

Note: The logging database can contain many records, elongating the migration time. 

If you wish to keep the File Changelogs, do not check the box. 

The following screen will appear if there are no issues with the provided information. 

Once the Migration is complete, you should see the following screen. 

VERIFY MIGRATION

-Authenticate as the Cluster Administrator after the migration is completed successfully. 

-After successfully authenticating, query the xaf_audit table from the database to see the cluster administrator's successful authentication record.