A personal summary of the Dutch HVR data replication software

This article is original article, reprint please indicate source: http://blog.csdn.net/msdnchina/article/details/44133637

Recently engaged in HVR data replication software, this is a Dutch data replication software provider, its company official website is: http://www.hvr-software.com/
HVR data replication software is functionally similar to Oracle GoldenGate (OGG), which provides data synchronization between heterogeneous databases.
HVR's operating interface is graphic, which is higher than the previous version of Ogg 12c.

HVR architecturally, the biggest difference from Ogg is that HVR has the concept of hub db.

The hub db of the HVR is a db of centrally stored and replicated information (if Oracle is the hub DB, Hub DB is actually a schema in Oracle)

The source DB and the destination DB in OGG, in the concept of HVR, are called location

The parameter file (. prm file) in OGG, similar to the concept of channel in HVR: is an object in HVR, which will be a group of location and tables that should be concatenated together to be copied. The channel also includes actions that control how replication is performed.

The trail file in OGG, in HVR, is called router transaction files. Only HVR router transaction files are stored in the file system (H:\HVR\HVR_CONFIG\ROUTER\HVRHUB\CH_DEMO\LOC_TEST1) of the host where hub DB resides.
Unlike Ogg,ogg, the trail file formed by the extraction process is located under the filesystem of the OS where the source db resides.

In addition, HVR data replication software has the following features:
1. HVR data replication software has a serial number ($HVR _home/lib/hvr.lic) limit, which is also different from Ogg (Ogg is no serial number limit). The serial number limit mentioned here refers to the inability to use the software normally without a serial number. The serial number of the HVR is only required to be placed on the host ($HVR _home/lib/hvr.lic) where the hub db resides.

2. The monitoring interface of the HVR data replication software is a HVR interface, which is much more fun than Ogg requires additional configuration monitoring (Director or monitor).

A personal summary of the Dutch HVR data replication software