Page Comparison

...

• Take backup of artifact repository folder using tar/zip commands on Production FlexDeploy server. For example,
  • cd /flexdeploy/artifacts
  • tar -czvf /app/backup/flexdeploy_artifacts_prod.tar.gz *

• Take backup of plugins folder using tar/zip commands on Production FlexDeploy server. Plugins folder is under server working directory. You can determine working folder by looking at flexagon.fd.application.root system property on server command line. For example,

  • cd /flexdeploy/application/plugins

  • tar -czvf /app/backup/flexdeploy_plugins.tar.gz *

• Make sure Test FlexDeploy is now stopped for import process.
• Import data in to target FlexDeploy database. Make sure to run this on Test environment only.

  • Run the following sql command for the appropriate database that will generate many drop table, view and procedure statements as output.  Once this sql is complete, copy all of the output and execute that against the test database.  This method will drop all of the data but maintain table spaces, quotas and passwords for the given schemas.  This will also maintain the same password that is stored in the context.xml file.

    Code Block
    language sql theme RDark title Oracle DB: Drop tables, views and procedures without dropping user
    select 'drop table ' || owner ||'.' || table_name || ' cascade constraints PURGE;' from dba_tables where owner in ('FD','FD_ADMIN','FF') union all select 'drop view ' || owner || '.' || view_name || ';' from dba_views where owner in ('FD','FD_ADMIN','FF') union all select 'drop procedure ' || owner || '.' || object_name || ';' from dba_objects where owner in ('FD','FD_ADMIN','FF') and object_type = 'PROCEDURE';

    
    

    Code Block
    title PostgreSQL DB: Drop tables, views and procedures without dropping user
    select 'drop table ' || table_schema ||'.' || table_name || ' cascade ;' from information_schema.tables where upper(table_schema) in ('FD','FD_ADMIN','FF') and table_type = 'BASE TABLE' union all select 'drop view ' || table_schema ||'.' || table_name || ' cascade ;' from information_schema.tables where upper(table_schema) in ('FD','FD_ADMIN','FF') and table_type = 'VIEW'

    
    

  • Make sure there are no errors in import process. If there are errors, make corrections appropriately and restart import process.

...