Skip to content

Commit ae0971c

Browse files
committed
updating download page and changelog for DacFx release 17.0.1
1 parent 38b9439 commit ae0971c

2 files changed

Lines changed: 31 additions & 26 deletions

File tree

docs/ssdt/changelog-for-sql-server-data-tools-ssdt.md

Lines changed: 9 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -20,20 +20,23 @@ This change log is for [SQL Server Data Tools (SSDT) for Visual Studio 2015](htt
2020

2121
For detailed posts about what’s new and changed, please visit [the SSDT Team blog](https://blogs.msdn.microsoft.com/ssdt/).
2222

23-
## SSDT 17.0 (supports up to SQL Server vNext)
23+
## DacFx 17.0.1
24+
- Fix for issue with databases with an asymmetric key by an HSM with an EKM provider [Connect item](https://connect.microsoft.com/SQLServer/feedback/details/3132749/sqlpackage-exe-fails-when-extracting-a-database-which-contains-an-asymmetric-key-using-an-ekm-provider)
25+
26+
## SSDT 17.0 (supports up to SQL Server 2017)
2427
Build number: 14.0.61704.140
2528

2629
### What's New?
2730
**Database projects:**
28-
- Amending a clustered index on a view will no longer block deployment.
31+
- Amending a clustered index on a view will no longer block deployment
2932
- Schema comparison strings relating to column encryption will use the proper name rather than the instance name.
30-
- Added a new command line option to SqlPackage: ModelFilePath. This provides an option for advanced users to specify an external model.xml file for import, publishing and scripting operations.
33+
- Added a new command line option to SqlPackage: ModelFilePath. This provides an option for advanced users to specify an external model.xml file for import, publishing and scripting operations
3134
- The DacFx API was extended to support Azure AD Universal Authentication and Multi-factor authentication (MFA)
3235

3336
**IS projects:**
34-
- The SSIS OData Source and OData Connection Manager now support connecting to the OData feeds of Microsoft Dynamics AX Online and Microsoft Dynamics CRM Online.
35-
- SSIS project now supports target server version of "SQL Server vNext"
36-
- Support for CDC Control Task, CDC Splitter and CDC Source when targeting SQL Server vNext.
37+
- The SSIS OData Source and OData Connection Manager now support connecting to the OData feeds of Microsoft Dynamics AX Online and Microsoft Dynamics CRM Online
38+
- SSIS project now supports target server version of "SQL Server 2017"
39+
- Support for CDC Control Task, CDC Splitter and CDC Source when targeting SQL Server 2017
3740

3841
**AS projects:**
3942
- Analysis Services PowerQuery Integration (1400 compat-level tabular models):

docs/ssdt/download-sql-server-data-tools-ssdt.md

Lines changed: 22 additions & 20 deletions
Original file line numberDiff line numberDiff line change
@@ -19,12 +19,12 @@ manager: "jhubbard"
1919
---
2020
# Download SQL Server Data Tools (SSDT)
2121

22-
**[SQL Server Data Tools](https://msdn.microsoft.com/mt186501)** is a modern development tool that you can download for free to build SQL Server relational databases, Azure SQL databases, Integration Services packages, Analysis Services data models, and Reporting Services 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. This release supports SQL Server vNext through SQL Server 2005, and provides the design environment for adding features that are new in SQL Server 2016.
22+
**[SQL Server Data Tools](https://msdn.microsoft.com/mt186501)** is a modern development tool that you can download for free to build SQL Server relational databases, Azure SQL databases, Integration Services packages, Analysis Services data models, and Reporting Services 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. This release supports SQL Server 2017 through SQL Server 2005, and provides the design environment for adding features that are new in SQL Server 2016.
2323

2424

2525
![download](../ssdt/media/download.png) [Download SQL Server Data Tools 17.0 for Visual Studio 2015](https://go.microsoft.com/fwlink/?linkid=846626)
2626

27-
![download](../ssdt/media/download.png) [Download Data-Tier Application Framework (DacFx) 17.0](https://www.microsoft.com/download/details.aspx?id=55088)
27+
![download](../ssdt/media/download.png) [Download Data-Tier Application Framework (DacFx) 17.0.1](https://www.microsoft.com/download/details.aspx?id=55114)
2828

2929
## SQL Server Data Tools
3030
**Version Information**
@@ -33,14 +33,16 @@ The release number: 17.0
3333
The build number for this release: 14.0.61704.140
3434

3535
**What's New**
36-
- Support for SQL Server vNext for database base projects, IS projects and BI projects
36+
- Support for SQL Server 2017 for database projects, IS projects and BI projects
3737
- Support for Azure Analysis Services
3838
- Ignore column order in database projects
3939
- PowerQuery integration and support for 1400 level models
4040
- IS package support ofr Microsoft Dynamics AX and CRM online through OData
4141

4242
Complete list of changes available in the [changelog](changelog-for-sql-server-data-tools-ssdt.md)
4343

44+
> To use SQL Server Data Tools in Visual Studio 2017 see [this](#use-ssdt-in-visual-studio-2017) section below
45+
4446
**Available Languages**
4547

4648
This release of SSDT can be installed in the following languages:
@@ -76,20 +78,6 @@ An ISO image of SSDT can be used as an alternative way to install SSDT or to set
7678

7779
* [**Download Visual Studio Community 2015**](https://www.visualstudio.com/products/visual-studio-community-vs.aspx)
7880

79-
### Use SSDT in Visual Studio 2017
80-
81-
* [**Download Visual Studio 2017**](https://www.visualstudio.com/) ([compare Visual Studio 2017 features by edition](https://www.visualstudio.com/vs/compare/))
82-
83-
To use relational database projects, we recommend checking the **Data Storage and Processing** workload during installation. SSDT database project support is also included in a number of other workloads including *Azure*, *ASP.Net and Web Development*, and *.Net Core Cross Platform Development*.
84-
85-
> [!NOTE]
86-
> SSDT database projects in Visual Studio 2017 currently support up to SQL Server 2016. Support for SQL Server vNext will be coming soon in a Visual Studio 2017 update.
87-
88-
If you are using SSDT with Visual Studio 2017, install the AS and RS components:
89-
* [Analysis Services](https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftAnalysisServicesModelingProjects)
90-
* [Reporting Services](https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftReportProjectsforVisualStudio)
91-
92-
9381
## Installing SSDT without Visual Studio pre-installed
9482

9583
If you don't have Visual Studio installed on your machine, installing SSDT for Visual Studio 2015 will also install a minimal “Integrated Shell” version of Visual Studio 2015. This version of Visual Studio is free to install and use on as many machines as you wish. It gives you all the SQL Server project types, plus SQL Server Object Explorer and other SQL tools experiences.
@@ -100,9 +88,9 @@ If you do have [Visual Studio 2015 Community Edition (or above)](https://www.vis
10088

10189
|Project Templates|SQL Platforms Supported|
10290
|-------------------|--------------------|
103-
Relational databases| SQL Server 2005* - SQL Server vNext <br /><br />Azure SQL Database<br /><br />Azure SQL Data Warehouse (supports queries only; database projects are not yet supported)<br /><br /> * SQL Server 2005 support is deprecated,<br /><br /> please move to an officially supported SQL version|
104-
|Analysis Services models<br /><br />Reporting Services reports | SQL Server 2008 – SQL Server vNext|
105-
|Integration Services packages| SQL Server 2012 – SQL Server vNext |
91+
Relational databases| SQL Server 2005* - SQL Server 2017 <br /><br />Azure SQL Database<br /><br />Azure SQL Data Warehouse (supports queries only; database projects are not yet supported)<br /><br /> * SQL Server 2005 support is deprecated,<br /><br /> please move to an officially supported SQL version|
92+
|Analysis Services models<br /><br />Reporting Services reports | SQL Server 2008 – SQL Server 2017|
93+
|Integration Services packages| SQL Server 2012 – SQL Server 2017 |
10694

10795
## Next steps
10896
After installing SSDT, work through these tutorials to learn how to create databases, packages, data models, and reports using SSDT:
@@ -115,6 +103,20 @@ After installing SSDT, work through these tutorials to learn how to create datab
115103

116104
- [Create a Basic Table Report (SSRS Tutorial)](https://msdn.microsoft.com/library/ms167305.aspx)
117105

106+
## Use SSDT in Visual Studio 2017
107+
108+
* [**Download Visual Studio 2017**](https://www.visualstudio.com/) ([compare Visual Studio 2017 features by edition](https://www.visualstudio.com/vs/compare/))
109+
110+
To use relational database projects, we recommend checking the **Data Storage and Processing** workload during installation. SSDT database project support is also included in a number of other workloads including *Azure*, *ASP.Net and Web Development*, and *.Net Core Cross Platform Development*.
111+
112+
> [!NOTE]
113+
> SSDT database projects in Visual Studio 2017 currently support up to SQL Server 2016. Support for SQL Server 2017 will be coming soon in a Visual Studio 2017 update.
114+
115+
If you are using SSDT with Visual Studio 2017, install the AS and RS components:
116+
* [Analysis Services](https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftAnalysisServicesModelingProjects)
117+
* [Reporting Services](https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftReportProjectsforVisualStudio)
118+
119+
118120
## See Also
119121
[SQL Server Data Tools in Visual Studio](https://msdn.microsoft.com/library/hh272686(v=vs.103).aspx)
120122
[SSDT MSDN Forum](https://social.msdn.microsoft.com/Forums/sqlserver/home?forum=ssdt)

0 commit comments

Comments
 (0)