There are two options here that I can think of,
Option 1:
- Install the CTE agent on the new DB server and deploy with policy the same keys.
Option 2:
- backup the database and define the rules with Backup process and Action - Permit and Apply Key so the data will be decrypt during backup process then restore to the new server.
We can't decrypt the data with CTE agent.
------------------------------
TS Teh
------------------------------