How to change IP address when migrating existing SQL Database

Version 4

    How to change IP address when migrating existing SQL Database


    Environment

    Wavelink Avalanche AMC 5.0, 5.2 &5.3

    MSSQL 2005, 2008

     

    Questions

    How to change IP address when migrating existing SQL Database

     

    Response

    The IP address of the SQL Server needs to be changed in the dao-factory files that are zipped up in AvalancheSupport.jar.

     

    All three XML config files need to be updated.

    1. dao-factory.xml

    2. dao-factory-ss.xml

    3. dao-factory-ss-es.xml

     

    After the JAR file has been repacked it will need to be copied to the [Tomcat Home]\lib folder so the web console will have the same database credentials.

     

    Below is the default path:

     

    C:\Program Files\Wavelink\AvalancheMC\lib\avalanchesupport.jar

     

    Below is an example of my dao-factory-ss-es.xml file and you will need to change the IP on the Value line:

     

    daofactory.png

     

       *********Remember that after the JAR file has been repacked it will need to be copied to the [Tomcat Home]\lib folder so the web console will have the same database credentials. And you need this if you use the Web Console.