Reviewing the installation process

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

Table 1-2 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 1-2: 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.

Install the correct JDBC driver for your primary database server.

3

Install Replication Server and create connections.

This includes:

  • Designing the replication system

  • Installing Replication Server

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

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

  • Replication Server documentation

  • ECDA documentation

4

Prepare to install Replication Agent.

5

Install the Replication Agent software.

When installing the software:

  • For Microsoft SQL Server, Replication Agent for Microsoft SQL Server must be installed on a Microsoft Windows host from which it can directly access the primary Microsoft SQL Server transaction logs.

  • For Oracle, Replication Agent for Oracle must be installed on a UNIX or Microsoft Windows host from which it can directly access the primary Oracle redo logs.

  • For UDB, Replication Agent for UDB must be installed on the same UNIX or Microsoft Windows host as the DB2 UDB server or a DB2 UDB client.

“Installing the Replication Agent software”

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

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

7

Set up the Replication Agent instance.

This includes:

  • Creating the Replication Agent transaction log objects

  • Marking primary objects for replication

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

8

Prepare for replication.

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

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

9

Verify your replication system using Replication Agent test scripts (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.

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

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

11

Start replication.

Put the Replication Agent instance in the Replicating state.

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