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
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1