Replace Managed Instance replication with CDC and ADF or Azure Function?
0
votes
1
answer
431
views
The company I work for put everything on Azure. We use SQL Server replication to move data from one big collection db server (Managed Instance) to our other database servers (say 20 in total).
Every day we publish around 10 million (some days will be more, say 100 million plus) new/updated data in various databases.
We can only have one publisher (my understanding), and fairly often, we see replication commands get built up, things slow down, and our DBAs will firefight to get things moving.
In the database server where all the data is collected, we enabled CDC change tracking.
I am wondering if I should create 10 or 20 Azure functions (C# code) to periodically pull changes from CDC. These Azure functions will then copy the changes to our 20 database servers (say all these servers need all these data).
Would this be a reasonable alternative to replication?
For me, each Azure function acts like a distributor, so we suddenly will have 10 or 20 distributors other than just one.
I could use Azure Data Factory to do it, but it is way too expensive compared to Azure functions in my case.
Is this a good idea or would we have any big issues?
Asked by jerry xu
(63 rep)
Jan 5, 2023, 11:22 PM
Last activity: Mar 5, 2025, 07:36 AM
Last activity: Mar 5, 2025, 07:36 AM