I have a few AWS EC2 instances currently running SQL Server 2016. I'd now like to upgrade these to SQL Server 2019 but the problem is that some of the data has been encrypted at the column level. I understand that, after SQL 2016, the encryption algorithm changed from SHA1 to SHA2. Would this data "survive" the upgrade or would I need to always start SQL with trace flag 4631 enabled?
Is there a way to decrypt using SHA1 and re-encrypt with SHA2 on the same server so I don't have to worry about this in the future?