Thursday, February 7, 2013

Want to know more about SSDT?


I personally think Microsoft made a mess of this SSDT installation. It's really more confusion than anything else. The SSDT download is included as a project type with a name that can be stored. It's either a project or not a project. if it is it should not be a download.
In the shell that downloads with SQL Server 2012 Enterprise (Eval) which is supposed to have all features:
Product Info:
Microsoft SQL Server Integration Services Designer
Version 11.0.2100.60
Installed products:
Microsoft Visual Studio 2010
Version 10.0.40219.1 SP1Rel
Microsoft .NET Framework
Version 4.5.50709 SP1Rel
Installed Version: IDE Standard
Microsoft Visual Basic 2010 01011-532-2002361-70264
Microsoft Visual Basic 2010
Microsoft Visual C# 2010 01011-532-2002361-70264
Microsoft Visual C# 2010
Microsoft Visual Studio Tools for Applications 3.0 01011-532-2002361-70264
Microsoft Visual Studio Tools for Applications 3.0
Microsoft Visual Web Developer 2010 01011-532-2002361-70264
Microsoft Visual Web Developer 2010
Hotfix for Visual Studio 2010 Shell (Integrated) - ENU (KB2548139) KB2548139
This hotfix is for Visual Studio 2010 Shell (Integrated) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2548139.
Hotfix for Visual Studio 2010 Shell (Integrated) - ENU (KB2549864) KB2549864
This hotfix is for Visual Studio 2010 Shell (Integrated) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2549864.
Hotfix for Visual Studio 2010 Shell (Integrated) - ENU (KB2635973) KB2635973
This hotfix is for Visual Studio 2010 Shell (Integrated) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2635973.
Security Update for Visual Studio 2010 Shell (Integrated) - ENU (KB2645410) KB2645410
This security update is for Visual Studio 2010 Shell (Integrated) - ENU.
If you later install a more recent service pack, this security update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2645410.
SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 11.0.2100.60
SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 11.0.2100.60
SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 11.0.2100.60
Visual Studio 2010 Shell (Integrated) - ENU Service Pack 1 (KB983509) KB983509
This service pack is for Visual Studio 2010 Shell (Integrated) - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/983509.
So, what does the SSDT shortcut under Microsoft SQL Server 2012 bring up?
Analysis Services Project
Reporting Services Project
Integration Services Project
SQL Server Project which is realy not a project but points to a SSDT download (can it be any more confusing than this!!)
A Silverlight template (C# and VB) for WCF RIA Services Class Library and a Silverlight line of business application.


------------------------------------------------------------------------------------------------------------
In Visual Studio 2012 Ultimate (x64) what we have is:
Microsoft Visual Studio Ultimate 2012
Version 11.0.51106.01 Update 1
Microsoft .NET Framework
Version 4.5.50709
Installed Version: Ultimate
Architecture and Modeling Tools 04940-004-0036005-02064
Microsoft Architecture and Modeling Tools

UML® and Unified Modeling Language™ are trademarks or registered trademarks of the Object Management Group, Inc. in the United States and other countries.
LightSwitch for Visual Studio 2012 04940-004-0036005-02064
Microsoft LightSwitch for Visual Studio 2012
Office Developer Tools 04940-004-0036005-02064
Microsoft Office Developer Tools
Team Explorer for Visual Studio 2012 04940-004-0036005-02064
Microsoft Team Explorer for Visual Studio 2012
Visual Basic 2012 04940-004-0036005-02064
Microsoft Visual Basic 2012
Visual C# 2012 04940-004-0036005-02064
Microsoft Visual C# 2012
Visual C++ 2012 04940-004-0036005-02064
Microsoft Visual C++ 2012
Visual F# 2012 04940-004-0036005-02064
Microsoft Visual F# 2012
Visual Studio 2012 Code Analysis Spell Checker 04940-004-0036005-02064
Microsoft® Visual Studio® 2012 Code Analysis Spell Checker
Portions of International CorrectSpell™ spelling correction system © 1993 by Lernout & Hauspie Speech Products N.V. All rights reserved.
The American Heritage® Dictionary of the English Language, Third Edition Copyright © 1992 Houghton Mifflin Company. Electronic version licensed from Lernout & Hauspie Speech Products N.V. All rights reserved.
Visual Studio 2012 SharePoint Developer Tools 04940-004-0036005-02064
Microsoft Visual Studio 2012 SharePoint Developer Tools
NuGet Package Manager 2.0.30625.9003
NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.
PreEmptive Analytics Visualizer 1.0
Microsoft Visual Studio extension to visualize aggregated summaries from the PreEmptive Analytics product.
SQL Server Data Tools 11.1.21208.0
Microsoft SQL Server Data Tools
Web Developer Tools 1.0.30710.0
Microsoft Web Developer Tools contains the following components:
Page Inspector: Tool that offers an efficient way to decompose Web Applications and diagnose front-end issues.
Web Publishing: Extensions required for Web Publishing for both hosted servers as well as on premises.
Web Form Templates: Includes the default templates for Web Form Applications.
Editor Extensions: Includes HTML, CSS, and JS editor extensions that greatly enhance the development experience.
So, What does Vs2012 Ultimate have by way of BI?
There is suddenly a Reports Application (I have not tried)
Of course there are the Report Viewer Controls you can use (Windows and Web)
A Sql Server Database Project template (this I suspect is part of the SSDT as originally meant)
As you pointed out you need both SSDT as well as VS2012 Pro and above.



Mahalo