How the CDT handles foreign key checks

The CDT enforces data consistency by deploying all related tables that define an entity together in one operation.

In addition, to ensure data integrity, the CDT also checks the required foreign key constraints for each table - which could potentially be defined for a table in a completely different group. Therefore, when deploying a small subset of data, it is possible that you may see error messages indicating foreign key constraint violations if the corresponding data in the independent table is not being deployed in the same operation. In this case, you should try deploying a bigger set of data. Note that foreign key constraints are not defined or checked for custom tables.

To provide the best performance, foreign key constraints are not checked when deploying the complete Sterling Order Management System Software configuration.