MS SQL Server Change Tracking Agent for Gluesync: Key Features

Index

Source data from MS SQL Server (via Change Tracking)

Core principles

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

Change data capture

This agent implements the so-called Change Tracking feature to catch field-level changes in rows in tables that have Primary Key constraints on MS SQL Server 2008 and above.

If you don’t have Primary Keys on tables or you’re looking for the Change Data Capture (CDC) feature based on MS SQL Server’s SQL Agent, plase check out our Gluesync CDC agent for MS SQL Server’s Transaction Logs | Change Data Capture.

Supported version

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

Change Tracking

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

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.