How to import Azure SQL backup (.bacpac) to LocalDB using Visual Studio?
For me the right command to use was:
.\SqlPackage.exe /Action:Import /SourceFile:"c:\temp\your.bacpac" /TargetConnectionString:"Data Source=(localdb)\mssqllocaldb;Initial Catalog=DBNAME;Integrated Security=true;"
Otherwise I would get an error:
*** Error importing database:Could not import package.
Unable to connect to master or target server 'DBNAME'. You must have a user with the same password in master or target server 'DBNAME'.
Using VS2015, in the location specified by anjdreas:
C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\130
If you have this folder on your machine C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin then you can run this command to restore the bacpac file:
.\SqlPackage.exe /Action:Import /SourceFile:"c:\temp\your.bacpac" /TargetConnectionString:"Data Source=(localdb)\v11.0;Initial Catalog=devdb; Integrated Security=true;"
If that folder's missing you will need to download the tooling from Microsoft.