Three Updates with our SQL Server Replication Software

 

sql server replication

There are numerous options if you are looking for data replication out of and into SQL Server. One of these has been HVR, enabling replication in both homogeneous (SQL Server to SQL Server) and heterogeneous environments. With the recent introduction of version 5, we 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 has been working 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 fosql server replicationr 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

cloud data replication and integration with sql server

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 HVR’s 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.

Discussion

© 2019 HVR

Live Demo Contact Us