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


Related concepts
Staging environment
Authoring environment


Related tasks
Configure databases for use with the staging utilities


Related reference
stagingcopy utility