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.
On the consolidated database, create a publication for the primary key pool data.
CREATE PUBLICATION KeyPoolData ( TABLE KeyPool SUBSCRIBE BY location ); |
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.
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |