Move to an officially supported SQL versionĭownload SSDT for Visual Studio 2017 (15.9.10) If Visual Studio isn't already 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.Īzure Synapse Analytics (supports queries only database projects aren't yet supported) The installer lists available Visual Studio instances to add SSDT tools.
To install Analysis Services, Integration Services, and Reporting Services project support, run the SSDT standalone installer. Install Analysis Services, Integration Services, and Reporting Services tools Select SQL Server Data Tools under Data storage and processing in the list of workloads. In the installer, select for the edition of Visual Studio that you want to add SSDT to, and then choose Modify. In the Windows Start menu, you can search for "installer". If Visual Studio is already installed, use the Visual Studio Installer to modify the installed workloads to include SSDT. To install SSDT during Visual Studio installation, select the Data storage and processing workload, and then select SQL Server Data Tools.
Now to create Analysis Services, Integration Services, or Reporting Services projects, you still need the SSDT standalone installer. There's no need to install the SSDT standalone installer for the core SSDT experience. Starting with Visual Studio 2017, the functionality of creating Database Projects has been integrated into the Visual Studio installation. SSDT for Visual Studio 2017 Changes in SSDT for Visual Studio 2017 Only one shell is installed per version of Visual Studio installing a second SSDT just adds the missing templates. Otherwise, you probably need to install multiple previous versions to get all of the templates used in SQL Server. To get all of the project templates together in one SSDT, you need the newest version. Previous versions came with distinct sets of project templates. Historically, the Visual Studio shell used to create SQL Server content types has been released under various names, including SQL Server Data Tools, SQL Server Data Tools - Business Intelligence, and Business Intelligence Development Studio.
SSDT is backwards compatible, so you can always use the newest SSDT to design and deploy databases, models, reports, and packages that run on older versions of SQL Server. SQL Server Data Tools (SSDT) provides project templates and design surfaces for building SQL Server content types - relational databases, Analysis Services models, Reporting Services reports, and Integration Services packages.
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
0 kommentar(er)
