Table 4-1 lists the configuration steps and the related documents that describe them.
Configuration steps |
Where to find instructions |
|---|---|
1. Set up a heterogeneous replication system. |
|
Know how to set up a heterogeneous replication system and the various components required for such a system. |
Chapter 1, “Sybase Replication System Overview” in the Replication Server 15.0 Heterogeneous Replication Guide |
2. Set up the primary and replicate data servers. |
|
a. Set up a non-Sybase primary data server. |
|
Understand issues and considerations specific to non-Sybase primary data server in a Sybase replication system. |
“Primary data servers,” in Chapter 4, “Data Server Issues” in the Replication Server 15.0 Heterogeneous Replication Guide |
b. Set up a replicate data server. |
|
Understand issues and considerations specific to replication in a heterogeneous replication system. |
“Replicate data servers,” in Chapter 4, “Data Server Issues” in the Replication Server 15.0 Heterogeneous Replication Guide |
3. Configure Replication Server. |
|
a. Plan and prepare your replication system. |
Chapter 1, “Preparing to Install and Configure Replication Server” in the Replication Server 15.0.1 Configuration Guide |
b. Collect and record the information you need to prepare your replication system. |
Appendix A, “Worksheets” in the Replication Server 15.0.1 Configuration Guide |
c. Configure Replication Server. |
Chapter 2, “Configuring Replication Server and Adding Databases with rs_init” in the Replication Server 15.0.1 Configuration Guide |
4. Configure Replication Agent for non-Sybase data server. |
|
a. Prepare to configure Replication Agent. |
“Completing the installation and Setup worksheet,” in Chapter 1, “Preparing for Installation” in the Replication Agent 15.0 Installation Guide |
b. Create Replication Agent for your data server instance. |
“Creating the Replication Agent instance,” in Chapter 2, “Setting Up and Configuring Replication Agent” in the Replication Agent 15.0 Administration Guide |
c. Create an entry for the Replication Agent in the interfaces file. |
“Using the Replication Agent administration port,” in Chapter 2, “Setting Up and Configuring Replication Agent” in the Replication Agent 15.0 Administration Guide |
d. Configure connectivity to the primary data server, Replication Server, and RSSD. |
“Setting up Replication Agent Connectivity,” in Chapter 2, “Setting Up and Configuring Replication Agent” in the Replication Agent 15.0 Administration Guide |
e. (For SQL Server) Set up the SQL Server JDBC driver. |
“Replication Agent communications,” Chapter 2, “Replication Agent for Microsoft SQL Server” in the Replication Agent 15.0 Primary Database Guide |
f. (For Oracle) Set up the Oracle JDBC driver. |
“Replication Agent connectivity,” in Chapter 3, “Replication Agent for Oracle” in the Replication Agent 15.0 Primary Database Guide |
g. (For DB2 UDB) Configure DB2 UDB primary database and JDBC driver. |
“DB2 Universal Database Requirements,” in Chapter 1, “Replication Agent for UDB” in the Replication Agent 15.0 Primary Database Guide |
h. Test network connectivity. |
Section “Testing network connectivity,” in Chapter 2, “Setting Up and Configuring Replication Agent” in the Replication Agent 15.0 Administration Guide |
i. (For SQL Server and Oracle) Grant necessary permissions to the Replication Agent user ID. |
“Replication Agent permissions,” in Chapters 2 and 3 in the Replication Agent 15.0 Primary Database Guide |
j. Mark a table in the primary database for replication. |
“Marking objects in the primary database,” in Chapter 2, “Setting Up and Configuring Replication Agent” in the Replication Agent 15.0 Administration Guide |
k. Verify that database objects are replicated in the correct character case. |
“Character case of database object names,” in Chapters 1, 2, and 3 in the Replication Agent 15.0 Primary Database Guide |
l. Verify the data server’s datatype compatibility with Replication Server. |
“Datatype compatibility,” Chapters 1, 2, and 3 in the Replication Agent 15.0 Primary Database Guide |
5. Configure DirectConnect, if replicating to a non-Sybase data server. |
|
a. Understand the configuration overview and high-level steps. |
Chapter 3, “Installation and Configuration Overview” in the Enterprise Connect Data Access 12.6.1 Installation Guide |
b. Set up and configure DirectConnect server. |
|
i. Create a new DirectConnect server. |
Chapter 5, “Installing DirectConnect” in the Enterprise Connect Data Access 12.6.1 Installation Guide |
ii. Issue the AddServer command. |
Chapter 5, “Installing DirectConnect” in the Enterprise Connect Data Access 12.6.1 Installation Guide |
iii. Use DirectConnect Manager to configure the server and services. |
“Using DirectConnect Manager,” in Chapter 7, “Installing DirectConnect Manager” in the Enterprise Connect Data Access 12.6.1 Installation Guide |
iv. Create a new access service. |
“Installing DirectConnect,” in Chapter 5 and 7 in the Enterprise Connect Data Access 12.6.1 Installation Guide |
v. Configure DSNs. |
“Installing DirectConnect,” in Chapter 5, “Installing DirectConnect” and “Installing DirectConnect Manager,” in Chapter 7, “Installing DirectConnect Manager” in the Enterprise Connect Data Access 12.6.1 Installation Guide |
vi. Use DirectConnect Manager to create and configure the access services. |
“Installing DirectConnect Manager,” in Chapter 7, “Installing DirectConnect Manager” in the Enterprise Connect Data Access 12.6.1 Installation Guide |
vii. Configure Client Connectivity. |
Chapter 8, “After Installation” in the Enterprise Connect Data Access 12.6.1 Installation Guide |
c. Set up and configure DirectConnect access service. |
Chapter 2, “Configuring the Access Service Library for DirectConnect” and Chapter 3, “Configuring Access Services to Work with Related Products” in the Enterprise Connect Data Access Option 12.6.1 User's Guide for Access Services |
6. (Optional) Test sample replication system configuration. |
|
a. View examples of several replication system configurations with heterogeneous or non-Sybase data servers and understand the issues involved with each configuration. |
Chaper 6, “Replication System Configuration Examples” in the Replication Server 15.0 Heterogeneous Guide |
b. Test a heterogeneous replication test environment to verify the installation and configuration of Replication Agent software and the basic function of other components in your replication system. |
“Replication Agent for <data server> setup test scripts,” in Chapters 1, 2, and 3 in the Replication Agent 15.0 Primary Database Guide |
