Publishing data to the production database

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

Procedure

  1. Use the staging propagation (stagingprop) utility to publish data from the staging or authoring database to the production database:
    • stagingprop.sh
    For more information, see Examples of propagating data to the production database.
  2. If you are publishing a store at the staging environment, complete the following steps to insert the necessary access control policy group records into the Production database.
    1. Get the orgentity_id that owns the store by finding the member_id.
      SELECT member_id from storeent where identifier = 'storeIdentifier';
      Where storeIdentifier is the identifier for your store, such as Aurora. This identifier is stored in the IDENTIFIER column of the STOREENT database table.
    2. Use the member_id to get the access control policy group IDs that your organization subscribes to in staging database.
      SELECT acpolgrp_id from acplgpsubs where orgentity_id = member_id_from_above;
    3. For each row that is returned in 2.b, complete the following INSERT into the production database.
      INSERT into acplgpsubs (orgentity_id, acpolgrp_id) values (member_id_from_above, acpolgrp_id_from_above); 
    Note: You must also manually insert any custom policies.
  3. Optional: If you published marketing activities, update the marketing registry.
    • Provide database triggers that you can add to automatically update the marketing registry (CampaignInitiativeCache) after you run the stagingprop command.
  4. Optional: If you published promotions data, update the promotions registry.
    • Provide database triggers that you can add to automatically update the promotions registries (PromotionRegistry, PromotionPolicyRegistry, and PromotionGroupRegistry) after you run the staging propagation utility command.