下載 SQL Server Management Studio (SSMS)Download SQL Server Management Studio (SSMS)

適用範圍:Applies to: 是SQL ServerSQL Server (所有支援的版本) yesSQL ServerSQL Server (all supported versions) 是Azure SQL DatabaseAzure SQL DatabaseYesAzure SQL DatabaseAzure SQL Database 是Azure SQL 受控執行個體Azure SQL Managed InstanceYesAzure SQL 受控執行個體Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics適用範圍:Applies to: 是SQL ServerSQL Server (所有支援的版本) yesSQL ServerSQL Server (all supported versions) 是Azure SQL DatabaseAzure SQL DatabaseYesAzure SQL DatabaseAzure SQL Database 是Azure SQL 受控執行個體Azure SQL Managed InstanceYesAzure SQL 受控執行個體Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics

SQL Server Management Studio (SSMS) 是整合式環境,可用於管理任何 SQL 基礎結構,從 SQL Sever 到 Azure SQL Database 皆適用。SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS 提供工具來設定、監視以及管理 SQL Server 執行個體和資料庫。SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. 使用 SSMS,即可部署、監視和升級應用程式所使用的資料層元件,以及建置查詢和指令碼。Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, and build queries and scripts.

使用 SSMS,即可查詢、設計與管理資料庫和資料倉儲,而不論它們位在何處:本機電腦上或雲端中。Use SSMS to query, design, and manage your databases and data warehouses, wherever they are - on your local computer, or in the cloud.

SSMS 是免費的!SSMS is free!

下載 SSMSDownload SSMS

下載 SQL Server Management Studio (SSMS)

SSMS 18.6 是 SSMS 最新的正式發行 (GA) 版本。SSMS 18.6 is the latest general availability (GA) version of SSMS. 若先前已安裝 SSMS 18 的 GA 版本,則安裝 SSMS 18.6 會將其升級至 18.6。If you have a previous GA version of SSMS 18 installed, installing SSMS 18.6 upgrades it to 18.6.

版本資訊Version information

  • 版本號碼:18.6Release number: 18.6
  • 組建編號:15.0.18338.0Build number: 15.0.18338.0
  • 發行日期:2020 年 7 月 22 日Release date: July 22, 2020

若您有意見或建議,或是要回報問題,則連絡 SSMS 小組的最佳方式是透過 SQL Server 使用者意見反應If you have comments or suggestions, or you want to report issues, the best way to contact the SSMS team is at SQL Server user feedback.

SSMS 18.x 安裝不會升級或取代 SSMS 17.x 版或更早版本。The SSMS 18.x installation doesn't upgrade or replace SSMS versions 17.x or earlier. SSMS 18.x 會與舊版本並行安裝,以便於使用者能夠同時使用這兩種版本。SSMS 18.x installs side by side with previous versions, so both versions are available for use. 不過,如果您已安裝 SSMS 18.x「預覽」版本,則必須在安裝 SSMS 18.6 前先將其解除安裝。However, if you have a preview version of SSMS 18.x installed, you must uninstall it before installing SSMS 18.6. 可以前往 [說明] > [關於] 視窗,以查看您是否有預覽版本。You can see if you have the preview version by going to the Help > About window.

如果電腦中包含並存安裝的 SSMS,請確認已針對您的特定需求啟動正確的版本。If a computer contains side-by-side installations of SSMS, verify you start the correct version for your specific needs. 最新版本會標記為 Microsoft SQL Server Management Studio 18The latest version is labeled Microsoft SQL Server Management Studio 18

注意

如果您在非英文語言版本存取此頁面,且想要查看最新內容,請參閱本頁面的英文 (美國) 版If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please visit the US-English version of the site. 您可以選取可用的語言,從英文 (美國) 版網站下載不同語言版本。You can download different languages from the US-English version site by selecting available languages.

可用的語言Available languages

此版 SSMS 提供下列語言版本:This release of SSMS can be installed in the following languages:

SQL Server Management Studio 18.6:SQL Server Management Studio 18.6:
簡體中文 | 繁體中文 | 英文 (美國) | 法文 | 德文 | 義大利文 | 日文 | 韓文 | 葡萄牙文 (巴西) | 俄文 | 西班牙文Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

