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:
- 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. - Copy
aif_import.par
to a location accessible to the Oracle Data Pump location on the database server in the Release 11.2 environment.
- Copy
- 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.