1. Installation and Configuration Guide
  2. Upgrading EPM System (from 11.1.2.4 to 11.2.8)
  3. Importing Artifacts and Data for Release 11.2
  4. Migrating Financial Close Management Artifacts
  5. Tasks in the Release 11.1.2.4_253+ Source Environment
  6. Copying the Financial Close Management Schema (SQL Server)

Copying the Financial Close Management Schema (SQL Server)

Perform the following steps on the Release 11.2 SQL Server environment to make a copy of the Oracle Hyperion Financial Close Management Release 11.1.2.4_253+ schema on the Release 11.2 database environment..

  1. Launch SQL Server Management Studio.

  2. Right-click the Financial Close Management source database and select Tasks and then select Copy Database.

    Create a SQL Server connection to the source database if it's not already created in SQL Server Management Studio.

  3. In the Copy Database Wizard, click Next on the Welcome screen.

  4. In Select a Source Server, for Source Server, enter the name of the source database server, use SQL Server Authentication, enter your sysadmin user name and password, and then click Next.

  5. In Select a Destination Server, for Destination Server, enter the name of the destination database server, use SQL Server Authentication, enter your sysadmin user name and password, and then click Next.

  6. In Select the Transfer Method, select Use the SQL Management Object method and then click Next.

  7. In Select Database, select the Financial Close Management source database and then click Next.

  8. In Configure Destination Database, enter a name for the destination database, such as fcm_target, and then click Next.

  9. In Select Server Objects, keep the default selections and then click Next.

  10. In Configure the Package, enter a name, such as fcm_source_to_fcm_target, and then click Next.

  11. In Schedule the Package, click Next to run immediately.
  12. Click Finish to run the wizard.

    When the wizard completes, there is a copy of the source database with the name you provided, such as fcm_target , on the destination database server.

  13. Shut down Oracle Enterprise Performance Management System servers and then execute the following database change in fcm_target:
    DELETE FROM PS_TXN
  14. Restart EPM System servers.