Copy data from production database to staging database

Administer > Stage server > Test the site on a staging server

Copy data from production database to staging database

Procedure
Set the PATH environment variables

Change to the directory to which you want log files written.
Depending on the database, issue one of the following commands:
stagingcopy.sh -scope _all_ 
             -sourcedb dbprod
             -destdb dbstage 
             -sourcedb_user user 
             -destdb_user user

stagingcopy.sh -scope _all_ 
             -sourcedb dbprod 
             -destdb dbstage -dbtype oracle
             -sourcedb_user user_ID 
             -sourcedb_passwd password
             -destdb_user user_ID 
             -destdb_passwd password
Examine the stagingcopy_ yyyy.mm.dd_hh.mm.ss.zzz.log file to ensure that the copy was successful.
Related concepts

Stage server
Author server

Related tasks

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

Related reference

stagingcopy utility

+
Search Tips | Advanced Search