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.

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

      Migrating from an existing PostgreSQL/MS SQL database to an external PostgreSQL database
    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.
    Migrating from an existing PostgreSQL/MS SQL database to an external PostgreSQL database