Migrating from an existing PostgreSQL/Microsoft SQL database to an external database (Azure, AWS, or external PostgreSQL database)

Note: Supported for external PostgreSQL versions 14 and 15.

1. Stop ADManager Plus.
2. Invoke <ADManager Plus installation folder>\bin\ChangeDB.bat in the Command Prompt. Make sure that the same user running the Command Prompt is running ADManager Plus.
3. In the Database Setup Wizard pop-up that appears, select External PostgreSQL Server as the Server Type.

Note: If you are adding Azure PostgreSQL, follow the steps here to enable the extensions.



4. Enter the required details such as Host Name, Database Name, User Name, and Password.
5. For cloud instance databases, ensure that the database has already been created before initiating migration.
6. Click Test Connection and check if the connection is established successfully.
7. Click Save.

Steps to enable extensions in Azure

For Azure PostgreSQL, you need to enable the mandatory extensions in the Azure database. Follow the steps below to enable them.

1. Open the Azure portal and navigate to the Azure Database for PostgreSQL flexible servers.
2. On the sidebar, click Server Parameters.
3. Search for the azure.extensions parameter.
4. From the drop-down, select the CITEXT and PGCRYPTO extensions.