Set up replication through templates

Enterprise Replication provides templates to allow easy setup 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 replication keys to define a group of master replicates and a replicate set.

Do not use a template if you want to use time-based replication.

You create a template by running the cdr define template command and then you instantiate the template on the servers where you want to replicate data by running the cdr realize template command.

Templates set up replication for all the columns in the table. Templates are useful for 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 run the cdr remaster command to restrict the query.


Copyright© 2018 HCL Technologies Limited