Microsoft SQL Server with Full-Text Search and SQLpackage
50K+
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 sqlfts0 mssql-server-fts-sqlpackage-linux
docker exec -it sqlfts0 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P '<YourStrong!Passw0rd>' -Q 'CREATE DATABASE MyDb0'
docker cp ~/Downloads/foo.bacpac sqlfts0:/opt/downloads/foo.bacpac
docker exec -it sqlfts0 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=873926 -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
Content type
Image
Digest
Size
1.3 GB
Last updated
about 8 years ago
docker pull samuelmarks/mssql-server-fts-sqlpackage-linux