Copying data to the staging database

To copy data from the production database to the staging or authoring database:

Procedure

  1. Open a command shell in the Utilities Docker container.
  2. Run the following command.
    • DB2./stagingcopy.sh -scope _all_ -sourcedb production_database_name -sourcedb_user user -sourcedb_passwd password -destdb staging_database_name -destdb_user user -destdb_passwd password -dbtype db2
    • Oracle./stagingcopy.sh -scope _all_ -sourcedb production_database_name -sourcedb_user user -sourcedb_passwd password -destdb staging_database_name -destdb_user user -destdb_passwd password -dbtype oracle
  3. Examine the stagingcopy_ yyyy.mm.dd_hh.mm.ss.zzz.log file to ensure that the copy was successful.