Using Templates to Set Up Replication

Home | Previous Page | Next Page Setting Up and Managing Enterprise Replication > Defining Replication Servers, Replicates, Participants, and Replicate Sets >

Using Templates to Set Up Replication

Enterprise Replication provides templates to allow easy set up and deployment of replication for clients with large numbers of tables to replicate. A template uses schema information about a database, a group of tables, columns, and primary keys to define a group of master replicates and a replicate set.

First, you create a template using the cdr define template command; then, you instantiate it on the servers where you want to replicate data by running the cdr realize template command.

Important:

If you want to use time-based replication, you must set up replication manually.

Important:

Templates set up replication for full rows of tables (all the columns in the table), because they are designed to facilitate setting up large scale replication environments.
If you want a participant to contain a partial row (just some columns in the table), you can either set up replication manually, or, after you realize a template you can use the cdr remaster command to restrict the query.

All options of the cdr define template, cdr list template, cdr realize template, and cdr delete template commands are described in detail in Appendix A. Command-Line Utility Reference.