Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

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

Comments

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

Loading comments...