Resolution:

1) Unbind all Management Daemons (no need to uninstall nodes to do that).

2) Stop each Admin server instance.

3) Copy all tables, constaints, rules, defaults from one database to another.

   (even in AMSG 2.1, this is a manual step; our software will not do this automatically)

   4) Modify following administrator xml file on each and every Admin server instance:

     4.1) Run &lttibco-home>\amxadministrator\2.0\bin\passwordobfuscator.exe -p &ltnew-database-user> &ltnew-database-password>

          The output is an encrypted password that you must use in the "password" attribute in the XML in

          the step below.



     4.2) Edit &lttibco-home>\amxadministrator\data\&ltamx>\&ltadmin>\config\server-config.xml

          Update the DB parameters in this section of the XML:

-------------

   &ltconfiguration-persistence use="db">

      &ltpersistence type="file"/>

      &ltpersistence type="db">

         &ltproperty name="driver" value="org.hsqldb.jdbcDriver"/>

         &ltproperty name="url" value="jdbc:hsqldb:hsql://SAPTE-DT2:1234/amx"/>

         &ltproperty name="user" value="sa"/>

         &ltproperty name="password" value="/HXP429XtI0="/>

         &ltproperty name="mask" value="true"/>

         &ltproperty name="algo-name" value="BlowFish"/>

         &ltproperty name="maxConnections" value="5"/>

         &ltproperty name="loginTimeout" value="30000"/>

         &ltproperty name="tablename" value="amxadm_amx_hsql"/>

      </persistence>

   </configuration-persistence>

--------------



          

5) Modify following administrator xml file on any one (but only one) Admin server instance.

   This step is only applicable if you are using Database Realm pointing to the database that needs

   to be moved.



     5.1) Run &lttibco-home>\amxadministrator\2.0\bin\passwordobfuscator.exe &ltnew-database-password>

          The output is an encrypted password that you must use in the "password" attribute in the XML in

          the step below.

          Note that the arguments to passwordobfuscator are different than step 4.1.



     5.2) Edit &lttibco-home>\amxadministrator\data\&ltamx>\&ltadmin>\config\security-config.xml

          Update the DB parameters in this section of the XML:



   &ltrealm>

      &ltrealm-name&gtsystem</realm-name>

      &ltuser-manager>

         &ltinit-options>

            &ltentry>

               &ltname&gturl</name>

               &ltvalue&gtjdbc:hsqldb:hsql://SAPTE-DT2:1234/amx</value>

            </entry>

            .....

            .....

      </user-manager>

   </realm>

   &ltlogin-module-configuration>

       &ltrealm-name&gtsystem</realm-name>

       &ltconfig-entry>

            &ltoptions>

               &ltentry>

                  &ltname&gthibernate.connection.url</name>

                  &ltvalue&gtjdbc:hsqldb:hsql://SAPTE-DT2:1234/amx</value>

               </entry>

               .....

               .....

            </options>

       </config-entry>

   </login-module-configuration>



5.3) Run &lttibco-home>\amxadministrator\2.0\bin\amx_admin.bat -uploadconfig
        Running with '-uploadconfig' parameter is needed only one time.




6) Modify following xml file on each and every AMX Node that was installed:

     6.1) Run &lttibco-home>\amxadministrator\2.0\bin\passwordobfuscator.exe -p &ltnew-database-user> &ltnew-database-password>

          The output is an encrypted password that you must use in the "password" attribute in the XML in

          the step below.



     6.2) Edit &lttibco-home>\amx\data\&ltenvironment>\&ltnode>\config\server-config.xml

          Update the DB parameters in this section of the XML:

-------------

   &ltconfiguration-persistence use="db">

      &ltpersistence type="file"/>

      &ltpersistence type="db">

         &ltproperty name="driver" value="org.hsqldb.jdbcDriver"/>

         &ltproperty name="url" value="jdbc:hsqldb:hsql://SAPTE-DT2:1234/amx"/>

         &ltproperty name="user" value="sa"/>

         &ltproperty name="password" value="/HXP429XtI0="/>

         &ltproperty name="mask" value="true"/>

         &ltproperty name="algo-name" value="BlowFish"/>

         &ltproperty name="maxConnections" value="5"/>

         &ltproperty name="loginTimeout" value="30000"/>

         &ltproperty name="tablename" value="amxadm_amx_hsql"/>

      </persistence>

   </configuration-persistence>

--------------



7) Restart Admin servers and AMX nodes.

   Discover and rebind all the MDs. Rebind will push new DB parameters from Admin

   to all the MDs.