Creating Replication Server Publications

A Replication Server publication is a group of articles from the same primary database. A publication enables you to collect replication definitions for related tables or stored procedures and subscribe to them as a group. You collect replication definitions as articles in a publication at the source Replication Server and subscribe to them with a publication subscription at the destination Replication Server. To create Replication Server publications from Workspace, use the following procedure.

  1. Open Enterprise Explorer, and connect to your Replication Server.

  2. Expand the view for your Replication Server connection profile, right-click a primary database for which to create the publication, and choose New Artifact from the context menu.

  3. From the wizard selection screen, select Publication, and click Next to start the wizard. You can also start this wizard by right-clicking a Publications folder and choosing New Publication from the context menu.

  4. Modify the following fields.

    Publication settings

    FieldExample

    Publication Name

    Enter a name for the publication.

    Primary Data Location

    Provide values for the following fields:

    • Primary server – Select a primary data server from the menu dropdown.

    • Primary database – Select a primary database from the menu dropdown.

    The changes made in this wizard page appear in the Preview field.

  5. Click Finish to create the publication. If the publication is successfully created, it appears in the Publications folder for the specified primary data server.

Checking a Replication Server Publication

Dropping a Replication Server Publication

Validating a Replication Server Publication

Viewing a Replication Server Publication

Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com