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