Using the Examples to Set Up Your Replication Environment

Supplied examples walk you through setting up your replication environment.

The examples explain how to:
  • Install SAP Replication Server
  • Configure and verify the software installation
  • Add the primary and replicate database to the SAP Replication Server
  • Replicate data and DDL from a primary to a replicate database
  • Manage warm standby applications
  • Manage materialization
Follow these general instructions when using the examples to set up your replication environment:
  • Some directories, files, executable commands, and examples are provided only for Solaris; adjust them accordingly for Windows and for other UNIX and Linux platforms.
  • Do not use SAP Replication Server-reserved words for object names and connection names. The software also reserves all keywords and identifiers beginning with “rs_”. See the Reserved Words in the Reference Manual.
  • The values in the examples can be customized to meet the needs of your replication environment.
The examples make several assumptions:
  • The simple replication environment uses three SAP Adaptive Server Enterprise (SAP ASE) databases and one SAP Replication Server. The primary database is the source of changes to be replicated; the replicate database is where changes are applied, and the Replication Server System Database (RSSD) holds the system tables for one SAP Replication Server. Each SAP Replication Server requires an RSSD, and in a production environment, the RSSD must be maintained like any other critical database or file.
    Note: The sample scenarios do not discuss the Embedded Replication Server System Database (ERSSD) database.
  • You can have many SAP Replication Servers in your production environment. The examples discuss how to install and configure a single SAP Replication Server, which has a RSSD database in an existing SAP ASE.
  • The replication environment uses the pubs2 database, which is available in the standard SAP ASE installation. See Installating Sample Databases in the SAP Adaptive Server Enterprise Installation Guide for information on installing pubs2 database.