SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL Server Data Tools (SSDT) – June 2013 update

SQL Server Data Tools (SSDT) has a new update:

VS 2010: June 2013 version: 10.3.30618.1, December 2012 version: 10.3.21208.0, November 2012 version: 10.3.21101.1, September 2012 version: 10.3.20905.0, initial version: 10.3.20225.0

VS 2012: June 2013 version: 11.1.30618.1, December 2012 version: 11.1.21208.0, November 2012 version: 11.1.21101.1, September 2012 version: 11.1.20905.0, version shipped with VS 2012: 11.1.20627, initial version: 11.1.20225.0

Downloads: For Visual Studio 2010, For Visual Studio 2012

What is new is described below.  This was taken from the SQL Server Data Tools Team Blog.  The biggest new feature is Data Compare:

Data Compare

We received significant feedback that Data Compare is a critical feature for SSDT customers, so this release of SSDT enables the visual data comparison between a customizable list of tables/views in two databases.  From this comparison, a script to update the table data in the target database can be generated.  This is a new addition to SQL Server Data Tools and brings with it support for all SQL Server platforms supported by SSDT including SQL Server 2012 and Windows Azure SQL Database.


Entry point for Data Comparison from SQL Server Object Explorer


Data Comparison showing two different records in Source and Target


This release brings with it a significant payload of updates and additions to the extensibility scenarios supported in SSDT and DACFx.

Build & Deployment contributors

This extensibility point allows hooking custom code up to the existing DACFx build or deployment pipeline. Similar to previous database project extensibility, this enables advanced build and deployment scenarios like auto-generating documentation, custom difference reports, or injecting custom data motion logic into the deployment plan. The three supported contributor types are:

· Build Contributors – Extension that runs when the database project is being built and allows read-only access to the schema model and all properties and arguments of the build task

· Deployment Plan Modifier – Extension that runs after the deployment plan has been generated allowing read/write access to the deployment plan, and read-only access to the model comparison results, and source/target schema models

· Deployment Plan Executor – Extension that runs during deployment allowing read-only access to the deployment plan


New Build Action in SSDT projects for deployment contributors

Schema Model Navigation and Extensibility API

Another addition to this release is the exposure of an API allowing navigation of the schema model contained in a DACPAC or BACPAC. This API allows you to reason over the objects and relationships contained in the schema model generated by DACFx. In addition, this allows you to implement custom solutions on top of DAC package navigation like synchronization with a data access model, writing custom schema navigation and browsing tools, and perform additional schema validation.

Updated Data-Tier Application Framework

This release includes the June 2013 release of SQL Server Data-Tier Application Framework (DACFx), which contains several feature enhancements and bug fixes.

More info:

Announcing SQL Server Data Tools – June 2013

James Serra's Blog

James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.


Leave a comment on the original post [www.jamesserra.com, opens in a new window]

Loading comments...