[Epic] sources/kafka/debezium: improve support for SQL Server connector

[benesch]

These are the three known bugs with our Debezium + Microsoft SQL Server integration:

• debezium: DATETIMEOFFSET from SQL Server is replicated as TEXT #8017
• Debezium: DATETIME2 values from SQL Server arrive as BIGINT #8041
• https://issues.redhat.com/browse/DBZ-3915

I think we should make a push to get #8017 and #8041 knocked out soon, but just document the upstream bug (DBZ-3915) as a known limitation. @philip-stoev do you agree?

cc @nmeagan11 @umanwizard

[philip-stoev]

@benesch It will be a tortured "known limitation". Something like "stop all updates to the tables you intend to replicate to Mz until you have configured Debezium completely , all snapshots have been taken , plus 10 seconds"

[benesch]

@benesch It will be a tortured "known limitation". Something like "stop all updates to the tables you intend to replicate to Mz until you have configured Debezium completely , all snapshots have been taken , plus 10 seconds"

Yeah, I totally agree. I hope it is the kind of limitation that makes people reconsider using SQL Server + Debezium.