<%@ page isELIgnored="true" %> <%@ taglib uri="cms" prefix="cms" %> Moving the AnthillPro Database

Moving the AnthillPro Database

Before you begin, make sure you back up your existing database. Once that is done, you can then clone the database to the new location (it is recommended to retain the original database until you are sure the move was successful).

Before you begin, make sure you have:

  • The ability to start and stop the production AnthillPro instance.

  • Access to the AnthillPro server \conf directory.

  • Access to the AnthillPro production database.

To move the AnthillPro database:

  1. Shutdown the AnthillPro production server.

  2. Clone the AnthillPro database and install the clone in the desired location. The procedure varies depending on the underlying database. Your database vendor should have documentation on cloning.

  3. Go to the AnthillPro server and open the installed.properties file located in the \conf\server directory.

    • The install.db.url=jdbc\: property must be changed to point to the new database location. For example, install.db.url=jdbc\:yourdatabasetype\://localhost\:11366/data.

      Note that the property for each database type is different and may have a different pattern. If need be, check with your database administrator.

    • Save change.

  4. Open the base.xml file located in the \conf\spring-server directory. Modify two properties to point to the new database location:

    • Under <!-- DataSource used for persistence -->, modify the 'url' property:

      <property name="url">
  <value>jdbc:yourdatabase://localhost:11366/data</value>
</property>

    • Under <!-- DataSource used for identity generation so it does not create deadlocks -->, modify the 'url' property:

      <property name="url">
  <value>jdbc:yourdatabase://localhost:11366/data</value>
</property>

    • Save changes.

  5. Start the Server.