注意

SQL Server PowerShell 模組為透過 PowerShell 資源庫個別安裝的模組。The SQL Server PowerShell module is a separate install through the PowerShell Gallery. 如需詳細資訊,請參閱下載 SQL Server PowerShell 模組For more information, see Download SQL Server PowerShell Module.

新功能What's new

如需此版本中最新功能的詳細資訊,請參閱 SSMS 版本資訊For details and more information about what's new in this release, see SSMS release notes.

此版本有一些已知問題There are a few known issues with this release.

舊版Previous versions

本文僅適用於最新版本的 SSMS。This article is for the latest version of SSMS only. 若要下載舊版的 SSMS,請前往舊版 SSMSTo download previous versions of SSMS, visit Previous SSMS releases.

自動安裝Unattended install

您也可以使用命令提示字元指令安裝 SSMS。You can also install SSMS using a command prompt script.

苦要在不提供 GUI 提示的背景中安裝 SSMS,請執行下列步驟。If you want to install SSMS in the background with no GUI prompts, then follow the steps below.

  1. 啟動權限較高的命令提示字元。Launch the command prompt with elevated permissions.

  2. 在下列命令提示字元中鍵入命令。Type the command below in the command prompt.

    start "" /w <path where SSMS-ENU.exe file is located> /Quiet SSMSInstallRoot=<path where you want to install SSMS>
    

    範例:Example:

    start "" /w %systemdrive%\SSMSfrom\SSMS-Setup-ENU.exe /Quiet SSMSInstallRoot=%systemdrive%\SSMSto
    

    您也可以傳遞 /Passive (而不是 /Quiet ),以查看安裝程式 UI。You can also pass /Passive instead of /Quiet to see the setup UI.

  3. 若一切順利,就會像範例般顯示安裝在 %systemdrive%\SSMSto\Common7\IDE\Ssms.exe 的 SSMS。If all goes well, you can see SSMS installed at %systemdrive%\SSMSto\Common7\IDE\Ssms.exe" based on the example. 若發生錯誤,將能查看傳回的錯誤碼,以及 %TEMP%\SSMSSetup 中的記錄檔。If something went wrong, you could inspect the error code returned and take a peek at the %TEMP%\SSMSSetup for the log file.

解除安裝Uninstall

在您將 SSMS 解除安裝之後,某些共用元件仍會維持安裝。There are shared components that remain installed after you uninstall SSMS.

維持安裝的共用元件為:The shared components that remain installed are:

  • Microsoft .NET Framework 4.7.2Microsoft .NET Framework 4.7.2
  • Microsoft OLE DB Driver for SQL ServerMicrosoft OLE DB Driver for SQL Server
  • Microsoft ODBC Driver 17 for SQL ServerMicrosoft ODBC Driver 17 for SQL Server
  • Microsoft Visual C++ 2013 可轉散發套件 (x86)Microsoft Visual C++ 2013 Redistributable (x86)
  • Microsoft Visual C++ 2017 可轉散發套件 (x86)Microsoft Visual C++ 2017 Redistributable (x86)
  • Microsoft Visual C++ 2017 可轉散發套件 (x64)Microsoft Visual C++ 2017 Redistributable (x64)
  • Microsoft Visual Studio Tools for Applications 2017Microsoft Visual Studio Tools for Applications 2017

這些元件可以與其他產品共用,因此不會解除安裝。These components aren't uninstalled because they can be shared with other products. 若解除安裝,可能會導致其他產品無法使用。If uninstalled, you may run the risk of disabling other products.

