This enables you to start a new container with the same data. Make sure you are using one of the data persistence techniques for your existing SQL Server container. To do this, you must create a new container with the latest SQL Server container image and migrate your data to that new container.
#TABLEPLUS CONNECT TO DOCKER CONTAINER UPDATE#
This updates the SQL Server image for any new containers you create, but it doesn't update SQL Server in any running containers. Pull this version from the registry with the docker pull command: docker pull /mssql/server: To upgrade the container image with Docker, first identify the tag for the release for your upgrade.
#TABLEPLUS CONNECT TO DOCKER CONTAINER HOW TO#
The following example shows how to run the latest SQL Server 2019 (15.x) container image for the Enterprise Edition: You must specify your production edition with the MSSQL_PID environment variable. Review the requirements and run procedures in the quickstart. Use the following steps to run production editions: The Developer container image can be configured to run the production editions as well. SQL Server Standard and Enterprise Edition licenses are available through Microsoft Volume Licensing. You can obtain a free SQL Server Express production license here. You can only use SQL Server in a production environment if you have a valid license.
However, there are a few differences that are outlined here. Most of the information still applies if you want to run production container images, such as Enterprise, Standard, or Web editions.
The quickstart in the previous section runs the free Developer edition of SQL Server from Docker Hub. The IP address in the connection string is the IP address of the host machine that is running the container.ĭocker pull /mssql/rhel/server:2019-CU15-rhel-8.4 The following example uses sqlcmd to connect to SQL Server running in a Docker container.