12/27/2021»»Monday

Microsoft Ssdt For Mac

12/27/2021

2019-4-18  CPU-S for Mac v4.1 轻松检测CPU信息变频档位(赠送生成SSDT方法和专业治疗各种姿势都无法检测的解决方法) 2019-01-29 Mac软件 35955 0 CPU-S for Mac是一款可以检测CPU信息和变频档位的小巧工具,大家安装完了黑苹果系统,最在意的就是CPU是否. SSDT & Visual Studio in Visual Studio Installer windows 6.1.7601 visual studio 2017 version 15.5 Setup Bob Paris reported Jan 09, 2018 at 06:33 PM.

-->

APPLIES TO: SQL Server Azure SQL Database Azure Synapse Analytics (SQL DW) Parallel Data Warehouse

To manage your database, you need a tool. Whether your databases run in the cloud, on Windows, on macOS, or on Linux, your tool doesn't need to run on the same platform as the database.

You can view the links to the different SQL tools in the following tables.

Note

To download SQL Server, see Install SQL Server.

Recommended tools

The following tools provide a graphical user interface (GUI).

ToolDescriptionOperating system

Azure Data Studio
A light-weight editor that can run on-demand SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object browsing experience.Windows
macOS
Linux

SQL Server Management Studio (SSMS)
Manage a SQL Server instance or database with full GUI support. Access, configure, manage, administer, and develop all components of SQL Server, Azure SQL Database, and SQL Data Warehouse. Provides a single comprehensive utility that combines a broad group of graphical tools with a number of rich script editors to provide access to SQl for developers and database administrators of all skill levels.Windows

SQL Server Data Tools (SSDT)
A modern development tool for building SQL Server relational databases, Azure SQL databases, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.Windows

Visual Studio Code
The mssql extension for Visual Studio Code is the official SQL Server extension that supports connections to SQL Server and rich editing experience for T-SQL in Visual Studio Code. Write T-SQL scripts in a light-weight editor.Windows
macOS
Linux

Command-line tools

The tools below are the main command-line tools.

ToolDescriptionOperating system
bcpThe bulk copy program utility (bcp) bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format.Windows
macOS
Linux
mssql-cli (preview)mssql-cli is an interactive command-line tool for querying SQL Server. Also, query SQL Server with a command-line tool that features IntelliSense, syntax high-lighting, and more.Windows
macOS
Linux
mssql-confmssql-conf configures SQL Server running on Linux.Linux
mssql-scripter (preview)mssql-scripter is a multi-platform command-line experience for scripting SQL Server databases.Windows
macOS
Linux
sqlcmdsqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files at the command prompt.Windows
macOS
Linux
sqlpackagesqlpackage is a command-line utility that automates several database development tasks.Windows
macOS
Linux
SQL Server PowerShellSQL Server PowerShell provides cmdlets for working with SQL.Windows
macOS
Linux
Microsoft

Migration and other tools

These tools are used to migrate, configure, and provide other features for SQL databases.

ToolDescription
Configuration ManagerUse SQL Server Configuration Manager to configure SQL Server services and configure network connectivity. Configuration Manager runs on Windows
Database Experimentation AssistantUse Database Experimentation Assistant to evaluate a targeted version of SQL for a given workload.
Data Migration AssistantThe Data Migration Assistant tool helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database.
Distributed ReplayUse the Distributed Replay feature to help you assess the impact of future SQL Server upgrades. Also use Distributed Replay to help assess the impact of hardware and operating system upgrades, and SQL Server tuning.
ssbdiagnoseThe ssbdiagnose utility reports issues in Service Broker conversations or the configuration of Service Broker services.
SQL Server Migration AssistantUse SQL Server Migration Assistant to automate database migration to SQL Server from Microsoft Access, DB2, MySQL, Oracle, and Sybase.

If you're looking for additional tools that aren't mentioned on this page, see SQL Command Prompt Utilities and Download SQL Server extended features and tools

-->

适用于: SQL Server Azure SQL 数据库 Azure Synapse Analytics (SQL DW) 并行数据仓库 APPLIES TO: SQL Server Azure SQL Database Azure Synapse Analytics (SQL DW) Parallel Data Warehouse

SQL Server Data Tools (SSDT) 是一款新式开发工具,用于生成 SQL Server 关系数据库、Azure SQL 数据库、Analysis Services (AS) 数据模型、Integration Services (IS) 包和 Reporting Services (RS) 报表 。SQL Server Data Tools (SSDT) is a modern development tool for building SQL Server relational databases, Azure SQL Databases, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports.使用 SSDT,你可以设计和部署任何 SQL Server 内容类型,就像在 Visual Studio 中开发应用程序一样轻松。With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.

SSDT for Visual Studio 2019SSDT for Visual Studio 2019

SSDT for Visual Studio 2019 中的变化Changes in SSDT for Visual Studio 2019

用于创建数据库项目的核心 SSDT 功能一直是 Visual Studio 不可或缺的部分。The core SSDT functionality to create database projects has remained integral to Visual Studio.

随着 Visual Studio 2019 发布,启用 Analysis Services、Integration Services 和 Reporting Services 项目所需的功能仅移至相应 Visual Studio (VSIX) 扩展中。With Visual Studio 2019, the required functionality to enable Analysis Services, Integration Services, and Reporting Services projects has moved into the respective Visual Studio (VSIX) extensions only.

备注

没有适用于 Visual Studio 2019 的 SSDT 独立安装程序。There's no SSDT standalone installer for Visual Studio 2019.

使用 Visual Studio 2019 安装 SSDTInstall SSDT with Visual Studio 2019

如果已安装 Visual Studio 2019,则可以编辑工作负载列表,使其包括 SSDT。If Visual Studio 2019 is already installed, you can edit the list of workloads to include SSDT.

  • 对于 SQL 数据库项目,请选择 “数据存储和处理” 下的 “SQL Server Data Tools”For SQL Database projects, select SQL Server Data Tools under Data storage and processing.

  • 对于 Analysis Services、Integration Services 或 Reporting Services 项目,请从“工具”>“扩展和更新” 或从市场安装相应的扩展。For Analysis Services, Integration Services, or Reporting Services projects, you can install the appropriate extensions from either Tools > Extensions and Updates or from the Marketplace.

如果尚未安装 Visual Studio 2019,可以下载并安装 Visual Studio 2019 Community。If you don’t have Visual Studio 2019 installed, then you can download and install Visual Studio 2019 Community.

  • 对于 SQL 数据库项目,请在安装过程中的工作负载列表中的 “数据存储和处理” 下选择 “SQL Server Data Tools”For SQL Database projects, select SQL Server Data Tools under Data storage and processing in the list of workloads during installation.

  • 对于 Analysis Services、Integration Services 或 Reporting Services 项目,请从“工具”>“扩展和更新” 或从市场安装相应的扩展。For Analysis Services, Integration Services, or Reporting Services projects, you can install the appropriate extensions from either Tools > Extensions and Updates or from the Marketplace.

SSDT for Visual Studio 2017SSDT for Visual Studio 2017

SSDT for Visual Studio 2017 中的变化Changes in SSDT for Visual Studio 2017

自 Visual Studio 2017 起,创建数据库项目的功能已集成到 Visual Studio 安装中。Starting with Visual Studio 2017, the functionality of creating Database Projects has been integrated into the Visual Studio installation.无需安装 SSDT 独立安装程序,即可获得核心 SSDT 体验。There's no need to install the SSDT standalone installer for the core SSDT experience.

现在要创建 Analysis Services、Integration Services 或 Reporting Services 项目,仍需要 SSDT 独立安装程序。Now to create Analysis Services, Integration Services, or Reporting Services projects, you still need the SSDT standalone installer.

使用 Visual Studio 2017 安装 SSDTInstall SSDT with Visual Studio 2017

若要在 Visual Studio 安装过程中安装 SSDT,请选择“数据存储和处理”工作负荷,然后选择“SQL Server Data Tools” 。To install SSDT during Visual Studio installation, select the Data storage and processing workload, and then select SQL Server Data Tools.

如果已安装 Visual Studio,则可以编辑工作负载列表,使其包括 SSDT。If Visual Studio is already installed, you can edit the list of workloads to include SSDT.

安装 Analysis Services、Integration Services 和 Reporting Services 工具Install Analysis Services, Integration Services, and Reporting Services tools

若要安装 Analysis Services、Integration Services 和 Reporting Services 项目支持,请运行SSDT 独立安装程序。To install Analysis Services, Integration Services, and Reporting Services project support, run the SSDT standalone installer.

