To test the always encrypted feature in SQL Server 2016, Follow the below test steps,
- Create a table with encrypted column, refer here to set up.
- Insert a data into the table
- Use client application to insert a data, refer here.
- Export and import from another table, refer here.
- Check the table result
Tables used in my test,
- Employees – Always Encrypted on TaxID & Salary fields