Wu, Docker+sqlserver

SQL Server now supports Linux. So you can run it inside Docker.

First, download the image:

Docker Pull Microsoft/mssql-server-linux

Second, create the container:

Docker run-e ' accept_eula=y '-e ' sa_password=admin123: '-P 1403:1433-d--name SQL Server Microsoft/mssql-server-linux

Admin123. Is the database administrator password

The method of hanging data in the local, prevent the data loss situation when the container is deleted

Docker run -v/home/docker/database/sqlserver/v1:/var/opt/mssql-v /etc/localtime:/etc/localtime:ro-e TZ= " Asia/shanghai "-E ' accept_eula=y '-e ' sa_password=admin123: '-P 1403:1433-d--name SQL Server microsoft/ Mssql-server-linux

Third, the client access to the database:

Use the tool to connect with a pit, need to use Ip,port instead of Ip:port, Java program connection time is written in the previous format, others have not tried

Wu, Docker+sqlserver