REPLICATION OF IDENTITY-DERIVED PRIMARY KEYS WITHOUT RANGE RESTRICTIONS

This disclosure provides an apparatus and method for replication of identity-derived primary keys without range restrictions, including but not limited to in industrial control systems and other systems. A method includes maintaining, by a publisher system, a data table associated with a primary key PK-i. The method includes adding, by the publisher system, a unique value PK-g associated with every record of the data table. The method includes defining, by the publisher system, a primary key PK based on PK-i and PK-g. The method includes publishing the data table, including the primary key PK, by the publisher system, to at least one subscriber system.