Post reply

Export encryption keys to SQL 2019 from MySQL

  • May 12, 2021 at 1:35 pm

    #3882340

    Hi

    My customer is migrating from MySQL to SQL 2019 using SSMA, thier current MySQL uses PHP and encrypts columns within a few tables, is there a way to get this decrypted or the key copied over to SQL Server. I have not done an MySQL to SQL migration before the reason for the question.

    Regards

    Raxso1

  • May 12, 2021 at 3:11 pm

    #3882383

    You will have to understand what type of encryption is being used. If PHP is doing the encryption, then you may or may not need to decrypt the data. You could have the same application read the data and decrypt it. If you need to decrypt it, then you need to know the key and the algorithm, as encryption is a general concept. The specific way to encrypt things can be different in any application.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply