@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 @supports_net_changes = 1; -- all ...
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 ...