October 10, 2017 at 9:41 am
Hi,
I need to generate a public/private key for AES256. This public key will be used in a MYSQL dbase to encrypt. After I've loaded this data into SQL Server I want to decrypt with my private key.
I'm reading about CREATE ASYMMETRIC KEY here
CREATE ASYMMETRIC KEY AnAsymmetricKey
WITH ALGORITHM = AES_256;
How can I output the public key? I need to share it with a 3rd party.
October 10, 2017 at 9:52 am
Oh I think I found it :
SELECT Name, public_key
FROM sys.asymmetric_keys;
Do you think this public_key varbinary can be used with MYSQL?
October 10, 2017 at 10:12 am
leehbi - Tuesday, October 10, 2017 9:52 AMOh I think I found it :
SELECT Name, public_key
FROM sys.asymmetric_keys;Do you think this public_key varbinary can be used with MYSQL?
Used how, exactly? Both SQL Server and MySQL would have to use the exact same encryption and decryption algorithms in order to make it practical to store encrypted data in MySQL that was encrypted by SQL Server and then you say, wanted to decrypt it using MySQL. I don't know enough about the encryption methods to know whether just being AES256 is enough of a standard that there can't be deviation in methodology.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 10, 2017 at 10:17 am
My public key will be used in MYSQL to encrypt the data. Once I load the encrypted data to SQL Server I will use the private key to decrypt the data.
I suppose we should give it a try.
October 10, 2017 at 10:25 am
You would have to assume that both database engines use the exact same encryption AND decryption algorithms, and yes, you should go ahead and test it pretty thoroughly. Last thing you would need is to find out 6 months down the road that while they have an ever so slightly different method somewhere in the mix and it results in differences in decryption. I'm not so sure that even if I could test it thoroughly, that I'd want to rely on that kind of thing. I might prefer to do encryption and decryption entirely within the same database engine, if for no other reason than to maintain a secure transaction.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply