Noteworthy

• The two data values "" (empty string) and null (data missing / not present) are considered different, not equal.

• The source and target systems should be of the same SICS product type. Comparison of a pure P&C system with a Life or combined system may cause the Configuration Manager to report differences that, although the CM will allow it, should NOT be copied from one system to the other.

• Generating SQL for category 4 means creating DELETE statements. Item deletion should be done with care. Other parts of the SICS database, not covered by the configuration manager, may contain references to the items selected for deletion. Item deletion may lead to “dangling pointers” (if the deleted row was actually referenced from some other table) and/or constraint errors.