Gluesync for Microsoft SQL Server

Gluesync SQL to NoSQL for MS SQL Server

Core principles

Gluesync consumes changes from MS SQL Server in 2 ways:

  • using CDC (Change data capture) technique to read transaction logs of MS SQL Server starting from version 2008;

  • using Change tracking technique to catch field-level changes of rows in tables with primary keys on MS SQL Server 2016 and above.

Based on your use case and requirements you can decide whether to use Change tracking or Transaction-logs based CDC.

Change tracking vs CDC

From the books:

Change tracking is a lightweight solution that provides an efficient change-tracking mechanism for applications. Typically, to enable applications to query for changes to data in a database and access information that is related to the changes, application developers had to implement custom change tracking mechanisms. These mechanisms usually involved a lot of work and frequently involved a combination of triggers, timestamp columns, new tables to store tracking information, and custom cleanup processes.
— Microsoft
About Change Tracking (SQL Server)
Data Change Capture (CDC) utilizes the SQL Server agent to log insertions, updates, and deletions occurring in a table. So, it makes these data changes accessible to be easily consumed using a relational format. The column data and essential metadata needed to apply these change data to a target environment are captured for the modified rows and stored in change tables that mirror the column structure of the tracked source tables. Furthermore, table-valued functions are available for systematic access to this change data by consumers.
— Microsoft
What is change data capture (CDC)?

Our 2 cents here:

  • CDC is not available on MS SQL Standard edition while Change tracking is available on any version;

  • CDC is compatible with MS SQL Server starting from 2008 and above while Change tracking supports versions starting from 2016 only;

  • CDC is compatible with tables that lack a Primary key in their columns definition while Change tracking is not capable of working in the case a Primary key is not defined.

Architectural overview

Here in the following diagram represents an architectural overview of the environment you are going to have after having deployed Gluesync.

a diagram illustrating the architectural overview of Gluesync for MS SQL Server

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.

Having further questions? For more information regarding Gluesync please reach us via email by pressing here: Contact MOLO17.