Database Migration

Using this option you can change the built-in database server (PostgreSQL) of AD360 to MS SQL Server or another instance of a PostgreSQL Server.

Important points to remember

Prerequisites

Steps to migrate database

  1. Log in to AD360 as an administrator.
  2. Navigate to Admin → General Settings → Database Settings → Database Configuration.
  3. Select AD360 under Component Name.
  4. From the Select Database Server menu, select the database server that you want to change to.
  5. If you select PostgreSQL Server, then:
  6. If you select MS SQL Server, then:
  7. Check the box against Migrate Existing Data to copy the data from your old database to the new database.

    IMPORTANT: Leave this box unchecked only if you want to change the database of a fresh installation of AD360 or its components.

  8. Click Save.