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

Publish data to the production database

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

Before you begin

Set the PATH environment variables.

Procedure

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

2. Issue one of the following commands:
   

   • stagingprop.sh -scope _all_ -sourcedb 
     dbstage 
        -destdb 
     dbprod -sourcedb_user 
     user -destdb_user 
     user 
     

   • stagingprop -scope _all_ -sourcedb 
     dbstage
        -destdb 
     dbprod
     

   
   

   • stagingprop.sh -scope _all_ -sourcedb dbstage
        -destdb 
     dbprod dbtype oracle
        -sourcedb_user 
     user -sourcedb_passwd 
     password
        -destdb_user 
     user -destdb_passwd 
     password
     

   •  stagingprop -scope _all_ -sourcedb 
     dbstage 
       -destdb 
     dbprod -dbtype oracle 
       -sourcedb_user  
     user -sourcedb_passwd 
     password
       -destdb_user 
     user -destdb_passwd 
     password
     

3. Examine the stagingprop_ yyyy.mm.dd_hh.mm.ss.zzz.log file.

Results

For further information about publishing data to the production database, see Examples of propagating data to the production database.

If the staging server contains either Web activities, or content spots, refresh the registry before any updates display on the site.

Related concepts

Stage server

Related tasks

Update registry components

Filter data published using the stagingprop utility

Related reference

stagingprop utility

+

Search Tips   |   Advanced Search