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 Replication Server
  • Configure and verify the Replication Server installation
  • Add the primary and replicate database to the 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 Sun Solaris; adjust them accordingly for Windows and for other UNIX and Linux platforms.
  • Do not use Replication Server-reserved words for object names and connection names. Replication Server also reserves all keywords and identifiers beginning with “rs_”. See the Replication Server Reference Manual > Topics > Reserved Words.
  • 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 Adaptive Server databases and one 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 Replication Server. Each 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 Replication Servers in your production environment. The examples discuss how to install and configure a single Replication Server, which has a RSSD database in an existing Adaptive Server.
  • The replication environment uses the pubs2 database, which is available in the standard installation of Adaptive Server. See the Adaptive Server Enterprise Installation Guide > Post Installation Tasks > Installing Sample Databases for information on installing pubs2 database.