Microsoft Ssdt For Mac

Posted : admin On 11.04.2020
  1. Microsoft Ssdt For Mac 2017
  2. Microsoft Ssdt For Mac Windows 10
  3. Microsoft Ssdt For Mac Download
  4. Microsoft Ssdt For Mac Windows 10
  5. Microsoft Ssdt For Mac Free
  6. Microsoft Ssdt For Mac Pro
-->

Azure Data Studio runs on Windows, macOS, and Linux.

Download and install the latest release:

2017-1-6  直接在vs2013里的AppData目录创建数据库,在服务器资源管理器中查看时报错: 未能加载包“Microsoft SQL Server Data Tools” 英文: The 'Microsoft SQL Server Data Tools' package did not load correctly. The problem may have been caused by a configuration. The SQL Server Data Tools team is pleased to announce an update for SQL Server Data Tools (SSDT) is now available. The SSDT 16.5 release adds a number of improvements to the connection experience, SqlPackage and DacFx API support for generating a deployment report and scripts during publish.

Note

If you're updating from SQL Operations Studio and want to keep your settings, keyboard shortcuts, or code snippets, see Move user settings.

PlatformDownloadRelease dateVersion
WindowsUser Installer (recommended)
System Installer
.zip
March 18, 20201.16.0
macOS.zipMarch 18, 20201.16.0
Linux.deb
.rpm
.tar.gz
March 18, 20201.16.0

For details about the latest release, see the release notes.

Irdeto Rights is an OTT content protection solution that enables operators to manage multiple DRMs and business policies across a wide range of end-user devices. It supports Microsoft PlayReady as well as PlayReady Scalable for live streaming, allowing operators to meet licensing requirements for premium content and ensure the best user experience. Samples of PlayReady Windows 8.1 applications can be found at PlayReady sample for Windows 8.1 Store apps. Developing Applications using PlayReady on Windows 7. Some PlayReady Partners provide SDKs to run PlayReady on Windows 7 and Mac OS, based on Electron, Xamarin, or other technologies. 2020-4-2  PlayReady Product Suite. Microsoft is committed to working with companies across the content delivery spectrum to ensure that consumers can access premium content inside or outside the home regardless of the device or service they choose. Microsoft playready problems. For the Windows 8.1 reference, see Developing PlayReady Windows Store and Web Apps. PlayReady on Window 7, MacOS. Some Microsoft Partners provide SDKs to run PlayReady on Windows 7 and Mac OS, based on Electron, Xamarin, or other technologies. You can contact these PlayReady Partners directly for more information.

Get Azure Data Studio for Windows

This release of Azure Data Studio includes a standard Windows installer experience, and a .zip file.

The user installer is recommended because it does not require administrator privileges, which simplifies both installs and upgrades. The user installer does not require Administrator privileges as the location is under your user Local AppData (LOCALAPPDATA) folder. The user installer also provides a smoother background update experience. For more information, see User setup for Windows.

User Installer (recommended)

  1. Download and run the Azure Data Studio user installer for Windows.
  2. Start the Azure Data Studio app.

System Installer

  1. Download and run the Azure Data Studio system installer for Windows.
  2. Start the Azure Data Studio app.

.zip file

  1. Download Azure Data Studio .zip for Windows.
  2. Browse to the downloaded file and extract it.
  3. Run azuredatastudio-windowsazuredatastudio.exe

Get Azure Data Studio for macOS

  1. Download Azure Data Studio for macOS.
  2. To expand the contents of the zip, double-click it.
  3. To make Azure Data Studio available in the Launchpad, drag Azure Data Studio.app to the Applications folder.

Get Azure Data Studio for Linux

  1. Download Azure Data Studio for Linux by using one of the installers or the tar.gz archive:

  2. To extract the file and launch Azure Data Studio, open a new Terminal window and type the following commands:

    Debian Installation:

    rpm Installation:

    tar.gz Installation:

    Note

    On Debian, Redhat, and Ubuntu, you may have missing dependencies. Use the following commands to install these dependencies depending on your version of Linux:

    Debian:

    Redhat:

    Ubuntu:

