Azure Managed Instance Database Backup and Restore including CDC Data?

Question

I currently have a database on an Azure SQL Managed Instance, with Change Data Capture ("CDC") enabled and working. How can I get a full copy of this database, including the CDC tables and data, into a different development server for testing? Backup/Restore? Import/Export Data Tier Application? BACPAC vs DACPAC vs BAK? SSMS, Azure Data Studio, SSDT, SqlPackage.exe?

The AI-generated answer says to use SSMS or Azure Data Studio, but I cannot get either to work for me. SSMS gives me the error "The backup operation for a database with service-managed transparent data encryption is not supported on SQL Database Managed Instance." Azure Data Studio gives me the error "Backup Database: Backup failed for Server 'xxxxxx.yyyyyyyy.database.windows.net'.
An exception occurred while executing a Transact-SQL statement or batch." Help!

Answer 1

Backup/Restore would be the way to go, but you would need to change to customer-managed key for TDE to be able to do that.

There is copy/move-facility as described here: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/database-copy-move-how-to?view=azuresql-mi&tabs=azure-portal. But the last bullet point is disappointing:

You'll need to reconfigure transactional replication, change data capture (CDC), or distributed transactions after you move a database that relies on these features.