Encryption & Decryption in SQL Server

• haichells

  SSCrazy

  Points: 2713

  More actions

  June 18, 2024 at 10:57 am

  #4429365

  Dear All,

  I have a requirement as below,

  Export a table/query output in a file with encrypted format.

  Import the file content to a table in a different server SQL database and decrypt the content. I request forum members to help on this please. Thanks in Advance!

  Chella

   

   

   

• Ken McKelvey

  SSCoach

  Points: 18842

  More actions

  June 18, 2024 at 3:23 pm

  #4429436

  Your question is too open-ended.

  You need to provide details of the process, versions of SQL Server etc.

   

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  June 19, 2024 at 9:49 am

  #4429659

  aside what Ken stated, what have you done so far to produce your own solution

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