Forum Discussion
rockfish
2 years agoRegular Visitor
Eventstream from On-Premise (Azure VM) SQL Server CDC?
We have SQL Server Enterprise running on an Azure VM. While we are able to create a gateway, there does not appear to be a connector to bring it through an Evenstream. Our objective is to keep our ...
xujx
2 years agoMicrosoft Employee
rockfish Ingesting cdc data from on-prem SQL Server with Eventstream is in our roadmap of Eventstream. We are actively researching on this scenario to work out the best experience for this scenario.
When you say "Our objective is to keep our (logical) bronze layer in sync with the source database", how do you bring your initial snapshot to the target bronze layer from the source database? using certain batch copy job or you expect the cdc to bring the initial snapshot to bronze layer as well?