Installing MSSQL server express using docker with full text search support

user_1202349 0
Viewed 2694

I am using mssql express for ubuntu on docker. I just found that it does not support full text search. I believe the mssql express supports this, but found no way to enable this feature.

Here is the image I'm using.

image: mcr.microsoft.com/mssql/server:2017-latest-ubuntu

I am passing express edition as environment as MSSQL_PID: "Express".

How can I have full text search installed on the same image ?

docker sql-server-express sql-server
1 Answers

Default mssql docker image does not support fts, i.e. full text search, therefore we need to create the custom sql image.

Here is the dockerfile for the same... based on the microsoft repo at https://github.com/Microsoft/mssql-docker/blob/master/linux/preview/examples/mssql-agent-fts-ha-tools/Dockerfile

# Maintainers: Microsoft Corporation (twright-msft on GitHub)
# GitRepo: https://github.com/Microsoft/mssql-docker

# Base OS layer: Latest Ubuntu LTS
FROM ubuntu:16.04

# Install prerequistes since it is needed to get repo config for SQL server
RUN export DEBIAN_FRONTEND=noninteractive && \
    apt-get update && \
    apt-get install -yq curl apt-transport-https && \
    # Get official Microsoft repository configuration
    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 && \
    # Install SQL Server from apt
    apt-get install -y mssql-server && \
    # Install optional packages
    apt-get install -y mssql-server-ha && \
    apt-get install -y mssql-server-fts && \
    # Cleanup the Dockerfile
    apt-get clean && \
    rm -rf /var/lib/apt/lists

# Run SQL Server process
CMD /opt/mssql/bin/sqlservr
user_12023490
Related