Team skill requirements  Completing the Installation and Setup worksheet

Chapter 2: Preparing for Installation

Reviewing the installation process

Installing Sybase Replication Agent software is just one part of the process of setting up a replication system.

Table 2-7 lists the major steps required to set up a replication system to replicate transactions from a non-Sybase primary database in an enterprise network.

Table 2-7: Setting up a Sybase replication system

Step

To do this

Refer to

1

Install the primary data server.

The primary data server is the source of transactions to be replicated.

  • Primary data server documentation

  • Vendor documentation or Web site for the primary data server

2

Install the connectivity drivers for the primary database server.

You must install the correct JDBC driver for your primary database server.

3

Install Replication Server and Adaptive Server and create connections.

This includes:

  • Designing the replication system

  • Installing Replication Server and its ERSSD

  • Defining connections from Replication Server to the ERSSD and routes between Replication Servers

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

  • Sybase installer documentation

  • Replication Server documentation

  • DirectConnect documentation

4

Prepare to install Sybase Replication Agent.

5

Install the Sybase Replication Agent software.

This includes:

  • Installing the software

    NoteSybase Replication Agent for Oracle must be installed on a machine from which it can directly access the Oracle redo logs.

“Installing the Sybase Replication Agent software” in this manual

6

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

Sybase Replication Agent Administration Guide, Chapter 3, “Administering Sybase Replication Agent”

7

Set up the Replication Agent instance.

This includes:

  • Creating the Replication Agent transaction log objects

  • Marking primary objects for replication

Sybase Replication Agent Administration Guide, Chapter 2, “Setup and Configuration”

8

Prepare for replication.

Refer to the checklist to verify that all the replication system components are in place before you start replication.

Sybase Replication Agent Administration Guide, Chapter 2, “Setup and Configuration”

9

Verify your replication system using Sybase Replication Agent test scripts (optional).

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

Sybase Replication Agent Primary Database Guide, the chapter for your primary data server

10

Materialize subscriptions to primary data.

For each subscription, this process:

  • 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

  • Sybase Replication Agent Administration Guide, Appendix E, “Materializing Subscriptions to Primary Data”

11

Start replication.

Put the Replication Agent instance in the Replicating state.

Sybase Replication Agent Administration Guide, Chapter 2, “Setup and Configuration”





Copyright © 2005. Sybase Inc. All rights reserved. Completing the Installation and Setup worksheet

View this book as PDF