sql docker容器_如何将Microsoft SQL Server Docker容器与Azure Data Studio连接

sql docker容器

This guide shows you how to use Docker to pull a MSSQL Server image and run it. Azure Data Studio is a cross-platform database tool that will be using to connect our Docker container with MSSQL and execute SQL statements.

本指南向您展示如何使用Docker提取并运行MSSQL Server映像。 Azure Data Studio是一个跨平台的数据库工具，将用于将Docker容器与MSSQL连接并执行SQL语句。

At the end, I will show you how to import a database to the Docker file system so that you can access it through Azure Data Studio.

最后，我将向您展示如何将数据库导入Docker文件系统，以便您可以通过Azure Data Studio访问它。

Check out other related guides here:

在此处查看其他相关指南：

• How to Connect your AWS RDS Microsoft SQL Server using Azure Data Studio

  如何使用Azure Data Studio连接AWS RDS Microsoft SQL Server

• How to Import a Sample Database to your AWS RDS Microsoft SQL Server using S3

  如何使用S3将示例数据库导入到AWS RDS Microsoft SQL Server

We will be touching on the technologies shown below:

我们将涉及以下技术：

• Database: Microsoft SQL Server
  数据库：Microsoft SQL Server
• Container to pull mssql-server-demo: Docker
  提取mssql-server-demo的容器：Docker
• Installer for mssql-cli: Node.js (Run-time Environment) / Node Package Manager (NPM)
  mssql-cli的安装程序：Node.js(运行时环境)/ Node Package Manager(NPM)
• Database tool and GUI: Azure Data Studio
  数据库工具和GUI：Azure Data Studio

使用Docker构建环境 (Building our Environment with Docker )

安装Docker (Installing Docker)

Full guide for this portion here:

这部分的完整指南在这里 ：

1. Download Docker CE (Community Edition) for Mac here.

   在此处下载适用于Mac的Docker CE(社区版)。

2. To install, double-click on the .dmg file and then drag the Docker application icon to your Application folder.
   要安装，请双击.dmg文件，然后将Docker应用程序图标拖到您的Application文件夹中。

什么是Docker？ (What is Docker?)

Docker is a platform that enables software to run in its own isolated environment. SQL Server (from 2017) can be run on Docker in its own isolated container.

Docker是一个平台，使软件可以在自己的隔离环境中运行。 SQL Server(自2017年起)可以在Docker的隔离容器中运行。

Once Docker is installed, you simply download — or “pull” — the SQL Server on Linux Docker Image to your Mac, then run it as a Docker container. This container is an isolated environment that contains everything SQL Server needs to run.

一旦安装了Docker，您只需将Linux Docker Image上SQL Ser