I have a table with one coumn encrypted using SQL encryption. What i need to do is extract this data, encrypted but in a readable format (in the table, the encrypted data looks like asian characters), and send it off to a vendor who will then import and
decrypt the data. I've worked through the requirements of db master key/certificate and symmetric key being the same on both our end and the vendor's end.
But i cannot generate a text file properly. I use the import/export wizard and select 'unicode' and when i do a preview i can see the encrypted data string. After i generate the txt file, and load it into my new test database, apply the same db master key/certificate
and symmetric key, and then try to decrypt the data, the clumn shows NULL values.
Can someone help out with what im doing wrong in the file generation? Should i be using import/export wizard or something else like bcp?
Thanks in advance
View Complete Post