Most of the developer centric tools are part of the default install, so you'll be able to use them without much effort. The SSDT tools are part of the installer, but there are some minor quibbles. Finally, with the release of Visual Studio 2013, the SSDT tools returned and were available in the Visual Studio installer. There was no support for SSDT in Visual Studio 2010, and a confusing mix of tools in Visual Studio 2012. The SQL team and the Visual Studio team shipped on different schedules, so the tooling in Visual Studio became unsynced and chaotic for a few releases. The tool was well received, but then something happened in the next release. No need to install the SQL Server Management Studio. These tools allowed a developer to view and edit a database table or stored procedure directly in Visual Studio. There were tools for comparing the data in two databases, and one for comparing the database schema between databases. For example, the server explorer makes it simple to connect to data servers from the IDE. For the developer, there were tools for the development workflow. You could create and view reports with the SQL Reporting Services, and analyze your data with the Analysis Services. For the analysts, there was a set of business intelligence tools. Basically, the tools were designed to make it easier to use with SQL Server during tasks that make sense for developers and business analysts, not database administrators. Of course, Visual Studio contained a lot of other developer tools besides the SSDT tools. The same tools were in both applications. For people that worked with SQL Server but didn't need a copy of Visual Studio, there was another tool called the Business Intelligence Development Studio. The SSDT were an integrated part of Visual Studio 2008. At that point in time, the Visual Studio team and the SQL Server team joined forces to produce a tools set for Visual Studio. They first appeared on the scene in 2008. In this video, I'd like to talk about a set of tools known as the SQL Server Data Tools, also called the SSDT. As a longtime Visual Studio user, I've watch the data tools morph and change over the years.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |