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.

sc2

Entry point for Data Comparison from SQL Server Object Explorer

sc1

Data Comparison showing two different records in Source and Target

Extensibility

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

buildaction

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

About James Serra

James is SQL Server MVP and a independent consultant with the title of Business Intelligence/Data Warehouse/Master Data Management Architect and Developer, specializing in the Microsoft SQL Server BI stack.
This entry was posted in SQLServerPedia Syndication, SSDT/Juneau. Bookmark the permalink.

One Response to SQL Server Data Tools (SSDT) – June 2013 update

  1. Jonathan Weavers says:

    Hey James-

    Your last post [SQL Server Data Tools (SSDT) – June 2013 update] was freaking awesome. I have gone ahead and added your stuff to my Feedly account. Please keep me updated if you post anywhere else.

    Keep rocking –

    Jon

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>