Syncing from MySQL to MS SQL using CDC

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

Exploring the possibility of syncing data from a MySQL cursor-based source to a CDC-based MS SQL destination


Question

Hi, I’m EL’ing from an mysql db (source) to an ms sql db (destination). Neither I have control over.
Using cursor syncing is very slow and I was thinking to try CDC sycning.

The mysql db is run by a vendor, and won’t change anything on my behalf. However, I can ask our ICT team to make changes to the MS SQL server, such as turning on CDC.

Q. Will syncing using a cursor-based source (mysql) to CDC-based destination (MS SQL) work? Or must both the source and destination DB’s have CDC enabled?


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["mysql", "ms-sql", "cdc", "cursor-syncing", "syncing"]
2

I think they don’t depend on each other, but that’s not my area. Worth an experiment I’d say

3

That’s my understanding, but wanted to have a definite answer before asking ICT to make changes to the DB server.

4

I hear you. I’ll ping our DB sources / destinations folks to make sure. AFAIK, Source DB connector can be CDC, and destination can be whatever you want —an API destination to google sheets as far as we’re concerned, they’re not relying on each other in any way.

5

Hi <@U069EMNRPA4>, any updates from the DB team?