There are two types of data, configuration and operation.
- Configuration tables
Configuration tables contain data such as stores, catalogs, catalog entries, languages, taxes, and discounts. These tables are under Site Administrator control; an individual customer cannot modify these tables.
- Operation tables
Operation tables contain data such as customer information, address, and orders data. Customers can modify operation tables.
The staging server manages only configuration tables. Data in operation tables are not propagated or copied between the staging and production databases.
It is important to ensure that tables managed by the staging server do not contain any foreign key references to operation tables. Otherwise, the propagation could fail due to a potential primary key deletion from the production database. Before you use the staging server, you should ensure that only the organization owns the operational data, not the individual user, such as a catalog administrator.