Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-1938

Sql Server CT (change tracking) connector

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Unresolved
    • Major
    • None
    • None
    • sqlserver-connector
    • None
    • 0
    • 0% 0%

    Description

      Change tracking is a lighter alternative to CDC in Sql Server.
      Implementing this connector would allow debezium to be used with sql server databases that receive a lot of updates in a short amount of time where the CDC cleanup can't acquire the lock on tables.

      Big result difference to the usual CDC protocol is that not every change is guaranteed to be produced. The connector will show the latest data.
      Additionally, no previous state will be produced in update or delete events.

      I plan on working on this connector myself, submitting ticket for tracking and communication.

      Attachments

        Issue Links

          is related to

          Task - Represents a small unit of work that is not end-user facing. DBZ-1124 Consider change tracking as an optimization to CDC queries

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Open

          Activity

            People

              Unassigned Unassigned
              mherceg Matija Herceg (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated: