Symmetric Key

Question

When you have a Symmetric Key within the SQL Server Data Tools (SSDT) project, the publish script always drops & recreates the Symmetric Keys.  The end result is the decryption is basically destroyed.  

Is there a way to fix this or is this a known bug?

Thanks

Answer 1

That is not what I am seeing, how are you defining and using the symmetric key? Which objects depend on the symmetric key?

What is in the deployment script? If you schema compare what does that state the difference between the source and the target is?

---

-GertD @ www.sqlproj.com

Answer 2

Chris, are you still experiencing this issue?  If so, please address the questions above.

Thanks,

Janet Yeilding

Answer 3

No actionable data provided, so marking as answered.  We will reopen investigation if more info is provided.