You subscribe a user to a publication by creating a subscription. Each database that shares information in a publication must have a subscription to the publication.
Periodically, the changes made to each publication in a database are replicated to all subscribers of that publication. These replications are called publication updates.
Subscribe to a publicationTo subscribe a user to a publication, you need the following information:
Publication name The name of the publication to which the user is being subscribed.
Subscription value The subscription value only applies if your publication includes a SUBSCRIBE BY clause. The subscription value is the value that is tested against the SUBSCRIBE BY clause of the publication. For example, if a publication has the name of a column containing an employee ID as a SUBSCRIBE BY clause, the value of the employee ID of the subscribing user must be provided when the subscription is created. The subscription value is always a string.
This value is only needed when the publication has a SUBSCRIBE BY clause.
Subscriber-id The user who is being subscribed to the publication. At the consolidated database, when you create a subscription to a remote user, the remote user must have been granted REMOTE permission. At the remote database, when you create a subscription to the consolidated user, that user must have been granted CONSOLIDATED permission. By default, the Extraction utility (dbxtract) and the Extract Database Wizard grant the appropriate PUBLISH and CONSOLIDATE permissions to users in the remote databases.
Subscribe a user to the publication (Sybase Central)Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.
In the left pane, click the Publications folder.
Click a publication.
In the right pane, click the SQL Remote Subscriptions tab.
Click File » New » SQL Remote Subscription.
Follow the instructions in the Create SQL Remote Subscription Wizard.
The details of the subscription are different depending on whether the publication uses a subscription expression.
Subscribe a remote user to a publication (SQL)Connect to the database as a user with DBA authority.
Execute a CREATE SUBSCRIPTION statement to subscribe a user to a publication.
For example, the following statement creates a subscription for user name SamS to the CustomerPub publication, which was created using a WHERE clause:
CREATE SUBSCRIPTION TO CustomerPub FOR SamS; |
For example, the following statement creates a subscription for user name SamS to the PubOrders publication, defined with a subscription expression SalesRepresentative, requesting the rows for Sam Singer's own sales:
CREATE SUBSCRIPTION TO PubOrders ( '856' ) FOR SamS; |
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |