- [Voiceover] As a longtime Visual Studio user,I've watch the data tools morph and change over the years.In this video, I'd like to talk about a set of toolsknown as the SQL Server Data Tools,also called the SSDT.They first appeared on the scene in 2008.At that point in time, the Visual Studio teamand the SQL Server team joined forcesto produce a tools set for Visual Studio.The SSDT were an integrated part of Visual Studio 2008.For people that worked with SQL Serverbut didn't need a copy of Visual Studio,there was another tool calledthe Business Intelligence Development Studio.
The same tools were in both applications.Of course, Visual Studio containeda lot of other developer tools besides the SSDT tools.Basically, the tools were designedto make it easier to use with SQL Serverduring tasks that make sense for developersand business analysts, not database administrators.For the analysts, there was a set ofbusiness intelligence tools.You could create and view reportswith the SQL Reporting Services,and analyze your data with the Analysis Services.For the developer, there were toolsfor the development workflow.For example, the server explorermakes it simple to connect to data servers from the IDE.
There were tools for comparing the datain two databases, and one for comparingthe database schema between databases.There were database entity viewers.These tools allowed a developerto view and edit a database tableor stored procedure directly in Visual Studio.No need to install the SQL Server Management Studio.The tool was well received,but then something happened in the next release.The SQL team and the Visual Studio teamshipped on different schedules,so the tooling in Visual Studiobecame unsynced and chaotic for a few releases.
There was no support for SSDT in Visual Studio 2010,and a confusing mix of tools in Visual Studio 2012.Finally, with the release of Visual Studio 2013,the SSDT tools returned and were availablein the Visual Studio installer.The same is true in Visual Studio 2015.The SSDT tools are part of the installer,but there are some minor quibbles.Most of the developer centric toolsare part of the default install,so you'll be able to use them without much effort.The rest of the tools, mostly the onestargeted at the business analysis side,are not in the default install.
Apr 13, 2012 - Explains the different ways to install SQL Server Data Tools (SSDT) and how that. I have Visual Studio 2010 SP1, SSDT and SQL Server 2012 Express. MS only provides the download links for SSDT for VS 2012 and 2013.
Programs related to 'Sql server data tools visual studio 2010' Visual Studio 2017 RC Free Download Visual Studio 2017 RC is an update of Microsoft IDE with some improvements and new solutions.
If Visual Studio is not installed, selecting Install a new SQL Server Data Tools instance installs SSDT with a minimal version of Visual Studio, but for the best experience we recommend using SSDT with the latest version of Visual Studio.
The good news is that they are easy to add to Visual Studio.It's not necessary to download any additional installers.The tools in this version of the SSDare similar to what was in the original release.You'll find all the business intelligence tools are there.Naturally, Microsoft has updated some of the tools,so you'll find improved entity framework designersin the package.You'll find the database project templatesin the new project dialog,and all the standard IDE Windows are there, too,like the SLQ Explorer and the Table Designers.
In the next video, I'll show you how to installthe entire SSDT feature setwith the Visual Studio installer.
I'm studying Sql Server Data Tools (SSDT). Do I need a Visual Studio 2010 / 2012? Can I use a express edition?
Thiago CustodioThiago Custodio
4 Answers
Sql Server Data Tools 2012
SSDT replaces Business Intelligence Development Studio (BIDS) from SQL Server 2008, regarding Integration Services, Analysis Services and Reporting Services. When you install SQL Server 2012, you get an option to install SSDT. In this case, SSDT will be installed in an empty shell of Visual Studio 2010, with nothing but the BI project types (Integration Services project, Analysis Services project, etc.)
Visual Studio And Sql Server
If you are talking about the non-BI related features of SSDT (Database Project, Database unit testing, etc.) you need a pre-installed version of Visual Studio 2010 or 2012, Express edition is not supported.
DanDan
Visual Studio Express Edition is not supported by SSDT.
SSDT with VS 2015 can be installed without having Visual Studio, and SSDT will install Visual Studio with the limited features needed for SSDT, HOWEVER you must be sure to install .NET Framework 4.5 before trying to install SSDT. If .NET Framework 4.5 is not present, the installer will fail immediately, and most likely will tell you that you need Visual Studio. I ran into this while trying to install on Windows Server 2008 R2, and everything worked well once .NET Framework 4.5 was installed.
djcmtidjcmti
SSDT is included in most Visual Studio 2013 Express editions, and for earlier versions of Visual Studio you can download a free standalone install from the web. All of the available install options are listed on the download page. Take a look there and hopefully one of the options will suit you.
Kevin CunnaneKevin Cunnane
Not the answer you're looking for? Browse other questions tagged sql-servervisual-studio-2010visual-studio-2012 or ask your own question.