Replicate the primary key pool

You can either incorporate the primary key pool into an existing publication or share it as a separate publication. Use the following procedure to create a separate publication for the primary key pool and subscribe users to it.

To replicate the primary key pool (SQL)
  1. On the consolidated database, create a publication for the primary key pool data.

    CREATE PUBLICATION KeyPoolData (
       TABLE KeyPool SUBSCRIBE BY location
    );
  2. Create subscriptions for each remote database to the KeyPoolData publication.

    CREATE SUBSCRIPTION
      TO KeyPoolData( 'user1' )
      FOR user1;
    CREATE SUBSCRIPTION
      TO KeyPoolData( 'user2' )
      FOR user2;
    ...

    The subscription argument is the location identifier.

See also