Microsoft Ssdt For Mac
Posted : admin On 11.04.2020- Microsoft Ssdt For Mac 2017
- Microsoft Ssdt For Mac Windows 10
- Microsoft Ssdt For Mac Download
- Microsoft Ssdt For Mac Windows 10
- Microsoft Ssdt For Mac Free
- 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.
Platform | Download | Release date | Version |
---|---|---|---|
Windows | User Installer (recommended) System Installer .zip | March 18, 2020 | 1.16.0 |
macOS | .zip | March 18, 2020 | 1.16.0 |
Linux | .deb .rpm .tar.gz | March 18, 2020 | 1.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)
- Download and run the Azure Data Studio user installer for Windows.
- Start the Azure Data Studio app.
System Installer
- Download and run the Azure Data Studio system installer for Windows.
- Start the Azure Data Studio app.
.zip file
- Download Azure Data Studio .zip for Windows.
- Browse to the downloaded file and extract it.
- Run
azuredatastudio-windowsazuredatastudio.exe
Get Azure Data Studio for macOS
- Download Azure Data Studio for macOS.
- To expand the contents of the zip, double-click it.
- To make Azure Data Studio available in the Launchpad, drag Azure Data Studio.app to the Applications folder.
Get Azure Data Studio for Linux
Download Azure Data Studio for Linux by using one of the installers or the tar.gz archive:
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 Cores | Memory/RAM | |
---|---|---|
Recommended | 4 | 8 GB |
Minimum | 2 | 4 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.
Open Settings by clicking the gear on the bottom left and clicking Settings.
Right-click the User Settings tab on top and click Reveal in Explorer
Copy all files in this folder and save in an easy to find location on your local drive, like your Documents folder.
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.
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 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:
下载 SSDT 独立安装程序。Download the SSDT standalone installer.
下载 vs_sql.exe。Download vs_sql.exe.
仍联机时,执行以下命令之一以下载脱机安装所需的全部文件。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.- 对于某种具体语言,请传递区域设置:
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). - 对于所有语言,请省略
--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:
运行
vs_setup.exe --NoWeb
以安装 VS2017 Shell 和 SQL Server 数据项目。Runvs_setup.exe --NoWeb
to install the VS2017 Shell and SQL Server Data Project.从布局文件夹运行
SSDT-Setup-ENU.exe /install
并选择 SSIS/SSRS/SSAS。From the layouts folder, runSSDT-Setup-ENU.exe /install
and select SSIS/SSRS/SSAS.- 若要执行无人参与安装,请运行
SSDT-Setup-ENU.exe /INSTALLALL[:vsinstances] /passive
。For an unattended installation, runSSDT-Setup-ENU.exe /INSTALLALL[:vsinstances] /passive
.
- 若要执行无人参与安装,请运行
有关可用选项,请运行 SSDT-Setup-ENU.exe /help
For 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 databases | SQL 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 packages | SQL 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.