CentreStack Database Migration Tool

Requirements before migration 

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

* Back up the CentreStack Server.

* Back up the current database. 

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

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

Start

From the CentreStack 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 were 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 completes successfully. 

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