0 Rows Update
Basic DML Filters
There might be situations, where replicating whole tables is not desirable. We will now make an easy example of filter using DBVisit replicate. We want to replicate all rows on table repoe.order_items except rows, that affect orders made for product with product_id=100.
Excluding Columns
For learning more about setting filters read Filter Chapter on our online wiki.
Renaming Table
Renaming Schema
Prepare sample schema to replicate
With NODDL option
With DDL option
When we successfully installed DBVisit Replicate product on our RepAttack environment, we should test, how the replication works itself.
This chapter brings some basic examples, that should demonstrate the user how the logical replication works, how are the replicated DMLs transformed, how to use and monitor replicate and how to setup some basic features of replicate such as filtering rows and excluding columns.
Pre-requisites
Please ensure the following pre-requisites have been completed
Follow the step by step guide in the Child Pages below.
| Child pages (Children Display) |
|---|