Deploying a replication configuration from one instance to another in Instance Data Replication
-
- UpdatedJan 30, 2025
- 2 minutes to read
- Yokohama
- Instance Data Replication
Copy a replication configuration from one instance to another through an update set in Instance Data Replication (IDR).
In IDR, you can capture a snapshot of a replication configuration, including selected fields, filters, or data transformations using the Track in Update Set option, and then copy it to another instance using an update set.
Key benefits
- Save time by defining a replication configuration once and using it as a template for new replication sets on other instances.
- Minimize potential impact to your production instance by developing a replication configuration in your sub-prod instance first.
- Verify a replication configuration in a sub-prod instance before rolling it out to a production instance.
Configuration entities
The following configuration entities are captured in an active update set when you select the Track in Update Set option.
- Entry set
- An entry set is a bundle of replication entries (like a replication set), that doesn't contain any instance-specific metadata like the Producer ID. A new Producer ID is used in the target instance when you create a
producer replication set based on an entry set. Replication options that are tracked in an entry set and their status (active or inactive) include:
- Bi-directional replication
- Discrete value mapping
- Replication entries
- A replication entry contains configuration settings for each table that you want to replicate. Replication entries are either outbound or inbound.
- Outbound entries from a producer instance contain the source table, filter, fields you want to replicate, and data transformation settings.
- Inbound entries from a consumer instance include the target table, the option to run business rules after replication, and data transformation settings.
Viewing an entry set and replication entries
When you create a replication set, a new record is added to the Entry Sets [idr_entry_set] table. New records are added to the Replication Entries [idr_replication_entry] table for each outbound entry that you add to the replication set.
After selecting Track in Update Set, you can view the entry set and its replication entries in the current update set by navigating to , selecting the update set, and then viewing the Customer Updates tab.
Related Content
- Manage consumer access to replication data in Instance Data Replication
Approve or deny a request to grant access to the replication data in Instance Data Replication (IDR).
- Comparing replicated data between instances in Instance Data Replication
Find missing or mismatched records by comparing replication data between instances in Instance Data Replication (IDR).
- Cloning with Instance Data Replication
Ensure that certain tables are preserved or excluded to clone your database from one instance to another successfully with Instance Data Replication (IDR).
- Monitoring replication status in Instance Data Replication
Monitor the status of active producer and consumer replication sets, scheduled jobs, seeding requests, and license or usage details through the Instance Data Replication (IDR) Monitoring Dashboard.
- Monitoring queues in Instance Data Replication
Monitor the replication record queue, message produced queue, message consumed queue, and the messages processed for all replications sets through the Instance Data Replication (IDR) Queue Dashboard.
- Preventing insert and update errors in Instance Data Replication
You can prevent insert and update failures in Instance Data Replication (IDR) by specifying a class name filter in the producer replication set.
- Resolving data replication errors in Instance Data Replication
Resolve errors and monitor the status of Instance Data Replication (IDR) replication sets.