MySQL/MS SQL to PostgreSQL migration
ADAudit Plus allows administrators to store and retrieve Windows servers' audit log data from MySQL, MS SQL, or PostgreSQL databases. To move the DB and/or data from MySQL/MS SQL to PostgreSQL, follow the steps found below.
- Stop ADAudit Plus, go to the Start menu > Services > Right-click the ADAudit Plus service, and select Stop.
- Download PostgreSQL and extract the downloaded file to <Installation_folder>\ManageEngine\ADAudit Plus.
Note: Before downloading the file, please ensure that the ADAudit Plus installation folder does not contain any folder named pgsql. If it does, please rename the folder to something else, like pgsql_old, before downloading the PostgreSQL file.
- Go to <Installation-folder>\ManageEngine\ADAudit Plus\bin, open an elevated Command Prompt (right-click Command Prompt and select Run as administrator), and execute ChangeDB.bat.
- In the Database Setup Wizard that pops up, fill in the following details, and click Save:
- Beside Server Type, select PostgreSQL from the drop-down.
- Beside Host name, enter localhost.
- Beside Port, enter 33307 or 33308. If you are migrating from MS SQL, the port number is 33307, and if you are migrating from MySQL, the port number is 33308.
- Beside Database, 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 and Password, enter a user name and password of your choice.
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/MS SQL database.
