dotnet
Investigate BuildAssetRegistry (BAR) migration
As a part of the Charter Alignment epic, we want to move the BAR into a subscription that's owned by Prod Con. To do this, we will have to make an exact copy of the database in the new Sub, and validate it somehow.
This method should work on both PME, and non PME subscriptions, as both would be needed at some point
Currently the SqlPackage dotnet tool looks like the most promising lead.
We should be able to use something like SqlPackage /a:Export /tf:testExport.BACPAC /scs:"Data Source=<connection string>" /ua:True /tid:"<tenant id>" to export the database, and then SqlPackage /Action:Import /SourceFile:"C:\testExport.bacpac" /TargetConnectionString:"<target connection string>" to import it in a different SQL server
The question is can we use this tool on a SAW