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.

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 Configuration Guide.

  • Replication Server documentation

  • ECDA documentation

  • ExpressConnect for Oracle 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 15.7.1 SP100 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, “Administration” 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.