How to export a database from Azure Managed Instance to your local SQL Server instance

1) EXPORT a database from an Azure Managed Instance by creating a .bacpac file using SqlPackage.exe:

SqlPackage.exe /Action:Export /ssn:tcp:yourmanagedinstance.public.12345qwerty.database.windows.net,3342 /sdn:YourDatabaseName /su:yourusername /sp:YourP@$$word! /tf:C:\temp\YourDatabaseName.bacpac /p:VerifyExtraction=false /p:Storage=File

YOU SHOULD RUN THE COMMAND ABOVE USING CMD FROM THE FOLLOWING DIRECTORY:

C:\Program Files\Microsoft SQL Server\160\DAC\bin

This is beacuse the SqlPackage.exe is located there.

160 might be replaced by the relevant folder (for example 140).

To change directory in cmd, simply run "cd" followed by your location

For example:

cd C:\Program Files\Microsoft SQL Server\160\DAC\bin

2) IMPORT the database to your local instance file using the .bacpac file:

SqlPackage.exe /a:Import /sf:C:\temp\YourDatabaseName.bacpac /tdn:YourDatabaseName /tsn:YOUR-SERVER-NAME*

*use the following T-SQL command to get your server name:

PRINT @@SERVERNAME

Abbreviations:

/SourceServerName: /ssn

/SourceDatabaseName: /sdn

/SourceUser: /su

/SourcePassword: /sp

/TargetFile: /tf

/Properties: /p