Publishing data to the production database

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

1. Set the PATH environment variables.

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

3. Issue one of the following commands:

   (DB2)

   • AIX|Linux|Solaris|Windows:

     stagingprop.sh -scope _all_ -sourcedb 
     staging_database_name 
        -destdb 
     production_database_name -sourcedb_user 
     user -destdb_user 
     user 
     
     
     

   • I5/OS:

     stagingprop -scope _all_ -sourcedb 
     staging_database_name
        -destdb 
     production_database_name
     
     
     

   (Oracle)

   • AIX|Solaris|

     stagingprop.sh -scope _all_ -sourcedb staging_database_name
        -destdb 
     production_database_name dbtype oracle
        -sourcedb_user 
     user -sourcedb_passwd 
     password
        -destdb_user 
     user -destdb_passwd 
     password
     
     
     

   • Windows:

     stagingprop -scope _all_ -sourcedb 
     staging_database_name 
       -destdb 
     production_database_name -dbtype oracle 
       -sourcedb_user  
     user -sourcedb_passwd 
     password
       -destdb_user 
     user -destdb_passwd 
     password
     
     
     

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

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

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

 

Related Concepts

Staging server

 

Related tasks

Updating registry components
Filtering data published using the stagingprop utility

 

Related Reference

stagingprop utility