The product that we originally knew as BIDS, and then SSDT was renamed one again for the SQL Server 2014 wave of products. Apparently there are a finite quantity of names. So what’s going on here?Īs it turns out, a separate Microsoft team put out a separate set of VS project templates in the SQL Server 2012 timeframe that were also called SQL Server Data tools. You’ll instead find projects for deploying databases and DACPACs. However, if you search for SQL Server Data Tools and download the version for either Visual Studio 2012 or Visual Studio 2013, you won’t find the projects that you were looking for. This is also true with SQL 2014, but now, a download is the only way to get the tools. These products don’t require a license to deploy and use, so they were freely available. It was always possible to download BIDS or SSDT directly from Microsoft. Data tools is no longer available from the SQL Server installation media. SQL Server 2014 is the latest SQL Server version, and it introduced another major change. Simply substitute SSDT for BIDS, and everything is pretty much as it once was. The installation experience didn’t change fundamentally, the installation option just took on the new name.

As expected, the requisite level of Visual Studio was incremented and SSDT was based on Visual Studio 2010. Henceforth they were to be known as SQL Server Data Tools (SSDT). In addition to the projects required for tabular models in SSAS being added to the tools, they also received a new name. When SQL Server 2012 was released, a change was introduced. Installing BIDS is straightforward, you simply run setup from the SQL Server media, and select “Business Intelligence Development Studio”. If, for example you had Visual Studio 2010 already set up, installing BIDS would still install a different Visual Studio to support the projects. The projects were tied tightly to the Visual studio versions. The original version was based on Visual Studio 2005, and subsequent releases of SQL Server stayed in step with more recent versions of Visual Studio. It was originally introduced with SQL Server 2005, and was included on the SQL distribution media as an optional install component.īIDS was a distribution of the Visual Studio shell, and a set of bundled project types for creating cubes, SSIS packages and SSRS reports. The original incarnation of the tools was called Business Intelligence Development Studio, or just BIDS.

These tools have always been bundled into a single product as part of the SQL Server distribution. What I’m talking about are the tools that are used by designers to create BI objects in the SQL Server Business Intelligence stack, specifically Analysis Services (SSIS) OLAP cubes and tabular models, Integration Services (SSIS) ETL packages, and Reporting Services (SSRS) reports. The Business Intelligence design components of SQL Server have an identity crisis.

Download sql server 2008 r2 bids