Gluesync for Microsoft SQL Server

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.

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.