此安装程序列出了可用于添加 SSDT 工具的 Visual Studio 实例。The installer lists available Visual Studio instances to add SSDT tools.如果尚未安装 Visual Studio,选择“安装新 SQL Server Data Tools 实例” 安装 SSDT 时使用的是最低版本 Visual Studio,但为了获得最佳体验,建议结合使用 SSDT 和最新版 Visual Studio。If Visual Studio isn't already installed, selecting Install a new SQL Server Data Tools instance installs SSDT with a minimal version of Visual Studio, but for the best experience, we recommend using SSDT with the latest version of Visual Studio.

SSDT for VS 2017(独立安装程序)SSDT for VS 2017 (standalone installer)

下载 SSDT for Visual Studio 2017 (15.9.4) Download SSDT for Visual Studio 2017 (15.9.4)

重要

  • 安装 SSDT for Visual Studio 2017 (15.9.4) 前,请卸载“Analysis Services 项目” 和“Reporting Services 项目” 扩展(如已安装),并关闭所有 VS 实例。Before installing SSDT for Visual Studio 2017 (15.9.4), uninstall Analysis Services Projects and Reporting Services Projects extensions if they are already installed, and close all VS instances.
  • 删除了收件箱组件 Power Query Source for SQL Server 2017。Removed the inbox component Power Query Source for SQL Server 2017.目前,我们已宣布推出 Power Query Source for SQL Server 2017 & 2019 作为现成组件,可在此处下载。Now we have announced Power Query Source for SQL Server 2017 & 2019 as out-of-box component, which can be downloaded here.
  • 删除了收件箱组件 Microsoft Oracle Connector for SQL Server 2019。Removed the inbox component Microsoft Oracle Connector for SQL Server 2019.目前,我们已宣布将 Microsoft Oracle Connector for SQL Server 2019 作为现成组件推出(可以从此处下载)。Now we have announced Microsoft Oracle Connector for SQL Server 2019 as out-of-box component, which can be downloaded here.

发行说明Release Notes

有关更改的完整列表,请参阅 SQL Server Data Tools (SSDT) 发行说明。For a complete list of changes, see Release notes for SQL Server Data Tools (SSDT).

系统要求System requirements

Microsoft Ssdt For Mac Torrent

SSDT for Visual Studio 2017 具有与 Visual Studio 相同的系统需求。SSDT for Visual Studio 2017 has the same system requirements as Visual Studio.

支持的语言 - SSDT for VS 2017Available Languages - SSDT for VS 2017

此版本的 SSDT for VS 2017 可安装以下语言 :This release of SSDT for VS 2017 can be installed in the following languages:

注意事项和限制Considerations and limitations

  • 无法脱机安装社区版You can’t install the community version offline

  • 若要升级 SSDT,需要遵循用于安装 SSDT 的相同路径。To upgrade SSDT, you need to follow the same path used to install SSDT.例如,如果使用 VSIX 扩展添加了 SSDT,则必须通过 VSIX 扩展进行升级。For example, if you added SSDT using the VSIX extensions, then you must upgrade via the VSIX extensions.如果通过单独安装来安装了 SSDT,需要使用这种方法进行升级。If you installed SSDT via a separate install, then you need to upgrade using that method.

脱机安装Offline install

若要在未连接到 Internet 时安装 SSDT,请按照此部分中的步骤操作。To install SSDT when you’re not connected to the internet, follow the steps in this section.有关详细信息,请参阅 创建 Visual Studio 2017 的网络安装。For more information, see Create a network installation of Visual Studio 2017.

首先,在联机 时完成以下步骤:First, complete the following steps while online:

  1. 下载 SSDT 独立安装程序。Download the SSDT standalone installer.

  2. 下载 vs_sql.exe。Download vs_sql.exe.

  3. 仍联机时,执行以下命令之一以下载脱机安装所需的全部文件。While still online, execute one of the following commands to download all the files required for installing offline.使用 --layout 选项是关键,它用于下载脱机安装的实际文件。Using the --layout option is the key, it downloads the actual files for the offline installation.<filepath> 替换为保存文件的实际布局路径。Replace <filepath> with the actual layouts path to save the files.

    1. 对于某种具体语言,请传递区域设置:vs_sql.exe --layout c:<filepath> --lang en-us(一种语言大约为 1GB)。For a specific language, pass the locale: vs_sql.exe --layout c:<filepath> --lang en-us (a single language is ~1 GB).
    2. 对于所有语言,请省略 --lang 参数:vs_sql.exe --layout c:<filepath>(所有语言大约为 3.9GB)。For all languages, omit the --lang argument: vs_sql.exe --layout c:<filepath> (all languages are ~3.9 GB).

