Restoring the Financial Close Management Schema (SQL Server)

To restore the backup of Oracle Hyperion Financial Close Management schema in 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 FCM 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 FCM schema (if required).