You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/ssdt/changelog-for-sql-server-data-tools-ssdt.md
+9-6Lines changed: 9 additions & 6 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -20,20 +20,23 @@ This change log is for [SQL Server Data Tools (SSDT) for Visual Studio 2015](htt
20
20
21
21
For detailed posts about what’s new and changed, please visit [the SSDT Team blog](https://blogs.msdn.microsoft.com/ssdt/).
22
22
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)
24
27
Build number: 14.0.61704.140
25
28
26
29
### What's New?
27
30
**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
29
32
- 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
31
34
- The DacFx API was extended to support Azure AD Universal Authentication and Multi-factor authentication (MFA)
32
35
33
36
**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
Copy file name to clipboardExpand all lines: docs/ssdt/download-sql-server-data-tools-ssdt.md
+22-20Lines changed: 22 additions & 20 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -19,12 +19,12 @@ manager: "jhubbard"
19
19
---
20
20
# Download SQL Server Data Tools (SSDT)
21
21
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.
23
23
24
24
25
25
[Download SQL Server Data Tools 17.0 for Visual Studio 2015](https://go.microsoft.com/fwlink/?linkid=846626)
- 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
37
37
- Support for Azure Analysis Services
38
38
- Ignore column order in database projects
39
39
- PowerQuery integration and support for 1400 level models
40
40
- IS package support ofr Microsoft Dynamics AX and CRM online through OData
41
41
42
42
Complete list of changes available in the [changelog](changelog-for-sql-server-data-tools-ssdt.md)
43
43
44
+
> To use SQL Server Data Tools in Visual Studio 2017 see [this](#use-ssdt-in-visual-studio-2017) section below
45
+
44
46
**Available Languages**
45
47
46
48
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
76
78
77
79
*[**Download Visual Studio Community 2015**](https://www.visualstudio.com/products/visual-studio-community-vs.aspx)
78
80
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:
## Installing SSDT without Visual Studio pre-installed
94
82
95
83
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
100
88
101
89
|Project Templates|SQL Platforms Supported|
102
90
|-------------------|--------------------|
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|
106
94
107
95
## Next steps
108
96
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
115
103
116
104
-[Create a Basic Table Report (SSRS Tutorial)](https://msdn.microsoft.com/library/ms167305.aspx)
117
105
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:
0 commit comments