CODEWITHSUNDEEP
sql-serverazure-sql-database
SamJolly
SamJolly

Reputation: 6477

how to insert encrypted column data in SQL Server / SQL Azure

I have 2 (DB1,DB2) databases in SQL Azure.

DB1.Customer
DB2.Customer

Each has column called Surname which is column encrypted.

I want to insert records from DB1.Customer to DB2.Customer. I initially tried a Data Compare tool, but it omitted the encrypted column ie "Surname". Is my only way to do this, is to decrypt "Surname", recompare, insert data, re-encrypt "Surname" column for both DBs, or is there another way to avoid decryption.

I have also tried:

1) SSMS / Tasks/ Generate Scripts / Advanced / Data only but the encrypted data is shown as "binary" in the SQL.

Thanks in advance.

Upvotes: 1

Views: 1356

Answers (1)

Leon Yue
Leon Yue

Reputation: 16401

I think this is refer to Migrate Sensitive Data Protected by Always Encrypted.

The following table shows the recommended settings appropriate for several migration scenarios.

enter image description here

Hope this helps.

Upvotes: 1

Related Questions