Docker for MSSql

docker for mssql.md

1. start MSSql with docker-compose

version: "3"
services:
  mssql:
    container_name: dc-mssql
    environment:
      ACCEPT_EULA: Y
      SA_PASSWORD: P@ssw0rd
    image: mcr.microsoft.com/mssql/server
    ports:
      - "1433:1433"
    volumes:
      - ./mssql:/var/opt/mssql
      - <unzip folder>:/home/mssql

2. use a CLI or GUI to connect MSsql

• Download and install - Azure Data Studio | Microsoft Docs

3. run the sql command:

USE [master]
RESTORE DATABASE [sc_cydb_w500]
FROM  DISK = N'/home/mssql/sc_cydb_w500'
WITH
    FILE = 1,
    MOVE N'sc_cydb_w500_noindexd' TO N'/var/opt/mssql/data/sc_cydb_w500_noindexd.ndf',
    MOVE N'sc_cydb_w500_noindexe' TO N'/var/opt/mssql/data/sc_cydb_w500_noindexe.ndf',
    MOVE N'sc_cydb_w500_noindexf' TO N'/var/opt/mssql/data/sc_cydb_w500_noindexf.ndf',
    MOVE N'sc_cydb_w500_noindex_log' TO N'/var/opt/mssql/data/sc_cydb_w500_noindex_log.ldf',
    NOUNLOAD,
    STATS = 5