Developing a Replication System

Use Database Development tools and Replication Server to create a replication system.

A Replication Server maintains replicated data in multiple databases while ensuring the integrity and consistency of the data. Replication Server provides clients using databases in the replication system with local data access, thereby reducing load on the network and centralized computer systems.

  1. Installing and Configuring Replication Server
    Following the directions in the Replication Server documentation, install Replication Server. After installing Replication Server, configure the server to work with Sybase WorkSpace.
  2. Starting Replication Server
    After you install and configure Replication Server, you can start it.
  3. Creating a Replication Server Connection Profile
    Create a connection profile to connect to Replication Server.
  4. Creating Replication Definitions
    A replication definition is a description of a replicated artifact.
  5. Creating a Replication Server Publication
    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 these replication definitions as a group.
  6. Creating a Replication Server Article
    A Replication Server article is an extension to a replication definition allowing table replication definitions or function replication definitions to be part of a publication. Because an article is associated with a publication, you should make sure you have created a publication before creating an article.
  7. Creating a Replication Server Subscription
    A Replication Server subscription is a request for Replication Server to maintain a replicated copy of an object in a replicate database at a specified location.

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.