Replication involving MS SQL Server sources/targets is not supported if they have enabled security features such as Always Encrypted or Row-Level Security.
Desired State:
Using the Oracle database endpoint as a precedent which supports encrypted columns, the ability to configure encryption keys in the SQL Server endpoint for source read or target write when the Always Encrypted/RLS feature set(s) are enabled.
Business Case:
Evolving governance, privacy, and security requirements both internal and external to a given organization are demanding that highly sensitive data be encrypted in all states and during all transits, down to the field level.
NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.