Migrating data from an existing PostgreSQL/Microsoft SQL database to the bundled PostgreSQL database

ADManager Plus supports the migration of data from external PostgreSQL databases or Microsoft SQL databases to the bundled PostgreSQL database through ADManager Plus' database setup wizard. Data can be migrated either between two different machines or within the same machine.

Steps to migrate data to the bundled PostgreSQL database within the same machine

1. Find the ADManager Plus build number by clicking the License button on the top-right corner.
2. Stop ADManager Plus.
3. Install a fresh instance of ADManager Plus of the same build after downloading it from here. If you want to migrate the data between bundled databases on different machines, follow this step, and then proceed.
4. Open the Command Prompt and enter <New ADManager Plus installation folder>\bin\startDB.bat to start the database of the new installation.
5. To initiate the migration of data in the old installation, enter <Old ADManager Plus installation folder>\bin\ChangeDB.bat in the Command Prompt. Make sure that the user running the Command Prompt is the user with full control of the ADManager Plus installation folder as well.
6. In the Database Setup Wizard pop-up that appears, select Bundled PostgreSQL Server as the Server Type.



7. Enter the required details as given below:
• Host Name: Enter the local host address, the machine hostname, or the IP address of the newly installed ADManager Plus build.
• Note: If the data migration is within the same machine, enter the local host name. Otherwise, enter the machine hostname or IP address in the Host Name field.
• Port: 33306
• Database Name: adsm
• User Name: admanager
• Password: admanager
8. Click Test Connection and check if the connection is established successfully.
9. Click Save.
10. Once the migration is completed successfully, you will get a window as shown here. Do not start the product immediately. Copy the customer-config.xml from the <Old ADManager Plus installation folder>/conf folder and replace the customer-config.xml in the <New ADManager Plus installation folder>/conf folder, and start the product.
11. If you are migrating the data from Microsoft SQL database and the parameters such as DBName, StartDBServer, and DSAdapter are available in the new instance's customer-config.xml file, remove these values from it as shown below.

<configuration name="DBName" value="mssql"/>

<configuration name="StartDBServer" value="false"/>

<configuration name="DSAdapter" value="mssql"/>

Data migration between two different machines

In a scenario where ADManager Plus has been installed on two different machines, before migrating the data from an existing bundled PostgreSQL database to another bundled PostgreSQL database, follow the steps given below to set up a remote connection between the source machine and the target machine (the machine to which data will be migrated) after step 3.

Enable remote connection in the PostgreSQL database server by making the following changes in the pg_hba.conf and postgresql.conf files located in <ADManager Plus installation folder>\pgsql\data. We recommend that you back up these files before modifying them.

• In the pg_hba.conf file, under the heading IPv4 local connections, replace the IP address 127.0.0.1/32 with all and save the file.
• In the postgresql.conf file, find this text: #listen_addresses = localhost. Replace it with listen_addresses = * and save the file.

Once completed, proceed with the remaining steps given above.