I need to migrate a SQL 2012 database that has a few tables with encrypted columns, to a SQL 2016 instance. I have done this same process between two 2012 instances, and it always worked, but I am unable to do so with 2016. Below is the code I run after I restore the database to 2016, and it's the exact same code that I ran when I restored to 2012. Does anyone know if backup/restore of databases with encrypted columns works between different versions SQL instances?
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'Some Password';
ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY;
CLOSE MASTER KEY;