Provisioning sanitized data with SQL Clone and Data Masker. Watch now.

SQL Clone TDE Strategies

sgtmango333sgtmango333 Posts: 6 Bronze 1
edited October 14, 2021 3:43PM in SQL Clone
I've read Steve Jones's article from 2017 regarding using SQL Clone with TDE enabled databases.  The workaround was restoring the DEK to the target server prior to deploying the clone.  This is all well and good but that means that if we want developers to self serve Production data to any VM the DEK and DMK have to be shared.  The only work around to this that I can see is to decrypt and re-encrypt with a new set of DEK/DMK.  

I'm hoping that in the last 4 years there have been some improvements that would be better than this solution?

https://www.red-gate.com/hub/product-learning/sql-clone/sql-clone-and-databases-protected-with-tde?_ga=2.176391589.1641945622.1634219305-1860034375.1625599001


Tagged:

Answers

Sign In or Register to comment.