...

Export Import Database

...

• 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.

Code Block
language bash theme RDark title Export data from source FlexDeploy database
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.

Code Block
language bash theme RDark title Import data in to target FlexDeploy database
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.

Code Block
language sql theme RDark title Fix materialized view
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;

At this point, FlexDeploy database is copied to target database.

...

Copy Artifact Repository, Plugins Folder, Application Binaries

Goal is to just copy the installation and artifact repository to target server. If artifacts and install is done under one common folder, then you can just create one tar for entire set of folders.

• Make backup Create tar/zip archive of artifact repository folder and application install folder using tar/zip commands on Source. FlexDeploy. For example,

...

• , application binaries, plugins folder etc. on Source server. If you have all folders under one root folder which can be copied then archive entire folder that contains artifact repository, application binaries, plugins folder.

-- tar/zip artifacts files, You can determine artifacts repository folder by looking at flexagon.fd.repository.root system property on server command line
cd /flexdeploy/artifacts
tar -czvf /app/backup/flexdeploy_artifacts.tar.gz *
-- tar/zip plugins folder, You can determine working folder by looking at flexagon.fd.application.root system property on server command line
cd /flexdeploy/application/plugins
tar -czvf /app/backup/flexdeploy_plugins.tar.gz *

• Copy tar file files to target FlexDeploy server and extract it in same location as source. If location is different, some files may need adjustment. (For example, setenv.sh)

-- extract artifacts files, You can determine artifacts repository folder by looking at flexagon.fd.repository.root system property on server command line
cd /flexdeploy/artifacts
rm -rf *
tar -xzvf /app/backup/flexdeploy_artifacts_prod.tar.gz
-- extract plugins folder, You can determine working folder by looking at flexagon.fd.application.root system property on server command line
cd /flexdeploy/application/plugins
rm -rf *
tar -xzvf /app/backup/flexdeploy_plugins.tar.gz

Final configuration and start server

...