SQL Server Data Tools (SSDT)

SQL Server Data Tools (SSDT) is a Microsoft development toolset integrated into Visual Studio for designing, building, and deploying SQL Server databases, SSIS packages, SSAS models, and SSRS reports using a declarative model. It evolved from Business Intelligence Development Studio (BIDS),…

Key facts

First appeared: 2012
Category: technology
Problem solved: SSDT addressed fragmented development workflows for SQL Server databases and BI components by unifying database projects, SSIS, SSAS, and SSRS development in Visual Studio, replacing ad-hoc scripting and manual deployments with declarative modeling, version control, and automated publishing that predecessors like BIDS handled only partially for BI.
Platforms: Visual Studio (cross-platform via VS Code extensions for some features), Windows

Related technologies

SQL Server
SSRS
Visual Studio
Azure DevOps
SSIS
SSAS

Notable users

Government agencies
Financial services firms
Fortune 500 enterprises
Microsoft