Skip to content

Instantly share code, notes, and snippets.

@jknopp

jknopp/sqlpackage.md

Forked from anova/sqlpackage.md
Created October 22, 2020 00:57
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 jknopp/d460cfc04b61decaf234402b0453ad26 to your computer and use it in GitHub Desktop.
Save jknopp/d460cfc04b61decaf234402b0453ad26 to your computer and use it in GitHub Desktop.
Download ZIP
Sqlpackage.exe samples
Raw
sqlpackage.md

Export

Creates a .bacpac file from live database.

"C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\SqlPackage.exe" /a:Export /scs:"Data Source=SERVER;Initial Catalog=db_name;Integrated Security=False;Persist Security Info=False;User ID=db_user;Password=db_password" /tf:"D:\backup\database_backup.bacpac"

Import

Import from .bacpac file to database.

"C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\SqlPackage.exe" /a:Import /sf:D:\backup\database_backup.bacpac /tcs:"Server=.\SQLEXPRESS;Database=db_name;Trusted_Connection=True;"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment