This document describes how to migrate the BellaDati application server or database to a different system.

Application Server

To migrate only the application server without changing the database, follow the appropriate installation instructions to set up your new application server. Configure it to connect to your existing database. After starting the server and logging in, move the mouse over your username and click the link to your domain. On the left side, reindex your reports and data sets.

Database

To migrate BellaDati to a different database installation, backup the database contents using the PostgreSQL dump command:

pg_dump -U user -F c -v -f "path_to_dump/dump.backup" belladati_db

Copy the backup file to your new system and restore it in the target database:

pg_restore -v -c -O -d belladati_db -U user path_to_dump/dump.backup

Different Application Server and Database Server

To migrate both your database and application server:

  1. Migrate old database to new database as described above.
  2. Install a new application server following the appropriate installation instructions, using your new database.
  3. Delete the current indexes directory from the file system.
  4. Re-index your reports and data sets in the new installation.
  5. Restart BellaDati

Different Database Server

If you continue using your existing application server, configure it to use the new database.

Installer

If you used Windows installerMac installer or Linux Instlaller, follow the instructions below:

  1. Login to the administration console (by default running on 4848 or see Installing BellaDati on Payara).
  2. Open Resources->JDBC->Connection Pools and click on the connection pool you configured for BellaDati.
  3. On the right side, click Additional Properties.
  4. Update the ServerNameDatabaseNameUser and Password to match your new database and click Save.

Optionally, you can modify directly configuration file BELLADATI_INSTALLATION_DIRECTORY/glassfish4/glassfish/domains/domain1/config/domain.xml.

Standalone

If you used the BellaDati Standalone, update the application.properties file in your BellaDati installation directory and set new database connection parameters.

GlassFish

Use the GlassFish administration console as described in Installing BellaDati on Payara and follow the same process as installing BellaDati using installer.

Jetty

When running in a custom Jetty instance, you can find the configuration inside the WAR archive at the path WEB-INF/classes/conf/application.properties. Follow the instructions from Installing BellaDati on Jetty for detailed steps to update the configuration file.

Tomcat

Configure the BellaDati context defined in your Tomcat installation.

  1. Open the file conf/Catalina/localhost/belladati.xml.
  2. In the Resource tag, update the url, username and password to match your new database.
  3. Restart Tomcat.