Reviewing the installation process

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

Table 1-7 lists the major steps required to set up a replication system to replicate transactions from ASE or an Oracle database in an enterprise network.

**Table 1-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. For Oracle: You must install the correct JDBC driver for your primary database server. For ASE: The JDBC driver is installed as part of the normal Mirror Replication Agent installation process.	“Setting up connectivity to the primary database” in this manual Vendor documentation or Web site for the primary data server
3	Implement Disk replication system and devices. This includes: Designing the disk mirroring system Installing appropriate hardware or software Establishing active mirroring of the Oracle redo logs	Disk replication system vendor and device vendor documentation
4	Prepare to install Mirror Replication Agent. This includes: Reviewing installation requirements and the installation procedure for Mirror Replication Agent. Completing the Installation and Setup worksheet.	Chapter 1, “Setup and Configuration,” in the Mirror Activator Administration Guide Mirror Replication Agent release bulletin “Using the Installation and Setup worksheet” in this guide.
5	Install the Mirror Replication Agent software. Mirror Replication Agent must be installed on a machine from which it can directly access the mirror copy of the transaction logs of the primary database.	“Installing the Mirror Replication Agent software” in this guide
6	Install Replication Server and create connections. If you do not use an embedded RSSD (ERSSD) you will need to install an ASE to be used for the RSSD. This includes: Designing the replication system Installing Replication Server and its RSSD Defining connections from Replication Server to the RSSD and routes between Replication Servers Defining connections using ECDA when replicating to a non-Sybase database	Sybase installer documentation Replication Server documentation Enterprise Connect Data Access (ECDA) documentation
7	For Oracle only: Install ECDA. This includes: Installing the ECDA Option for Oracle Defining connections using ECDA when replicating to a non-Sybase database	Sybase installation documentation ECDA documentation
8	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 Mirror Replication Agent instance Configuring Mirror Replication Agent parameters Testing connections between the Mirror Replication Agent and the primary Replication Server, and between the Mirror Replication Agent and the primary data server	Mirror Replication Agent Administration Guide, Chapter 3, “Administering Sybase Mirror Replication Agent”
9	Set up the Mirror Replication Agent instance. This includes: Creating the Mirror Replication Agent system objects in the primary database Marking primary objects for replication	Mirror Replication Agent Administration Guide, Chapter 2, “Setup and Configuration”
10	Prepare for replication. Refer to the checklist to verify that all of the replication system components are in place before you start replication.	Mirror Replication Agent Administration Guide, Chapter 2, “Setup and Configuration”
11	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 Mirror Replication Agent Administration Guide, Appendix A, “Materializing Databases in a Mirror Activator System”
12	Start replication. Put the Mirror Replication Agent instance in the Replicating state.	Mirror Activator Administration Guide, Chapter 2, “Setup and Configuration”

Table 1-7: Setting up a Sybase replication system

Step

To do this

Refer to

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

Install the connectivity drivers for the primary database server.

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

For ASE: The JDBC driver is installed as part of the normal Mirror Replication Agent installation process.

“Setting up connectivity to the primary database” in this manual
Vendor documentation or Web site for the primary data server

Implement Disk replication system and devices.

This includes:

Designing the disk mirroring system
Installing appropriate hardware or software
Establishing active mirroring of the Oracle redo logs

Disk replication system vendor and device vendor documentation

Prepare to install Mirror Replication Agent.

This includes:

Reviewing installation requirements and the installation procedure for Mirror Replication Agent.
Completing the Installation and Setup worksheet.

Chapter 1, “Setup and Configuration,” in the Mirror Activator Administration Guide
Mirror Replication Agent release bulletin
“Using the Installation and Setup worksheet” in this guide.

Install the Mirror Replication Agent software.

Mirror Replication Agent must be installed on a machine from which it can directly access the mirror copy of the transaction logs of the primary database.

“Installing the Mirror Replication Agent software” in this guide

Install Replication Server and create connections.

If you do not use an embedded RSSD (ERSSD) you will need to install an ASE to be used for the RSSD.

This includes:

Designing the replication system
Installing Replication Server and its RSSD
Defining connections from Replication Server to the RSSD and routes between Replication Servers
Defining connections using ECDA when replicating to a non-Sybase database

Sybase installer documentation
Replication Server documentation
Enterprise Connect Data Access (ECDA) documentation

For Oracle only: Install ECDA.

This includes:

Installing the ECDA Option for Oracle
Defining connections using ECDA when replicating to a non-Sybase database

Sybase installation documentation
ECDA documentation

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 Mirror Replication Agent instance
Configuring Mirror Replication Agent parameters
Testing connections between the Mirror Replication Agent and the primary Replication Server, and between the Mirror Replication Agent and the primary data server

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

Set up the Mirror Replication Agent instance.

This includes:

Creating the Mirror Replication Agent system objects in the primary database
Marking primary objects for replication

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

Prepare for replication.

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

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

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
Mirror Replication Agent Administration Guide, Appendix A, “Materializing Databases in a Mirror Activator System”

Start replication.

Put the Mirror Replication Agent instance in the Replicating state.

Mirror Activator Administration Guide, Chapter 2, “Setup and Configuration”