Encryption/Decryption - Oracle DB, MS SQL
Alan3Nov 2 2011 — edited Nov 2 2011Is it possible to pass encrypted data between Oracle & MS SQL db? For instance a way to share the encryption keys between the two so a value encrypted by one database can be decrypted by the other?
It seems the DBMS.CRYPTO package allows for this sort of thing but I'm having trouble uncloaking the encryption scheme by MS SQL...
Has anyone done this in the real world?