Satyasai
Contributor

@srikanthp24 
Before Moving, Please consider the following Questions

Can the source SQL Server handle the additional CDC read load? (While adding a second pipeline will not break the Dev pipeline, it doubles the CDC query load on your production SQL Server.)
What is the CDC log retention window on SQL Server? Ensure your SQL Server CDC cleanup retention period is set long enough (e.g., 3–7 days). If one environment (e.g., UAT) is paused for several days and CDC logs are cleaned up on SQL Server before UAT resumes, the UAT pipeline will throw an out-of-range offset error and require a re-sync.
Are service accounts and network paths validated?

My Idea is Deploying via DABs (Best Practice Workflow)