The following procedure describes preparing a publication for subscription and creating a subscription against it in Sybase Central. You can include table replication definitions, but not function replication definitions, in a publication you create through Sybase Central.
When you prepare a publication for subscription in Sybase Central, the system records the procedure in an isql script that you can keep as a record of your work, or edit and execute later on at the command line.
The following steps describe preparing a publication for subscription and then subscribing to the publication.
Prepare the publication for subscription.
Open the Create Publications dialog box and select the tables to which you want to subscribe.
For each table you can:
Create new replication definitions and/or select existing ones.
If you create new replication definitions, you can choose to replicate minimum columns, include the table-owner name, and specify columns to send to the replicate database.
Specify a subset of rows to send to the replicate database with where clauses.
When you save the publication, Replication Server creates the publication, articles, and replication definitions (if appropriate) and validates the publication.
Subscribe to the publication.
Open the Create Publication Subscription dialog box and enter the information required.
Replication Server creates the publication subscription and a subscription for each article in the publication.
Refer to “Using publication subscriptions” for information about publication subscriptions.
RSM – For detailed instructions on creating and modifying publications subscriptions in Sybase Central, see the topics under “Managing Subscriptions:Publication subscriptions” in Replication Server’s plug-in help.
