Database Replication Software Solution
Database Replication Software that Simplifies High Volume Data Movement
Organizations may want to move or replicate data from one database to another for many reasons. Whatever your reason for replication, HVR is a database replication software product that makes it fast, easy and efficient to move data between disparate databases—without system overload.
HVR simplifies data replication with features such as:
- Initial load capabilities
- Automatic mapping between source and destination data types
- Uni, Bi-directional or multi-directional replication
- DDL Transformations
With HVR, you can replicate data in your heterogeneous environment as most common relational databases are supported.
Database Replication Software: Platforms Supported
HVR supports on-prem and cloud databases such as Oracle, SQLServer, AzureSQL, and AmazonRDS. See a snapshot in our table below and visit our platform support page to learn more.
|Source and Target||Target Only|
|DB2 LUW||Azure SQL||Vector||HANA|
|DB2 iSeries||Amazon RDS||Matrix||Azure SQL DW|
High-Volume Data Replication in Action: Learn how HVR helped a large telecom, MobiCom, offload data from two Oracle databases into SQL Server.
Database Replication Software that Captures Data Changes in Real-Time
Log-based replication provides a way to deliver the data needed to power real-time analytics without the performance problems and complexity issues associated with traditional approaches. Because these real-time analytics are so much in demand for many business and government organizations, we have developed our database replication software to support this approach.
HVR supports log-based change data capture out of most commonly used databases to enable real-time updates with minimal system impact. On a well-configured system, HVR captures data from the source as soon as it is committed to the online transaction log.
At the destination, HVR ensures scalability for large volumes of data for any target database through optimizations such as burst mode, coalescing changes, and the ability to combine transactions.
Looking for a database replication software solution to perform Oracle or SQL Server Database Replication? Learn more in our blog post about these two common database replication scenarios.
Four Common Questions We Hear: Performance Considerations When Selecting a Database Replication Software Solution
1. PERFORMANCE: Can the data replication software keep current with transaction log generation?
Dependencies include the transaction rate (lots of small transactions or fewer larger ones), the percentage of transaction log that is relevant for replication, how many database objects must be tracked, what data types are involved, etc. If two replication products can easily keep up with transaction log generation volume, it is more relevant to talk about other aspects such as how many resources do products use (CPU, memory, IO) to perform at the “speed limit”, or how much effort does it take an administrator to implement the technology? The one aspect of performance that may be relevant is how long does it take to get to current if replication is running behind.
2. SPEED: How fast can the software capture and replicate transactions?
HVR is a replication technology that can capture and replicate transactions at amazing speed. The team at HVR recently ran a TPC-C workload on a local Oracle database at about 800 transactions per second that were captured and replicated into a SQL Server database with at most a couple of seconds of latency, all running on a two- year-old laptop.
Want to see for yourself? Request a Trial.
3. RESOURCE CONSUMPTION: How much resources will the data replication software consume?
Resource consumption includes CPU, memory, storage and network resources.The HVR engineers decided that it was best by default to trade CPU resources for network resources and always compress transactions across the wire. This is probably the right default for hybrid cloud environments or for replication across a wide-area network in which network bandwidth is typically severely limited. On the other hand it may not be the best default for replication within a data center on an extremely busy database system that already averages at 90% CPU utilization. Likewise HVR does not store transaction files on the source system saving storage and IO resources.
4. MAINTENANCE: How much ongoing maintenance is required? How long does it take to get up and running?
Consider the effort it takes to setup and maintain the environment. Of course there is the setup of real-time replication, but that is certainly not all of it. In my Oracle to SQL Server environment aspects like DDL generation and initial load are extremely important to get up and running quickly. Also, it is comforting to be able to compare these heterogeneous environments to know whether the databases are in sync. HVR provides capabilities like these out-of-the box within a single offering but not every replication tool does. On top of that HVR provides a GUI to setup and maintain real-time replication. A lot of these kinds of capabilities relate to the cost of implementation and ongoing maintenance.