Copy and Move Databases with TDE Protector in Azure SQL MI

In this video Bradley Ball walks us through the Copy & Move mechanisms in Azure SQL Managed Instance.  We start by ensuring that there is networking connectivity between the Azure SQL Managed Instance networks.  We also show the error if TDE is in place on one instance but the same key is not accessible on the other SQL Managed Instance.  To this end we will connect the 2nd Azure SQL Managed Instance to the TDE Key stored in Azure Key Vault, we connect this with the TDE protectorate option enabled (but we note in the video that may not be the option you want to choose and why!).  We then execute the Copy process & then a Move operation.  Chapters: 00:00 Establishing Scenario Context  01:52 Evaluating VNets for conflicting IP's 02:02 Peering VNets  02:40 Copy Attempt 1 03:42 TDE Encryption Adding Customer Managed Key 04:09 IMPORTIANT A note about TDE protector IMPORTIANT 05:15 Continuing Adding Customer Managed Key to Instance 2 06:04 Copy Attempt 2 07:34 Moving a Database from Managed Instance 1 to Managed Instance 2 Recommended content: Copy or move a database - Azure SQL Managed Instance: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/database-copy-move-how-to?view=azuresql Virtual network peering: https://learn.microsoft.com/en-us/azure/virtual-network/virtual-network-peering-overview PowerShell and Azure CLI: Enable Transparent Data Encryption with customer-managed key from Azure Key Vault: https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-configure?view=azuresql&tabs=azure-powershell What is Azure SQL Managed Instance?: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview?view=azuresql What's new in Azure SQL Managed Instance?: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/doc-changes-updates-release-notes-whats-new?view=azuresql How to do more with less in Azure SQL Managed Instance?: https://techcommunity.microsoft.com/t5/azure-sql-blog/quick-tips-how-to-do-more-with-less-in-azure-sql-managed/ba-p/3733435 2022 - a year of unparalleled innovation in Azure SQL Managed Instance: https://techcommunity.microsoft.com/t5/azure-sql-blog/2022-a-year-of-unparalleled-innovation-in-azure-sql-managed/ba-p/3676757