Copy data to the staging database

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

1. Set the PATH environment variables.

2. Change to the directory to which you want log files written.

3. Depending on your database, issue one of the following commands:

   (DB2)

   • AIX|Linux|Solaris|I5/OS|

     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)

   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
     
     
     

4. Examine the stagingcopy_ yyyy.mm.dd_hh.mm.ss.zzz.log file to ensure that the copy was successful.

 

Related Concepts

Staging server
Authoring server

 

Related tasks

Configure databases for use with the staging utilities
Synchronizing an authoring server with a production server
Start and stop WebSphere Commerce

 

Related Reference

stagingcopy utility