SQL Server Replication Software
Three Updates with our SQL Server Replication Software
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
HVR 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 for 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 HVR’s integration supports larger volumes while using fewer network resources.