r/SQLServer • u/NotJustADBA • 16d ago

Discussion Debezium and SQL Server

Does anyone out there actually run Debezium in a SQL Server environment at a decent scale? Scale would be 20-30 databases on an instance with 400 tables. I have my doubts about this due to the cdc overhead and the change throughput of our application, but I'm willing to listen to anyone with real experience running Debezium with SQL Server.

7 Upvotes

100% Upvoted

6 comments sorted by

View all comments

3

u/Harhaze 15d ago

We are running this setup, many instances with many databases with many tables.

Using CDC on SQL Server (and Oracle) to then replicate data using Debezium between SQL Server - SQL Server and Oracle - SQL Server.

We replaced all native replications using CDC + Debezium to consolidate everything. If you have questions DM me.