A personal summary of HVR data replication software in the Netherlands, hvr in the Netherlands
This article is the original article, reproduced please indicate the source: http://blog.csdn.net/msdnchina/article/details/44133637
Recently engaged in hvr data replication software, which is a data replication software provider in the Netherlands, its official website is: http://www.hvr-software.com/
Hvr data replication software, similar to Oracle GoldenGate (OGG), can provide data synchronization between heterogeneous databases.
The hvr operation interface is graphical, which is superior to the version earlier than OGG 12c.
The biggest difference between hvr and OGG is that hvr has the concept of hub db.
Hvr's hub db is a db for centralized storage and replication of relevant information (if oracle is used as the hub db, the hub db is actually a schema in oracle)
In the concept of hvr, the source db and target db in OGG are called location
Parameter file (. prm file), similar to the concept of channel in hvr: it is an object in HVR. The object will be connected together by location and tables to be copied. Channels also include actions, which control how replication is performed.
The trail file in OGG, in hvr, is called router transaction files. However, hvr's router transaction files are stored in the file system of the host where the hub db is located (H: \ hvr \ hvr_config \ router \ hvrhub \ ch_demo \ loc_test1 ).
Unlike ogg, ogg extracts the trail file generated by the process in the OS where the source database is located.
In addition, hvr data replication software has the following features:
1. The hvr data replication software has a serial number ($ HVR_HOME/lib/hvr. lic) limit, which is also different from that of OGG (OGG has no serial number limit ). The serial number limit here means that the software cannot be used normally without the serial number. The hvr serial number must be placed on the host ($ HVR_HOME/lib/hvr. lic) where the hub db is located.
2. The hvr data replication software's monitoring interface is the hvr operation interface, which is much better than OGG's need for additional configuration monitoring (director or monitor.