Hello Dear Reader! I was working with some friends lately and we needed to set up a process to refresh their Development Environment databases from Production. Additionally, the databases are encrypted using Transparent Data Encryption, The SQL MI instances are in different regions, and the SQL MI Instances are in different subscriptions. To duplicate the environment, in order to match our friends, we did the following setup.
Click through for a high-level overview, step-by-step guidance, and a whole lot of detail.