Copying data to the staging database

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

Before you begin

Set the PATH environment variables

Procedure

  1. Open a command-line utility and go to the following directory:
    • LinuxAIXFor IBM i OS operating systemWC_installdir/bin
    • WindowsWC_installdir\bin
  2. Depending on your database, run one of the following commands:
    DB2
    • LinuxAIXFor IBM i OS operating system 
      
stagingcopy -scope _all_ -sourcedb 
production_database_name
   -destdb 
staging_database_name

      
stagingcopy.sh -scope _all_ -sourcedb production_database_name
   -destdb staging_database_name -sourcedb_user user -destdb_user user
    Oracle
    • AIX 
      
stagingcopy.sh -scope _all_ -sourcedb 
production_database_name 
   -destdb 
staging_database_name -dbtype oracle
   -sourcedb_user 
user_ID -sourcedb_passwd 
password
   -destdb_user 
user_ID -destdb_passwd 
password
    • Windows 
      
stagingcopy -scope _all_ -sourcedb 
production_database_name
  -destdb 
staging_database_name -dbtype oracle
  -sourcedb_user 
user_ID -sourcedb_passwd 
password
  -destdb_user 
user_ID -destdb_passwd 
password
  3. Examine the stagingcopy_ yyyy.mm.dd_hh.mm.ss.zzz.log file to ensure that the copy was successful.