sqlpackage + sqlcmd + dockerize
124
*nix
docker run --rm -it \
-v ${pwd}/data:/work/data \
chrisgarrett/sqlpackage:20.05.09 \
sqlpackage /a:Import /tsn:sqlserver /tdn:"nwind" /tu:sa /tp:"SaPassword" /sf:"/work/data/northwind.bacpac"
Windows cmd
docker run --rm -it -v %cd%/data:/work/data chrisgarrett/sqlpackage:20.05.09 sqlpackage /a:Import /tsn:sqlserver /tdn:"nwind" /tu:sa /tp:"SaPassword" /sf:"/work/data/northwind.bacpac"
Windows Powershell
docker run --rm -it -v ${pwd}/data:/work/data chrisgarrett/sqlpackage:20.05.09 sqlpackage /a:Import /tsn:sqlserver /tdn:"nwind" /tu:sa /tp:"SaPassword" /sf:"/work/data/northwind.bacpac"
See the example folder for a more complete demonstration of sqlpackage loading northwind into sqlserver. Requires go-task:
cd example
task restart log
Used Christian Grotheer's work as a launch point https://github.com/grthr/docker-sqlpackage
Content type
Image
Digest
Size
89 MB
Last updated
over 6 years ago
docker pull chrisgarrett/sqlpackage:18.5