Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Remote » Creating SQL Remote systems » Duplicate primary key errors » Using primary key pools

 

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