--layout
option is the key, it downloads the actual files for the offline installation. Replace <filepath>
with the actual layouts path to save the files.vs_sql.exe --layout c:<filepath> --lang en-us
(a single language is ~1 GB).--lang
argument: vs_sql.exe --layout c:<filepath>
(all languages are ~3.9 GB).vs_setup.exe --NoWeb
to install the VS2017 Shell and SQL Server Data Project.SSDT-Setup-ENU.exe /install
and select SSIS/SSRS/SSAS.a. For an unattended installation, run SSDT-Setup-ENU.exe /INSTALLALL[:vsinstances] /passive
.SSDT-Setup-ENU.exe /help
SSDT-Setup-ENU.exe
from this newly created folder (don’t add SSDT to another Visual Studio 2017 offline layout). If you add the SSDT layout to an existing Visual Studio offline layout, the necessary runtime (.exe) components are not created there.Project Templates | SQL Platforms Supported |
---|---|
Relational databases | SQL Server 2005* - SQL Server 2017 (use SSDT 17.x or SSDT for Visual Studio 2017 to connect to SQL Server on Linux) Azure SQL Database Azure Synapse Analytics (supports queries only; database projects aren't yet supported) * SQL Server 2005 support is deprecated, move to an officially supported SQL version |
Analysis Services models Reporting Services reports | SQL Server 2008 - SQL Server 2017 |
Integration Services packages | SQL Server 2012 - SQL Server 2019 |