Download Insiders build of Azure Data Studio

In general, users should download the stable release of Azure Data Studio above. However, if you want to try out our beta features and give us feedback, you can download an Insiders build of Azure Data Studio.

Uninstall Azure Data Studio

If you installed Azure Data Studio using the Windows installer, then uninstall the same way you remove any Windows application.

If you installed Azure Data Studio with a .zip or other archive, then simply delete the files.

Supported Operating Systems

Azure Data Studio runs on Windows, macOS, and Linux, and is supported on the following platforms:

Windows

  • Windows 10 (64-bit)
  • Windows 8.1 (64-bit)
  • Windows 8 (64-bit)
  • Windows 7 (SP1) (64-bit) - Requires KB2533623
  • Windows Server 2019
  • Windows Server 2016
  • Windows Server 2012 R2 (64-bit)
  • Windows Server 2012 (64-bit)
  • Windows Server 2008 R2 (64-bit)

macOS

  • macOS 10.15 Catalina
  • macOS 10.14 Mojave
  • macOS 10.13 High Sierra
  • macOS 10.12 Sierra

Linux

  • Red Hat Enterprise Linux 7.4
  • Red Hat Enterprise Linux 7.3
  • SUSE Linux Enterprise Server v12 SP2
  • Ubuntu 16.04

Recommended System Requirements

CPU CoresMemory/RAM
Recommended48 GB
Minimum24 GB

Check for updates

To check for latest updates, click the gear icon on the bottom left of the window and click Check for Updates

(See Figure 1.)Figure 1. The Security tab of the Options dialog box. Microsoft word for mac make track changes go away. Word displays the Options dialog box. Make sure the Security tab is displayed.

Supported SQL offerings

  • This version of Azure Data Studio works with all supported versions of SQL Server 2014 - SQL Server 2019 (15.x) and provides support for working with the latest cloud features in Azure SQL Database and Azure SQL Data Warehouse. Azure Data Studio also provides preview support for Azure SQL Managed Instance.

Upgrade from SQL Operations Studio

If you are still using SQL Operations Studio, you need to upgrade to Azure Data Studio. SQL Operations Studio was the preview name and preview version of Azure Data Studio. In September 2018, we changed the name to Azure Data Studio and released the General Availability (GA) version. Because SQL Operations Studio is no longer being updated or supported, we ask all SQL Operations Studio users to download the latest version of Azure Data Studio to get the latest features, security updates, and fixes.

When upgrading from the old preview to the latest Azure Data Studio, you will lose your current settings and extensions. To move your settings, follow the instructions in the following Move user settings section:

Move user settings

If you want to move your custom settings, keyboard shortcuts, or code snippets, follow the steps below. This is important to do if you are upgrading from SQL Operations Studio version to Azure Data Studio.

If you already have Azure Data Studio, or you've never installed or customized SQL Operations Studio, then you can ignore this section.

  1. Open Settings by clicking the gear on the bottom left and clicking Settings.

  2. Right-click the User Settings tab on top and click Reveal in Explorer

  3. Copy all files in this folder and save in an easy to find location on your local drive, like your Documents folder.

  4. In your new version of Azure Data Studio, follow steps 1-2, then for step 3 paste the contents you saved into the folder. You can also manually copy over the settings, keybindings, or snippets in their respective locations.

  5. If overriding an existing installation, delete the old install directory before installation to avoid errors connecting to your Azure account for the resource explorer.

Next Steps

See one of the following quickstarts to get started:

Get help for SQL tools

Contribute to SQL documentation

Microsoft Ssdt For Mac 2017

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.

Microsoft Privacy Statement and usage data collection.

-->

适用于: 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.

Microsoft Ssdt For Mac Windows 10

随着 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.

Microsoft Ssdt For Mac Download

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

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.

Microsoft Ssdt For Mac Windows 10

受支持的 SQL 版本Supported SQL versions

项目模板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

Microsoft Ssdt For Mac Free

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

Microsoft Ssdt For Mac Pro

另请参阅See Also