Migrating full database, on-premises to on-premises

  1. In EPM Administration select Dashboards > OLAP > Databases. Select the target database and click the Stop icon.
    The database is saved and a metadata.json file is generated. Optionally select Dashboards > OLAP > Save and Backup to make a backup of the database.
  2. Run Service Expert, click the Directories tab and locate the target central database file. Make a note of the location.
  3. In EPM Administration select Dashboards > OLAP > Databases and make a note of the target database Save Version number.
  4. Repeat steps 2 and 3 for the source database.
  5. Create a copy of the source OLAP database files from the directory location that is displayed in the Service Expert.
  6. Create a .zip file of the copied source OLAP database files. Do not include the metadata.json file in the .zip file.
  7. Copy the .zip file and paste it into the target database file storage. Extract the .zip file.
  8. In EPM Administration select Dashboards > OLAP > Databases. Select the target database and click the Start icon.
  9. Optionally, check if the database is in a corrupted state. Select Dashboards > OLAP > Databases Troubleshooting. If the database is corrupted, it has a Wrench icon against it. Click the Wrench icon to start repair.
  10. Optionally, confirm that the OLAP database files are loaded correctly. Select Dashboards > OLAP > Edit Database. Check if all cubes and dimensions are visible.