Ease of Implementation

Enterprise Replication provides templates to allow easy set up and deployment of replication for clients with large numbers of tables to replicate. Administrators of Enterprise Replication can use templates to develop scripts and with only a few commands can set up replication over a large number of server nodes. Without using templates, many individual commands must be run. Using templates, you can also easily add a new server into your replication environment and optionally create and populate new database tables.

First, you create a template using the cdr define template command. This defines the database, tables, and columns and the characteristics of the replicates that will be created. You can view information about a template by using the cdr list template command from a non-leaf node.

Second, you instantiate the template on the servers where you want to replicate this data by running the cdr realize template command. If the table already exists on a node, Enterprise Replication verifies it matches the template definition. If the table does not exist on a node, Enterprise Replication can optionally create the table. Enterprise Replication can also optionally perform an initial data synchronization on all servers where you realize the template.

You can delete templates that you no longer need using the cdr delete template command.

See Set up replication through templates for more information. All replication commands mentioned in this section are described in detail in The cdr utility.