Propagating data to the production database

To propagate data from the staging database to the production database:

  1. Configure the database.
  2. Change to the directory to which you want log files written.
  3. Type the following:
    • DB2
      • AIXi5/OSiSeriesSun Solaris Operating EnvironmentLinux
        stagingprop.sh -scope _all_ -sourcedb staging_database_name 
           -destdb production_database_name -sourcedb_user user -destdb_user user 
        
      • Windows
        stagingprop -scope _all_ -sourcedb staging_database_name -destdb 
          production_database_name
        
    • Oracle
      • 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
        
      • AIXSun Solaris Operating Environment
        • 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
          
      • Examine the stagingprop_yyyy.mm.dd_hh.mm.ss.zzz.log file.

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

If your staging server contains promotion data, see Propagating promotion data from a staging server to the production server.

Feedback