MS SQL Server Agent for Gluesync: Key Features

Index

Source data from MS SQL Server (via CDC)

Source data from MS SQL Server (via Change Tracking)

Target MS SQL Server

Agent changelog

Core principles

This agent establishes a connection to MS SQL Server via a built-in JDBC driver.

Change data capture

This agent implements two different native API sets provided by Microsoft on MS SQL Server to provide incremental changes feed to Gluesync. More specifically Gluesync adopts the so-called "Change Tracking" feature to catch field-level changes in rows in tables that have Primary Key constraints on MS SQL Server 2016 and above, on the other hand, it also implements the Change Data Capture (CDC), a more granular set of APIs that put their foundations directly top of the SQL Server transaction logs making possible to get incremental changes from database version 2008 via the SQL Agent jobs, this CDC is compatible with Enterprise edition only but can work even if your tables do not have Primary Keys defined on tables.

Supported version

With this agent, you can target any version of MS SQL Server.

Change Tracking

Works with MS SQL Server Server 2016 and above, hosted on-prem or in any DBaaS, SQL Azure as well. Every edition is supported. Requires Primary Keys defined in tables.

CDC (via SQL Agent)

Works with MS SQL Server Server 2008 and above, hosted on-prem or in any DBaaS, SQL Azure as well. Only the Enterprise edition is supported.

Q&A

I have got MS SQL Server running under Microsoft Azure, is it supported? Microsoft Azure gives you the ability to obtain a fully managed instance of SQL Server called SQL Azure. SQL Azure is fully supported by Gluesync.