Home / server / Questions / 633770
Accepted
Vimvq1987
Asked: 2014-10-06 23:16:37 +0800 CST

How to re-create the symmetric key on Amazon RDS

  • 772

We have some column encrypted by symmetric key. Now we want to upload our database to Amazon RDS (SQL Server).

Can we do that? If yes, how?

sql-server

1 Answers

  1. Best Answer

    The short answer is: maybe.

    If you created the key with the KEY_SOURCE argument when you created the key and you have the value that you specified at creation time, then you'd just issue the same create symmetric key statement again in RDS and you should have the same key as in your source.

    If you didn't do that, then no. It doesn't appear that there is something like backup symmetric key.

    • 0