Sign inSign up

eduardomex/mssql-server-fts-sqlpackage-linux

By eduardomex

Updated about 5 years ago

Microsoft SQL Server with Full-Text Search and SQLpackage

Image
0

342

eduardomex/mssql-server-fts-sqlpackage-linux repository overview

Example of setting up a container, creating a database, copying a .bacpac file over, and importing it into aforementioned database:

  docker run -d -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=<YourStrong!Passw0rd>' -p 1433:1433 --name sqlfts1 mssql-server-fts-sqlpackage-linux

  docker exec -it sqlfts1 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P '<YourStrong!Passw0rd>' -Q 'CREATE DATABASE MyDb0'

  docker cp ~/Downloads/foo.bacpac sqlfts1:/opt/downloads/foo.bacpac

  docker exec -it sqlfts1 dotnet /opt/sqlpackage/sqlpackage.dll /tsn:localhost /tu:SA /tp:'<YourStrong!Passw0rd>' /A:Import /tdn:MyDb0 /sf:foo.bacpac
                
      

The full Dockerfile is:

# MySQL-Server with SQLpackage and full-text-search installed on Ubuntu
#
# VERSION               0.0.1

FROM ubuntu:16.04
#FROM microsoft/mssql-server-linux:latest

RUN apt-get update -qq && \
  apt-get install -y curl apt-transport-https software-properties-common locales

RUN echo DOTNET_CLI_TELEMETRY_OPTOUT=1 >> /etc/environment
RUN locale-gen en_US.UTF-8 && \
  printf 'LANGUAGE=en_US.UTF-8\nLC_ALL=en_US.UTF-8\n' >> /etc/default/locale

RUN mkdir -p /opt/downloads
WORKDIR /opt/downloads

RUN curl -q https://packages.microsoft.com/config/ubuntu/16.04/packages-microsoft-prod.deb -O
RUN dpkg -i packages-microsoft-prod.deb 

RUN curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
RUN add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)"
RUN add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list)"
RUN apt-get update -qq && \
  ACCEPT_EULA=Y apt-get install -y unzip dotnet-sdk-2.1 mssql-server-fts mssql-tools unixodbc-dev
RUN echo PATH="$PATH:/opt/mssql-tools/bin" >> ~/.bash_profile
RUN echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc

RUN curl -Lq https://go.microsoft.com/fwlink/?linkid=2165213 -o sqlpackage-linux-x64-latest.zip
RUN ls -alh
RUN unzip sqlpackage-linux-x64-latest.zip -d /opt/sqlpackage

EXPOSE 1433/tcp

CMD /opt/mssql/bin/sqlservr

Reference: https://hub.docker.com/r/samuelmarks/mssql-server-fts-sqlpackage-linux

Tag summary

Content type

Image

Digest

Size

1.3 GB

Last updated

about 5 years ago

docker pull eduardomex/mssql-server-fts-sqlpackage-linux