SSDT June 2015 Preview

Today we announce the latest preview of SQL Server Data Tools (SSDT). It is the first release from our fast-train preview program. Fast-train preview program implies that SSDT will be on a frequent release cadence, which starts today with the June 2015 preview. The June preview update provides support for new SQL features in Azure SQL Database and SQL Server 2016 CTP2.1. SSDT June 2015 preview is supported with Visual Studio 2013.

Who can benefit from using the Preview?

• Azure SQL Database developers with the latest GA and Preview features.
• SQL Server 2016 CTP2.1 database developers who would like to try the new CTP features.
• Database developers who enjoy using new tooling features.

Get it here: Download SSDT June 2015 Preview for Visual Studio 2013

• The version number for the latest preview of SSDT is 12.0.50623
• SSDT Preview for Visual Studio 2015 will be coming later this year.

Download Data-Tier Application Framework June 2015 Preview

• The version number for the latest preview of DacFx is 13.0.2993.2

What’s New in SSDT and DacFx?

• Connected development support for Azure SQL Data Warehouse
• Row-Level Security support.
• Support for new ColumnStore index enhancements.

Known Issues

• SQL Server Object Explorer may not list tables if a non-DBO user or a user without CONTROL permission connects to the database. It impacts the browsing table and operations such as  import database and publish functions based on the permission settings.  

Contact Us

If you have any questions or feedback, please visit our forum or Microsoft Connect page.  We are fully committed to improve the SSDT experience and look forward to hearing from you!

• Anonymous
  June 28, 2015
  Hi. Thank you for such great tool. I am not sure if it is the right place to ask, but it would be very nice to have more flexible way to control what objects to drop/not to drop. It would be very nice to have ability to publish/not publish specific schemas (or even specific objects). Let's say I have schema TEST that contains unit tests that are not supposed to go to production. Currently I do not know any proper way how to do that.

• Anonymous
  June 29, 2015
  @Dimitrij, thanks for your suggestion. A customer has written a deployment contributor that can be used for this purpose – see the.agilesql.club/.../HOWTO-Filter-Dacpac-Deployments. For now this is the best option for your scenario, I think you'll find it very useful. Kevin

• Anonymous
  July 06, 2015
  Hi Kevin. Yes, I know this contributor. However there are some problems to use external DLLs in our company :( On more thing about SSDT. It has 1 issue with merging. I've posted the question on stackoverflow: stackoverflow.com/.../manage-ssdt-project-file-properly-with-version-control-sqlproj

• Anonymous
  July 07, 2015
  Great tools but it still is not backward compatible for SQL Server 2012 Integration Services for SSIS Packages.  When will that be available for us that can't upgrade to SQL Server 2014?  I still get "Package migration from version 8 to version 6 failed"  with this version.  Thanks

• Anonymous
  July 15, 2015
  @Fred, an update for the Business Intelligence tools will be coming later this year. This preview only updates the database tools. Stay tuned for future blog posts which will discuss the BI tooling updates.  

• Anonymous
  July 16, 2015
  When I install the DacFx 13.0.2993.2 with msiexec /i DACFramework.msi /qn accept=yes and then run a sqlpackage /a:import, it can't find Microsoft.SqlServer.TransactSql.ScriptDom.dll. Could your please ship that too with the DacFx?