SQL Server Data Tools (SSDT) Updates

2 posts · Jun 2007 – Dec 2012

What this trail covers

This thread tracks updates to SQL Server Data Tools (SSDT), including new features like selective XML index support, automatic update checks, and integration with the latest Data-Tier Application Framework (DACFx) and SQL Server 2012 components. It also addresses bug fixes and compatibility with SSDT Power Tools. This post details the release of power tools for Team Edition for Database Professionals, including database refactoring, schema and data comparison at a command prompt, sequential data bound generator for test data, and IntelliTrace for WCF services.

All Microsoft trails

Dec 2012ASP.NET and Web Tools 2012 RC, TFS 2012 Monitoring Management Pack AND SQL Server Data Tools December 2012 release now availableIntroduced database unit testing functionality based on Visual Studio 2010 DB Pro tools, allowing client-side testing with MSTest, integration with SSDT SQL Server database projects, and support for custom test conditions. Integrated previous SSDT Power Tools features into the core SSDT product, including the Projects node for schema browsing, Script As support for generating Create, Alter, Drop, and Drop and Create-To scripts, and DAC actions for managing dacpacs. Updated the Data-Tier Application Framework (DACFx) to its November 2012 release and included over 50 bug fixes.
Nov 2012SQL Server Data Tools - November 2012 is now available!This post announces the November 2012 update for SQL Server Data Tools (SSDT), introducing support for selective XML indexes, automatic and manual checks for SSDT updates, an updated Data-Tier Application Framework (DACFx), and integration with SQL Server 2012 Service Pack 1 components. It also includes over 30 bug fixes and notes compatibility requirements with SSDT Power Tools v1.4.
Aug 2007Now available: Power Tools for Team Edition for Database Professionals with Service Release 1This post announces the first release of power tools for Team Edition for Database Professionals. Key features include database refactoring (moving objects, fully qualifying names, expanding wildcards, generating refactoring scripts), command-line schema and data comparison, easier specification of regular expressions and data-bound columns, a sequential data bound generator for filling tables with reference data, organizing database projects by schema or object type, viewing object references, static code analysis for T-SQL, and developing Visual Studio add-ins. It also details the sequential data bound generator's functionality and limitations.
Jun 2007Managing Reference Data in Visual Studio Team Edition for Database ProfessionalsThis post details three methods for managing reference data in Visual Studio Team Edition for Database Professionals: the original Data Bound Generator (highlighting its limitations with random row selection and potential for duplicate entries), post-deployment scripts (advocating for cleaner separation and providing T-SQL examples for inserting data and ensuring data reset), and the upcoming Sequential Data Bound Generator (explaining its expected behavior and advantages over the original).
Advertisement