Migrating from an existing PostgreSQL or MS SQL database to Azure or AWS SQL database

    If ADManager Plus and the MS SQL instance are running on different computers, download and install SQL Native Client, Command Line Utilities, and ODBC Driver on the computer on which ADManager Plus is running.

    SQL Server version Command Line Utilities (CmdLnUtils) File to be downloaded for CmdLnUtils Native Client (ncli) File to be downloaded for Native Client ODBC Driver (odbc) File to be downloaded for ODBC Driver
    2008 https://www.microsoft.com/en-in/download/details.aspx?id=44272 SqlCmdLnUtils.msi https://www.microsoft.com/en-in/download/details.aspx?id=44272 sqlncli.msi Not needed Not needed
    2012 64 bit: http://go.microsoft.com/fwlink/?LinkID=239650&clcid=0x40932 bit: http://go.microsoft.com/fwlink/?LinkID=239649&clcid=0x409 - https://www.microsoft.com/en-in/download/details.aspx?id=50402 sqlncli.msi Not needed Not needed
    2014 https://www.microsoft.com/en-US/download/details.aspx?id=53164 MsSqlCmdLnUtils.msi Not needed Not needed https://www.microsoft.com/en-in/download/details.aspx?id=36434 msodbcsql.msi
    2016 https://www.microsoft.com/en-us/download/details.aspx?id=56833 MsSqlCmdLnUtils.msi Not needed Not needed https://www.microsoft.com/en-us/download/details.aspx?id=56833 msodbcsql.msi
    2017 https://www.microsoft.com/en-us/download/details.aspx?id=53591 MsSqlCmdLnUtils.msi Not needed Not needed https://www.microsoft.com/en-us/download/details.aspx?id=53339 msodbcsql.msi
    2019 64 bit: https://go.microsoft.com/fwlink/?linkid=2230791
    32 bit: https://go.microsoft.com/fwlink/?linkid=2231320    		 - Not needed Not needed 64 bit: https://go.microsoft.com/fwlink/?linkid=2223304
    32 bit:https://go.microsoft.com/fwlink/?linkid=2223303    		 -

    Steps to migrate database

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

      4. 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 whether the connection is established successfully.
    7. Click Save.

    Don't see what you're looking for?

    •  

      Visit our community

      Post your questions in the forum.

       
    •  

      Request additional resources

      Send us your requirements.

       
    •  

      Need implementation assistance?

      Try OnboardPro

       
    Copyright © © 2020, ZOHO Corporation.All Rights Reserved.