Replication System Components

Installing Replication Agent software is only one part of setting up a replication system.

Setting Up a Sybase Replication System

To

See

Install the primary data server.

  • Primary data server documentation

  • Vendor documentation or Web site for the primary data server

Install the connectivity drivers for the primary database server.

  • " Primary Database Connectivity"

  • Vendor documentation or Web site for the primary data server

Install Replication Server® and create connections.

This includes:

  • Designing the replication system

  • Installing Replication Server

  • Defining connections from Replication Server to the Embedded Replication Server System Database (ERSSD) and routes between Replication Servers

  • Defining connections using ECDA when replicating to a non-Sybase database

    Note: For Replication Agent for Oracle, you can use ExpressConnect for Oracle, in which case it is unnecessary to install and configure ECDA. See the ExpressConnect for Oracle Installation and Configuration Guide.

  • Replication Server documentation

  • ECDA documentation

  • ExpressConnect for Oracle Installation and Configuration Guide

Prepare to install Replication Agent.

  • Review installation requirements and the installation procedure for Replication Agent.

  • Complete the Installation and Setup worksheet.

  • "Planning Your Installation" in this document and Chapter 2, “Setting Up and Configuring Replication Agent,” in the Replication Agent Administration Guide

  • Replication Server Options Release Bulletin

Install the Replication Agent software.

"Installing Replication Agent"

Configure Replication Server and primary data server connections.

This includes:

  • Creating a Replication Server database connection to the primary data server

  • Creating a Replication Server login for the Replication Agent instance

  • Configuring Replication Agent parameters

  • Testing connections between the Replication Agent and the primary Replication Server, and between the Replication Agent and the primary data server

Chapter 3, “Administering Replication Agent” in the Replication Agent Administration Guide

Set up the Replication Agent instance.

This includes:

  • Creating the Replication Agent transaction log objects

  • Marking primary objects for replication

Chapter 2, “Setting Up and Configuring Replication Agent” in the Replication Agent Administration Guide

Verify that all replication system components are in place.

Chapter 2, “Setting Up and Configuring Replication Agent” in the Replication Agent Administration Guide

(optional) Use the test scripts provided with Replication Agent to set up a test environment and verify replication from a primary database to a replicate database.

The chapter for your primary data server in the Replication Agent Primary Database Guide

Materialize subscriptions to primary data.

For each subscription, materialization:

  • Validates and activates the subscription

  • Populates tables in the replicate database so they are synchronized with the primary database before you start replication

  • Replication Server documentation

  • Appendix A, “Materializing Subscriptions to Primary Data” in the Replication Agent Administration Guide

To start replication, put the Replication Agent instance in the Replicating state.

Chapter 2, “Setting Up and Configuring Replication Agent” in the Replication Agent Administration Guide

To install and configure a sample replication system, see the Replication Server Options Quick Start Guide.