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

  • ramsql.blogpost

    SSC Rookie

    Points: 43


    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: 80378

    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: 27295

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

    Joie Andrew
    "Since 1982"

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply