Copying data to the staging database

To copy data from the production database to the staging WebSphere Commerce EnterpriseWebSphere Commerce Professionalor authoring database:

Before you begin

Set the PATH environment variables

Procedure

  1. Open a command-line utility and go to the following directory:
    • SolarisLinuxAIXFor IBM i OS operating systemWC_installdir/bin
    • WindowsWC_installdir\bin
  2. Depending on your database, run one of the following commands:
    DB2
    • SolarisLinuxAIXFor 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
    • SolarisAIX
      
      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.