Azure
Data & Analytics
intermediate
CDC Data Replication — Azure Architecture Template
Continuous change-data-capture replication from a source SQL estate into SQL Managed Instance over a private network.
Why this architecture works
- Online CDC migration keeps the source live — cutover is a DNS flip, not a maintenance weekend
- All replication traffic stays inside the VNet; nothing transits the public internet
- Staging storage holds backup chains so full loads and log shipping are restartable
- SQL Managed Instance preserves agent jobs and cross-database queries, minimizing app rework
- Migration service metrics feed Log Analytics with alerting on replication lag
What's inside (8 resources)
Source SQL
sql-server
Private Network
virtual-network
CDC Service
database-migration-service
Backup Staging
storage-account
Target SQL MI
sql-managed-instance
Secrets
key-vault
Logs
log-analytics-workspace
Lag Alerts
monitor
From template to running infrastructure
- Open this template in the CloudForge visual designer (free account, no credit card).
- Customize resources, names, and connections on the drag-and-drop canvas — or ask Vani, the AI architect, to adapt it.
- Generate production-ready Terraform, ARM, or Bicep in one click.
- Review the plan diff and security scan, then deploy with human approval.