SQL 2012 - Need to migrate the symmetric Key to Enterprise Edition from Standard

• ramsql.blogpost

  SSC Veteran

  Points: 230

  More actions

  March 16, 2020 at 10:16 am

  #3734644

  Hi,

  I have a database in SQL 2012 Standard Edition with few columns encrypted with Symmetric Key. I have a requirement to migrate the database to Enterprise Edition. I tried it in Testing environment to restore the DB and Keys. When I query the columns, it showing nulls.

  Can anybody suggest me, how to migrate the keys to different edition.

   

   

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  March 17, 2020 at 11:10 am

  #3734936

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Joie Andrew

  One Orange Chip

  Points: 27360

  More actions

  March 18, 2020 at 8:09 am

  #3735224

  How are the symmetric keys encrypted? Is it with a certificate?

  Joie Andrew
  "Since 1982"