@source_name = 'sql_server_versions', @role_name = 'cdc_user', -- everyone (except sysadmin and db_owners) must be member of this role to access change tables ...
This tutorial describes how to use change data capture (CDC) in Copy job to efficiently replicate data changes from Azure SQL Database to a destination. This ensures your destination data stays up to ...