• How do I find out my Build number?
• 1 Log in to the ADAudit Plus web console, and click License in the top pane.
• 2 You will find the build number mentioned below the product version. This is the current build number of ADAudit Plus.
  
  

• How do I find my database type?
• 1 Log in to the ADAudit Plus web console, and click the Support tab.
• 2 On the Support Info tile, click More.
• 3 Under Basic Check, click the Machine Details drop-down to find your Database type specified at the bottom.
  
  

MySQL to PostgreSQL migration

ADAudit Plus supports PostgreSQL and MS SQL backends only, starting from build 7090. If you are using an ADAudit Plus build with MySQL backend, we recommend that you migrate to PostgreSQL before March 31, 2023.

If your build number is	Upgrade to Build Number
7000 to 7082	Proceed with the steps to migrate from MySQL to PostgreSQL
6000 to 6077	Download and upgrade to 7000
5100 to 5121	Download and upgrade to 6000
5000 to 5054	Download and upgrade to 5100
4640 to 4693	Download and upgrade to 5000
4600 to 4630	Download and upgrade to 4640
4500 to 4544	Download and upgrade to 4600

Steps to migrate from MySQL to PostgreSQL

1. Stop ADAudit Plus, go to the Start menu > Services > Right-click the ADAudit Plus service, and select Stop.
2. Download PostgreSQL and extract the downloaded file to <Installation_folder>\ManageEngine\ADAudit Plus.
   Note: Before downloading the file, ensure that the ADAudit Plus installation folder does not contain any folder named pgsql. If it does, rename the folder to something else, like pgsql_old, before downloading the PostgreSQL file.
3. Go to <Installation_folder>\ManageEngine\ADAudit Plus\bin, run the Command Prompt as administrator, and execute ChangeDB.bat.
4. In the Database Setup Wizard that pops up, fill in the following details, and click Save:
   • Beside Server Type, select PostgreSQL Server from the drop-down.
   • Beside Host Name, enter localhost.
   • Beside Port, change the port number to 33308.
   • Beside Database Name, enter ADAP or any other name of your choice.
   • Beside Migrate Data, select Yes or No, depending on whether you want to migrate the data or not.
   • Beside User Name, change the default username, 'adaudit', to any username of your choice.
   • Beside Password, enter a suitable password of your choice to connect to the PostgreSQL database.
   Note: This usually takes a few minutes, however, it might take a bit longer depending on the volume of data to be migrated from your MySQL database.

Please contact our technical support team at support@adauditplus.com for assistance with migration.