Andy Brownsword needs to make a call out:
One method for transferring a database to a different environment is using a Data-Tier Application – in the form of a DACPAC (for schema) or BACPAC (for schema and data).
Trying to use this approach with multi-database solutions is a challenge though as Data-Tier Applications don’t play nicely with cross-database objects.
Let’s look at how we can ease that pain.
Read on for the solution.