SqlServer (Query with Full-Text Search)

readme.md

Build Image

docker build -t image/mssql-fulltextsearch:2017-latest .

Run container

docker run --name mssql -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=yourStrong(!)Password" -e "MSSQL_AGENT_ENABLED=true" -p 1433:1433 -d image/mssql-fulltextsearch:2017-latest

Check that the Full Text Search installed

Run query:

SELECT CASE WHEN FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1 THEN 'INSTALLED' ELSE 'NOT INSTALLED' END IsFullTextInstalled

docker-compose.yml

version: '3.4'
services:
  sqlserver-express:
    build: .
    context: .
      dockerfile: Dockerfile
    container_name: sqlserver-express
    environment:
      SA_PASSWORD: '${SA_PASSWORD}'
      ACCEPT_EULA: 'Y'
      MSSQL_AGENT_ENABLED: '${MSSQL_AGENT_ENABLED}'
    ports:
      - '1433:1433'
    hostname: sqlserver-express
    healthcheck:
      test: ["CMD", "/opt/mssql-tools/bin/sqlcmd", "-Usa", "-PyourStrong(!)Password", "-Q", "select 1"]
      interval: 1s
      retries: 20
    volumes:
      - './docker-volumes/database-application-sqlserver/scripts:/scripts'

Dockerfile

FROM ubuntu:16.04

RUN export DEBIAN_FRONTEND=noninteractive && \
    apt-get update && \
    apt-get install -yq curl apt-transport-https && \
    curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - && \
    curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list | tee /etc/apt/sources.list.d/mssql-server.list && \
    apt-get update && \
    apt-get install -y mssql-server && \
    apt-get install -y mssql-server-ha && \
    apt-get install -y mssql-server-fts && \
    apt-get clean && \
    rm -rf /var/lib/apt/lists

CMD /opt/mssql/bin/sqlservr