1. Installation and Configuration Guide
  2. Upgrading EPM System (from 11.2.12+ to 11.2.15) using Out of Place Procedure
  3. Importing Artifacts and Data for Release 11.2.15
  4. Importing Financial Management Applications
  5. Restoring the Financial Management Schema (SQL Server)

Restoring the Financial Management Schema (SQL Server)

To restore the backup of Oracle Hyperion Financial Management schema to the target environment, perform the following steps:

  1. In the Target database server (11.2.15), launch SQL Server Management Studio.

  2. In the left pane, right-click on Database and select Restore Database.

  3. Navigate to the HFM database backup file (.bak) that was copied in step 4. Click OK.

  4. On the Restore Database screen, click OK. A confirmation message stating that the database has been restored will appear.

  5. In order to comply with the target database schema naming convention, rename the restored HFM schema (if required).