完成上述步骤后,可以脱机 完成以下步骤:After completing the previous steps, the following steps below can be done offline:

  1. 运行 vs_setup.exe --NoWeb 以安装 VS2017 Shell 和 SQL Server 数据项目。Run vs_setup.exe --NoWeb to install the VS2017 Shell and SQL Server Data Project.

  2. 从布局文件夹运行 SSDT-Setup-ENU.exe /install 并选择 SSIS/SSRS/SSAS。From the layouts folder, run SSDT-Setup-ENU.exe /install and select SSIS/SSRS/SSAS.

    • 若要执行无人参与安装,请运行 SSDT-Setup-ENU.exe /INSTALLALL[:vsinstances] /passiveFor an unattended installation, run SSDT-Setup-ENU.exe /INSTALLALL[:vsinstances] /passive.

有关可用选项,请运行 SSDT-Setup-ENU.exe /helpFor available options, run SSDT-Setup-ENU.exe /help

备注

如果使用的是完整版 Visual Studio 2017,请仅为 SSDT 创建脱机文件夹,并从这一新建文件夹运行 SSDT-Setup-ENU.exe(请勿将 SSDT 添加到另一个 Visual Studio 2017 脱机布局)。If using a full version of Visual Studio 2017, create an offline folder for SSDT only, and run SSDT-Setup-ENU.exe from this newly created folder (don’t add SSDT to another Visual Studio 2017 offline layout).如果将 SSDT 布局添加到现有 Visual Studio 脱机布局,则无法在其中创建必要的运行时 (.exe) 组件。If you add the SSDT layout to an existing Visual Studio offline layout, the necessary runtime (.exe) components are not created there.

受支持的 SQL 版本Supported SQL versions

Ssdt Bi For Visual Studio 2013

项目模板Project Templates支持的 SQL 平台SQL Platforms Supported
关系数据库Relational databasesSQL Server 2005* - SQL Server 2017SQL Server 2005* - SQL Server 2017
(使用适用于 Visual Studio 2017 的 SSDT 17.x 或 SSDT 来连接 Linux 上的 SQL Server)(use SSDT 17.x or SSDT for Visual Studio 2017 to connect to SQL Server on Linux)
Azure SQL 数据库Azure SQL Database
Azure SQL 数据仓库(仅支持查询;尚不支持数据库项目)Azure SQL Data Warehouse (supports queries only; database projects aren't yet supported)
* SQL Server 2005 支持已停止提供,* SQL Server 2005 support is deprecated,
请迁移到官方支持的 SQL 版本move to an officially supported SQL version
Analysis Services 模型Analysis Services models
Reporting Services 报表Reporting Services reports
SQL Server 2008 - SQL Server 2017SQL Server 2008 - SQL Server 2017
Integration Services 包Integration Services packagesSQL Server 2012 - SQL Server 2019SQL Server 2012 - SQL Server 2019

DacFxDacFx

SSDT for Visual Studio 2015 和 2017 都使用 DacFx 17.4.1:下载数据层应用程序框架 (DacFx) 17.4.1。SSDT for Visual Studio 2015 and 2017 both use DacFx 17.4.1: Download>以前的版本Previous versions

若要下载并安装 SSDT for Visual Studio 2015 或较旧版本的 SSDT,请参阅以前版本的 SQL Server Data Tools(SSDT 和 SSDT-BI)。To download and install SSDT for Visual Studio 2015, or an older version of SSDT, see Previous releases of SQL Server Data Tools (SSDT and SSDT-BI).

后续步骤Next steps

安装 SSDT 后,阅读这些教程,了解如何使用 SSDT 创建数据库、包、数据模型和报表。After installing SSDT, work through these tutorials to learn how to create databases, packages, data models, and reports using SSDT.

获取帮助Get help

Download Sql Server For Mac

另请参阅See Also