Mark Van de Wiel

SQL Server Replication Software

Knowing your options

If you’re looking for data replication out of and into SQL Server, one option is HVR, which enables replication in both homogeneous (SQL Server to SQL Server) and heterogeneous environments. HVR version 5 introduced a number of exciting new SQL Server replication capabilities:

1. Direct capture of the SQL Server transaction log

capture out of sql serverHVR 5 introduces direct capture of the SQL Server transaction log (both the current log and the backups) on the file system. This approach works well for other databases like Oracle, enabling minimal latency on very busy transaction processing systems. The previous approach to perform Change Data Capture on SQL Server, accessing the transaction log through stored function calls, will continue to be supported but is no longer the default. The stored function approach, however, has other benefits such as the ability to run on a different server, and to run with lower system access privileges.

2. DDL Replication

HVR 5 introduces table DDL replication in heterogeneous environments. The initial release supports DDL capture out of Oracle and SQL Server into all databases HVR supports. For example, you can now set up a real-time reporting database on SQL Server fodiagrams_hybrid_cloudr an Oracle-based source database, and DDL changes to tables will automatically be reflected in SQL Server. (e.g. new tables, additional columns, column data type changes etc.) This automation makes management of your replication setup a lot easier!


3. Cloud Data Integration

An optimized architecture for cloud integration is not new with HVR 5. HVR has always featured highly efficient network communication and our blueprint for integration into the cloud has not changed: make sure a copy of HVR is installed in the cloud as close to the source or destination server as possible i.e. in the same availability zone.

When HVR communicates using its own protocol you take advantage of densely compressed, large data block transfer, with the option to encrypt the data (as you likely would in a cloud implementation scenario). Compare this to a typically chatty, not necessarily low bandwidth remote database connection, and it is pretty clear that HVR’s data integration supports larger volumes while using fewer network resources.

Interested in learning more about our SQL Server replication abilities?  We welcome you to contact us.

About Mark

Mark Van de Wiel is the CTO for HVR. He has a strong background in data replication as well as real-time Business Intelligence and analytics.

Test drive
Contact us