SQL Server Data Tools - November 2012 is now available!
We are pleased to announce that SSDT - November 2012 update is now available for download.
Get it here
SSDT for Visual Studio 2012: https://msdn.microsoft.com/en-us/jj650015
SSDT for Visual Studio 2010: https://msdn.microsoft.com/en-us/jj650014
What's new?
Selective XML Index support
We've added support for selective XML indexes, enabling users to import, edit, add, refactor, build, and publish selective XML indexes in SSDT.
Add new selective XML index in Table Designer
Check for SSDT Updates
This release adds support for automatic and manual checks for SSDT updates. You can view information about your current SSDT installation and verify that it's up to date by selecting "Check for Updates…" under the top-level SQL menu in Visual Studio.
Check for Updates dialog
This feature also notifies users when a newer version of SSDT is available for download.
SSDT update notification
Updated Data-Tier Application Framework (DACFx)
SSDT – November 2012 includes the October DACFx redist (11.1.2816.0). The October DACFx release contains several feature enhancements and bug fixes outlined in this post: https://blogs.msdn.com/b/ssdt/archive/2012/10/10/sql-server-data-tier-application-framework-october-2012-available.aspx
Updated SQL Server 2012 components
SSDT – November 2012 is coordinated with the release of SQL Server 2012 Service Pack 1 and it chains in the latest SQL Server components.
Bug fixes
This release contains over 30 bug fixes, including fixes for customer-reported issues from SSDT - September 2012.
Power Tools Compatibility
The November 2012 update of SSDT is only compatible with the latest SSDT Power Tools (v 1.4). Please note that if you have an existing version of SSDT Power Tools, it will need to be upgraded in order to work with SSDT – November 2012. Edit: SSDT Power Tools are no longer available via the links below, but have been integrated into the core SSDT product in the December 2012 release (https://blogs.msdn.com/b/ssdt/archive/2012/12/13/available-today-ssdt-december-2012.aspx)
Contact Us
If you have any questions or feedback, please visit our forum or Microsoft Connect page. We look forward to hearing from you.
Comments
Anonymous
November 07, 2012
No new features in the Power Tools I assume?Anonymous
November 07, 2012
Good question -- no new features but the Power Tools have been updated to support the latest release. For example, you can now see Selective XML Indexes under the Projects node in SSOX.Anonymous
November 09, 2012
The comment has been removedAnonymous
November 12, 2012
@Bertie if you don't have Visual Studio on your machine, SSDT will chain it in automatically during installation. There's no need to manually add it beforehand.Anonymous
November 13, 2012
Janet, Since it says "SSDT – November 2012 is coordinated with the release of SQL Server 2012 Service Pack 1" which one should I install on my local machine first? The SSDT Nov. 2012 update or SP1 for SQL 2012? Or does it not matter?Anonymous
November 13, 2012
@SQLVariant Relative install order with SQL Server SP1 doesn't matter -- the SSDT installer will adjust as needed. If you don't have the most recent version of SSDT SQL dependencies like T-SQL Language Service, Shared Mangement Objects, etc., then SSDT will chain in the SP1 version of these dependencies. If you already have them, SSDT will detect that this is the case and skip them during SSDT install.Anonymous
November 14, 2012
I have a question what with grant on procedures where put them?Anonymous
November 15, 2012
So, no Entity Framework integration?Anonymous
November 15, 2012
The comment has been removedAnonymous
November 15, 2012
I've VS 2012, SQL 2012 SP1 and installed SSDT Nov 12 update. When I open up VS 2012, I don't see the BI templates. What am I missing?Anonymous
November 15, 2012
Are there any prerequisites for installing this (other than having VS 2012 shell installed)? I have VS2012 shell installed (was installed for Team Explorer). SSDT installed successfully (I guess), but when I try to connect to a SQL instance (2008 and 2012), I'm getting "Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information." I do have VS2010/SSDT installed as part of a SQL2012 instance on my machine. Could this be causing conflicts? Any ideas? Thanks, AnneAnonymous
November 16, 2012
So can we finally use the SSDT Projects for SSRS/SSAS/SSIS in VS2012 ?Anonymous
November 16, 2012
The comment has been removedAnonymous
November 16, 2012
@Anne having the shell actually isn't a prerequisite. If you have the Visual Studio shell in a Pro+ SKU, SSDT will integrate into if. If not, SSDT setup will lay down the Visual Studio integrated shell. Regarding the error you're seeing, are you connecting via SQL Server Object Explorer? And can you access this instance successfully via SSMS? For more in depth investigation of this issue, you should start a thread on the SSDT forum: social.msdn.microsoft.com/.../threadsAnonymous
December 03, 2012
What types of data cleansing related tools/processes are available for SQL Server 2012 - both Tools and MDM? For example, loading customer records that require address validation, name validation and de-duplication?Anonymous
December 04, 2012
@Howard SSDT does not provide any data cleansing featuresAnonymous
December 11, 2012
I have installed Visual Studio Profession 2012 with SP1 from my MSDN benefits subscription, and have installed the latest November version of SSDT which is suppose to integrate with VS 2012, however it's not working. I have also installed SQL Server 2012 STandard edition selecting all reporting services tools. This is the november SSDT install link i used: msdn.microsoft.com/.../jj650015 When i open VS 2012 professional and try to create a new project I can't see any business intelligence templates, such as the project template for reporting services project. When I open VS 2010 it does however show. What did i miss? THanksAnonymous
December 11, 2012
The comment has been removedAnonymous
June 24, 2013
Can the script task in SSIS 2012 now access the entity framework?