microsoft / microsoft/DacFx

Add Sqlpackage to MS APT repo or MSSQL image

Open
#252 5 comments 1 reaction 0 assignees View on GitHub

Nobody has claimed this yet.

backlog enhancement
Dominant language
C#
Stars
460
Forks
29
Avg merge
4d 9h
Merged PRs (30d)
7

Description

**Is your feature request related to a problem? Please describe.**
I've created a custom MSSQL container image to support 2 workflows.

1) Run container without existing database, use DACPAC to create database.
2) Attach an existing database and apply an updated DACPAC.

Sqlpackage is required to do this but not available on the base image or through Microsoft's APT repository.

**Describe the solution you'd like**
Ideally, Sqlpackage would be added to the Microsoft APT repository as an installable package or bundled with other tools like Sqlcmd (/opt/mssql-tools/bin/sqlcmd) in the official MSSQL Docker image.

**Describe alternatives you've considered**
The current workaround to Sqlpackage not being available is to install unzip, download the Sqlpackage zip file from Microsoft's website, extract and set it as executable. This is several lines of abstraction over what could be a simple `RUN apt-get update && apt-get install sqlpackage`

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Review the requested packaging targets: the Microsoft APT repository and the official MSSQL Docker image, including the existing /opt/mssql-tools/bin/sqlcmd location. Compare them with the unzip workaround and the proposed apt-get install sqlpackage flow. Done means Sqlpackage is available through an installable APT package or bundled in the official image.

Written by the indexing model from the issue text.

Assessment

Tech stack
docker, linux, sql
Domain
database, devops, infrastructure
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.