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
What is new is described below. This was taken from the SQL Server Data Tools Team Blog. The biggest new feature is 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.