支援的 SQL 供應項目Supported SQL offerings

  • 此版本的 SSMS 適用於所有支援的 SQL Server 2008 - SQL Server 2019 (15.x)SQL Server 2019 (15.x),並提供最高層級的支援以使用 Azure SQL Database 和 Azure SQL 資料倉儲中最新雲端功能。This version of SSMS works with all supported versions of SQL Server 2008 - SQL Server 2019 (15.x)SQL Server 2019 (15.x) and provides the greatest level of support for working with the latest cloud features in Azure SQL Database and Azure SQL Data Warehouse.
  • 此外,SSMS 18.x 可以與 SSMS 17.x、SSMS 16.x 或 SQL Server 2014 SSMS 及更早的版本並存安裝。Additionally, SSMS 18.x can be installed side by side with SSMS 17.x, SSMS 16.x, or SQL Server 2014 SSMS and earlier.
  • SQL Server Integration Services (SSIS) - SSMS 17.x 或更新版本不支援連線至舊版 SQL Server Integration Services 服務。SQL Server Integration Services (SSIS) - SSMS version 17.x or later doesn't support connecting to the legacy SQL Server Integration Services service. 若要連線至舊版 Integration Services 的舊版本,請使用與 SQL Server 版本一致的 SSMS 版本。To connect to an earlier version of the legacy Integration Services, use the version of SSMS aligned with the version of SQL Server. 例如,使用 SSMS 16.x 連線至舊版 SQL Server 2016 Integration Services 服務。For example, use SSMS 16.x to connect to the legacy SQL Server 2016 Integration Services service. SSMS 17.x 和 SSMS 16.x 可以並存安裝在相同電腦上。SSMS 17.x and SSMS 16.x can be installed side by side on the same computer. 自 SQL Server 2012 發行之後,建議使用 SSIS Catalog 資料庫 SSISDB 來儲存、管理、執行和監視 Integration Services 套件。Since the release of SQL Server 2012, the SSIS Catalog database, SSISDB, is the recommended way to store, manage, run, and monitor Integration Services packages. 如需詳細資訊,請參閱 SSIS 目錄For details, see SSIS Catalog.

SSMS 系統需求SSMS System Requirements

搭配最新推出的服務套件使用時,這一版 SSMS 支援下列 64 位元平台:This release of SSMS supports the following 64-bit platforms when used with the latest available service pack:

支援的作業系統:Supported Operating Systems:

  • Windows 10 (64 位元) 版本 1607 (10.0.14393) 或更新版本Windows 10 (64-bit) version 1607 (10.0.14393) or later
  • Windows 8.1 (64 位元)Windows 8.1 (64-bit)
  • Windows Server 2019 (64 位元)Windows Server 2019 (64-bit)
  • Windows Server 2016 (64 位元)Windows Server 2016 (64-bit)
  • Windows Server 2012 R2 (64 位元)Windows Server 2012 R2 (64-bit)
  • Windows Server 2012 (64 位元)Windows Server 2012 (64-bit)
  • Windows Server 2008 R2 (64 位元)Windows Server 2008 R2 (64-bit)

支援的硬體:Supported hardware:

  • 1.8 GHz 或更快的處理器。1.8 GHz or faster processor. 建議雙核心或更佳的處理器Dual-core or better recommended
  • 2 GB 的 RAM,建議 4 GB 的 RAM (如果在虛擬機器上執行,至少 2.5 GB)2 GB of RAM; 4 GB of RAM recommended (2.5 GB minimum if running on a virtual machine)
  • 硬碟空間:最少 2 GB 至 10 GB 的可用空間Hard disk space: Minimum of 2 GB up to 10 GB of available space

注意

SSMS 只能在 Windows (AMD 或 Intel) 上執行。SSMS runs on Windows (AMD or Intel) only. 若您需要能在 Windows 以外平台上執行的工具,請查看 Azure Data Studio。If you need a tool that runs on platforms other than Windows, take a look at Azure Data Studio. Azure Data Studio 是一個新的跨平台工具,可在 macOS、Linux 以及 Windows 上執行。Azure Data Studio is a new cross-platform tool that runs on macOS, Linux, as well as Windows. 如需詳細資料,請參閱 Azure Data StudioFor details, see Azure Data Studio.

取得 SQL 工具的說明

後續步驟Next steps

參與 SQL 檔

您知道您可以自己編輯內容嗎?Did you know that you could edit the content yourself? 如果您這樣做,不只會改善我們的文件,而且您也會成為該頁面的參與者!If you do so, not only will our documentation improve, but you'll also be credited as a contributor to the page.