The stagingcopy utility and the production database
The stagingcopy utility ensures that the production and staging databases are synchronized. After the stagingcopy utility runs successfully, do not update the database tables that are managed by the staging environment to the production database. Instead, update these tables in the staging environment and then propagate the changes to the production database using the stagingprop utility. Updating staging environment-managed tables on the production database will likely fail because of a potential key conflict or reference integrity violation. To update the staging environment-managed tables in the production environment database, use the stagingcopy utility to synchronize the staging and production databases.
To ensure that the staging-enabled tables are never updated on the production database, the tables must be under the control of a Site Administrator only. In some cases, the staging-enabled tables in your production database are updated by an individual customer or merchant after the data was copied by stagingcopy. For example, you cannot prohibit a merchant from modifying the OFFER table in the production database after copying to the production database. In this situation, the OFFER table cannot be managed by the staging environment.
After the data is copied from the production database to the authoring database, you must run a full index build on the authoring environment. For more information, see Building the HCL Commerce Search index.