data drift sqlserver

asked 2020-03-09 08:52:56 -0500

umanohar gravatar image

Hi, I am trying to setup a data drift pipeline with sql server. Destination is also another sql server instance. I see information for postgres, is there some documentation for sqlserver? Thank you

edit retag flag offensive close merge delete

Comments

Tried to set up something as follows - sql server cdc client ----> capture schema change event----> capture event and propagate change. While I can capture the schema change event, there is not enough information provided for me to detect what is the actual change.

umanohar gravatar imageumanohar ( 2020-03-10 09:15:36 -0500 )edit

For example if I have altered table T in schema S and added a column, I can detect that a schema change has occurred in table T and schema S but not what the change is. Hence I am unable to propagate that change

umanohar gravatar imageumanohar ( 2020-03-10 09:15:53 -0500 )edit

is there a way I can capture more informtion about the schema change?

umanohar gravatar imageumanohar ( 2020-03-10 09:16:19 -0500 )edit