Sql Server CT (change tracking) connector [DBZ-1938]
- Dominant language
- HTML
- Stars
- 6
- Forks
- 8
- Avg merge
- 2d 19h
- Merged PRs (30d)
- 1
Description
Migrated from [DBZ-1938](https://issues.redhat.com/browse/DBZ-1938)
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.
Contributor guide
Research direction
Start with the linked DBZ-1938 ticket, since this issue names no repository files, tests, or implementation entry points. The requested work is a SQL Server change-tracking connector; done means it reports the latest data without guaranteeing every change or including previous state in update and delete events. The author says they plan to work on it, so coordinate before starting.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 25/100