Two way encryption: SQL Server > MySQL

[kidestrangedd]

I want to encrypt a field in SQL Server 2005 using a key and then decrypt that value after transferring the data to a MySQL database. It doesn't have to be bulletproof but I'd rather not have the values in plain text. Does anyone know which two way encryption functions can be shared between that databases?

[Moharo]

hey, this this:

http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html

you could do it with AES_ENCRYPT() and AES_DECRYPT()

Thanks