Copying data to the staging database
To copy data from the production database to the staging or authoring database:
Procedure
- Open a command shell in the Utilities Docker container.
-
Run the following command.
- ./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
- ./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
-
Examine the
stagingcopy_ yyyy.mm.dd_hh.mm.ss.zzz.log
file to ensure that the copy was successful.