Post reply

Always encrypted and existing Sql code

  • November 14, 2018 at 2:22 pm

    #373066

    Hello all

    We are upgrading some of our sql servers from 2012/2014 to 2016 so we can use always on encryption.

    The migration of the database to the new install of sql server went easy. Working out how to turn on always on encryption, easy job. Finding out how to set a load of columns over serval tables to always on, harder but we sorted it. 

    Now the question that I can not find an answer too or an example of someone else doing this. If you have a proc from the sql 2012/2014 and run it it fails because it not work with encrypted data, even basic selects from one table and insert into another fails.

    How can we migrate the database without re-writing all the code we have spent years working on. Surely sql server doesn't need us to re-write every insert, update or delete etc because of this feature.

    Thanks in advance

    Danny

  • November 19, 2018 at 2:42 pm

    #2014039

    danny.prior - Wednesday, November 14, 2018 2:22 PM

    Hello all

    We are upgrading some of our sql servers from 2012/2014 to 2016 so we can use always on encryption.

    The migration of the database to the new install of sql server went easy. Working out how to turn on always on encryption, easy job. Finding out how to set a load of columns over serval tables to always on, harder but we sorted it. 

    Now the question that I can not find an answer too or an example of someone else doing this. If you have a proc from the sql 2012/2014 and run it it fails because it not work with encrypted data, even basic selects from one table and insert into another fails.

    How can we migrate the database without re-writing all the code we have spent years working on. Surely sql server doesn't need us to re-write every insert, update or delete etc because of this feature.

    Thanks in advance

    Danny

    Hate to say this Danny, but surely you didn't expect to encrypt data, and then have a simple SELECT statement actually be able to retrieve it, did you?   If that were the case. encryption would be useless, as all a hacker would need to do is select the data.   Not a good plan to encrypt data with no knowledge of how to decrypt it..

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

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

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