Setting up a replication system

Setting up a replication system with ASE Replicator involves the following tasks:

  1. Create database connections to identify all of the primary and replicate databases.

  2. Create publications for the primary database connections.

  3. Create primary articles in the publications to identify the tables and stored procedures in each primary database that you want to publish.

  4. Create subscriptions for the replicate database connections.

  5. Create replicate articles in the subscriptions to identify the published articles (primary articles) that you want the replicate database objects (tables and stored procedures) to subscribe to.

  6. Materialize or validate each replicate article to synchronize the replicate database object with the primary database object.

  7. Resume all database connections and subscriptions to start replication.

All of these tasks, and other ASE Replicator administrative tasks, are described in Chapter 3, “Administering ASE Replicator.”

Details of the ASE Replicator command procedures are described in Chapter 4, “ASE Replicator Procedures.”

NoteBefore you can set up a replication system with ASE Replicator, you must complete all of the following procedures: