Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network.
As a source, there are multiple ways HVR can perform Log-based CDC from this platform, including direct reads from the transaction log on the database server itself, on a standby node of an AlwaysOn cluster, or by reading just the backups of the transaction logs. Log-based CDC can also be performed remotely through a SQL connection. As a target HVR uses native bulk load for bulk operations.
 | Key Features: See how change data capture, data validation and repair, and reporting all in one tool simplify data integration management. |
 | Table Creation and Initial Load. Mapping data between source and target is automated and made easy. |
 | Log-based Change Data Capture. Only the changes are moved between source and target, a low impact way to move data. |
 | Data Compare. Have assurance your data is accurate. HVR includes the ability to compare data before consumption. |
 | Insights: This tool gives you the ability to view how data is moving in real-time, be proactive and identify chokepoints. |
HVR’s SQL Server database support HVR supports SQL Server Database as a source for change data capture, and as a target for data delivery. The SQL Server Database is a very commonly used database, often running very demanding and ...
HVR’s Director of Enablement, Glenn Goodrich, gives an overview of HVR, elaborates on key features and setup guidelines, and then demonstrates HVR in action, replicating from Oracle to SQL Server.
Whether you’re moving your data to a data lake or data warehouse, from on-prem to the cloud, we support it.
Contact us to learn more about our API agent plug-in.
Read more from our latest blog posts on best practices and trends in the data replication industry.