Debezium for SQL server with table rename outcome?

[Peter Briggs]

Renaming the table does NOT affect the CDC to topic processing...is this by design or feature? Asking because we are planning to use this feature and want to ensure it stays implemented.

[Chris Cranford]

Hi Peter -

I would suggest giving schema evolution [1] a read if you haven't already.  The connector will stream changes from the capture table associated with the base table.  This means if you make changes to the source table but never re-generate the capture table, then SQL Server will continue to capture changes from the source table, replicating those to the existing capture table based on the structure of the capture table and that will be the structure used to emit changes via Debezium.  This is simply just how CDC works both from within the scope of SQL Server proper and how we integrate with the capture table instances linked to a given source table.

Chris

On 7/19/22 20:19, Peter Briggs wrote:

Renaming the table does NOT affect the CDC to topic processing...is this by design or feature? Asking because we are planning to use this feature and want to ensure it stays implemented. --
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/4832ffca-0849-4b2d-b962-af6b63a1b1f4n%40googlegroups.com.

[Chris Cranford]

My apologies, I forgot to include the [1] link in my previous post:

[1]: https://debezium.io/documentation/reference/stable/connectors/sqlserver.html#sqlserver-schema-evolution

Thanks,
Chris