Skip to content

Instantly share code, notes, and snippets.

@RichieBzzzt

RichieBzzzt/restoreBacpac.txt

Last active September 22, 2017 11:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save RichieBzzzt/06ab5246f884cb4c73e247bb22badff7 to your computer and use it in GitHub Desktop.
Save RichieBzzzt/06ab5246f884cb4c73e247bb22badff7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
restoreBacpac.txt
"C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\SqlPackage.exe" /Action:Import /SourceFile:"C:\Users\Richie\Downloads\WideWorldImportersDW-Standard.bacpac" /TargetConnectionString:"Server=tcp:{yourdb}.database.windows.net,1433;Initial Catalog=sioEverestDb;Persist Security Info=False;User ID={uid};Password={pword};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"
"C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\SqlPackage.exe" /Action:Import /SourceFile:"C:\Users\Richie\Downloads\WideWorldImporters-Standard.bacpac" /TargetConnectionString:"Server=tcp:{yourdb}.database.windows.net,1433;Initial Catalog=sioEverestDb;Persist Security Info=False;User ID={uid};Password={pword};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment