...

• Export data from source FlexDeploy database. You will be prompted to enter password for system user.
• This step will create fd_bkup.dmp file with all details from FD,FF and FD_ADMIN schemas. File should be in data pump directory, for example - C:\oraclexe\app\oracle\admin\XE\dpdump.
  • If your database is only used for FlexDeploy application, you may be able to perform backup and recovery operations using other Database tools.

expdp system directory=DATA_PUMP_DIR dumpfile=fd_bkup.dmp schemas=FD,FF,FD_ADMIN

• Copy fd_bkup.dmp file on to target FlexDeploy database server in to data pump directory, for example - C:\oraclexe\app\oracle\admin\XE\dpdump.
• Import data in to target FlexDeploy database.
• You will be prompted to enter password for system user. You must delete FD,FF,FD_ADMIN users from target database environment before starting import process.
• Make sure there are no errors in import process. If there are errors, make corrections appropriately and restart import process.

...

...

• Import data in to target FlexDeploy

...

impdp system directory=DATA_PUMP_DIR dumpfile=fd_bkup.dmp schemas=FD,FF,FD_ADMIN

• Import will fail to create Materialized view. You need to follow these steps to fix it.

DROP table FD.VAPPLICATIONSTATISTICS;

-- find CREATE MATERIALIZED VIEW FD.VAPPLICATIONSTATISTICS from FDOracleGenerateProcedures.sql and execute it.
-- now grant permissions

grant SELECT on FD.VAPPLICATIONSTATISTICS to FD_ADMIN;

...

• database.

Copy Artifact Repository and Application Binaries

...