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. Importing FDMEE Artifacts
  5. Preparing the Data Export/Import and Migration Utilities

Preparing the Data Export/Import and Migration Utilities

When you installed Oracle Hyperion Financial Data Quality Management, Enterprise Edition Release 11.2, utilities were installed in \EPM_ORACLE_HOME\products\FinancialDataQuality\database\migrate\Oracle (for Oracle database) and EPM_ORACLE_HOME\products\FinancialDataQuality\database\migrate\SQLServer (for SQL Server).

To prepare the utilities, in the Release 11.2 environment, copy files:

  • For Oracle Database:
    1. Copy aif_export.par from the Release 11.2 environment to a location accessible to the Oracle Data Pump location on the database server in the Release 11.1.2.4 environment.
    2. Copy aif_import.par to a location accessible to the Oracle Data Pump location on the database server in the Release 11.2 environment.
  • For SQL Server, copy aif_migrate.dtsx to the server where SQL Server Management Studio is installed.
  • For both Oracle Database and SQL Server, copy aif_post_import_updates.sql to your Release 11.2 database environment.