HUB
Sign inSign up

christoment/sqlpackage-docker

By christoment

•Updated over 6 years ago

SQL package in Docker

Image
0

50

christoment/sqlpackage-docker repository overview

⁠MSSQL/Sqlpackage Docker Image

Baked in sql package in docker, and MSSQL + sqlpackage in docker as well.

⁠Usage:

There are two version of the docker image provided:

  1. Standalone sqlpackage⁠
  2. MSSQL + sqlpackage⁠
⁠Standalone sqlpackage
  1. Build docker image
    # in sqlpackage-docker
    ./build.ps1
    
  2. Prepare your input script in a folder. (e.g. input/data.bacpac)
  3. Run the standalone docker image with volume mounting input folder to /app.
    docker run `
        -v C:\input:/app/input `
        sqlpackage-docker `
        # add your sqlpackage arguments here. e.g. :
        /a:Import `
        /sf:"/app/input/data.bacpac" `
        /tcs:"Server=host.docker.internal,1433;User ID=sa;Password=1234;Database=master-imported" 
    
⁠MSSQL + sqlpackage
  1. Build docker image
    # in mssql-sqlpackage-docker
    ./build.ps1
    
  2. Prepare your input script in a folder. (e.g. input/data.bacpac)
  3. Run the docker image as daemon, and expose the port.
    docker run `
        -p 1434:1433 `
        -d `
        -v C:\input:/app/input `
        mssql-sqlpackage-docker
    # Container ID 4c4d65fd014c
    
  4. Run the script via docker exec. Note that sqlpackage is already available in the image.
    docker exec 4c4d65fd014c `
        sqlpackage `
        # add your sqlpackage arguments here. e.g. :
        /a:Import `
        /sf:"/app/input/data.bacpac" `
        /tcs:"Server=localhost,1433;User ID=sa;Password=1234;Database=master-imported" 
    

Tag summary

Content type

Image

Digest

Size

102.5 MB

Last updated

over 6 years ago

docker pull christoment/sqlpackage-docker:0.1.0