In this article  :

• Objective

• Prerequisites

• Steps to follow

• Validation and confirmation

• Tips

• Related topics and articles

Objective  

This article explains how to migrate the ADAudit Plus back-end database from MySQL or Microsoft SQL to PostgreSQL, and how to convert archived data formats to ensure compatibility with the new database.

Prerequisites  

• ADAudit Plus must be installed and accessible.

• You must have administrative rights to stop services, run scripts, and modify configurations.

• A full backup of the ADAudit Plus installation folder is highly recommended.

• Ensure that the <Installation_Folder>\ManageEngine\ADAudit Plus directory does not contain a folder named pgsql. If it does, rename it to pgsql_old before proceeding.

• Download the required PostgreSQL version (10.21) from this link:
  Download PostgreSQL 10.21

Steps to follow  

1. Open Services from the Start menu, right-click ManageEngine ADAudit Plus, and select Stop.

2. Extract the downloaded pgsql_10.21.zip file to the <Installation_Folder>\ManageEngine\ADAudit Plus directory.

3. Navigate to <Installation_Folder>\ManageEngine\ADAudit Plus\bin, open Command Prompt as an administrator, and run:

1. ChangeDB.bat

4. In the Database Setup Wizard:

• Set Server Type to PostgreSQL.

• Set Host name as localhost.

• Set Port:

• Use 33307 if migrating from Microsoft SQL.

• Use 33308 if migrating from MySQL.

• Set Database as ADAP (or a custom name).

• Set Migrate Data to Yes (if you wish to migrate existing data) or No.

• Set User Name and Password (custom credentials for PostgreSQL).

Click Save to apply the changes. The migration may take a few minutes depending on the volume of data.

Validation and confirmation  

After migration:

• Start the ADAudit Plus service again.

• Log in to the web console and verify whether data appears as expected.

• Check if reports and configurations are intact.

If data was not migrated, verify using the database tools whether new tables were created in the PostgreSQL instance.

Tips  

Converting archived files  

If you’ve archived data under the old database, you must convert the format to be compatible with PostgreSQL.

1. Go to <Installation_Folder>\ManageEngine\ADAudit Plus\archive.

2. Create a new folder (e.g., tableBackup_new).

3. Open Command Prompt as an administrator and navigate to the bin directory.

4. Run the following command:

5. ChangeArchive2BCPSupport <Archive_Directory> <New_Directory> <Old_DB> <New_DB>

Example:

ChangeArchive2BCPSupport C:\ManageEngine\ADAudit Plus\archive\tableBackup C:\ManageEngine\ADAudit Plus\archive\tableBackup_new mysql postgres

6. Move the original archived files (tableBackup) to a backup location.

7. Copy the new files from tableBackup_new into the original archive folder.

Related topics and articles  

• MySQL or Microsoft SQL to PostgreSQL migration