{"id":17159,"date":"2022-03-25T16:28:49","date_gmt":"2022-03-25T15:28:49","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/ssdt-offline-installation-for-visual-studio-2019\/"},"modified":"2022-05-31T16:39:19","modified_gmt":"2022-05-31T14:39:19","slug":"ssdt-offline-installation-for-visual-studio-2019","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/ssdt-offline-installation-for-visual-studio-2019\/","title":{"rendered":"SSDT offline installation for Visual Studio 2019"},"content":{"rendered":"

Introduction<\/h2>\n

Before Visual Studio 2019, you were able to install the SSDT with the offline installer.
\nYou were able to install it as a standalone Visual Studio for SSDT or for an already installed Visual Studio 2017. It was almost straightforward.
\nWith Visual Studio 2019, there is no SSDT standalone installer, so you have to install the extensions.
\nOf course, it can be easy if you have an internet connection, but how to install it in offline mode.
\nThis blog explains how to install offline Visual Studio 2019, its mandatory component to install afterward the SSAS and SSIS extensions.<\/p>\n

Note: refer to the Microsoft web documentation, to see if the SSDT extensions have been released for higher version of Visual Studio
\nhttps:\/\/docs.microsoft.com\/en-us\/sql\/ssdt\/download-sql-server-data-tools-ssdt?view=sql-server-ver15<\/a><\/p>\n

Installation of Visual Studio 2019<\/h2>\n

To prepare an offline installation of Visual Studio 2019 and the SSDT extensions, you need first to do some work on a computer having an internet connection.
\nFollow the steps below:
\n– First you have to download the Visual Studio Bootstrapper
\nhttps:\/\/aka.ms\/vs\/16\/release\/vs_enterprise.exe<\/a><\/p>\n

– Download the Visual Studio offline installation executing this command<\/p>\n

vs_enterprise.exe --layout c:TempVS2019_Layout --add Microsoft.VisualStudio.Workload.ManagedDesktop --add Microsoft.VisualStudio.Workload.Data --includeOptional --lang en-US\n<\/pre>\n
You can of course adjust the component you want to install depending on your development needs. My goal was to install the SSAS and SSIS SSDT extensions only, so I install the minimum required.<\/p>\n
– Copy the entire c:TempVS2019_Layout folder to a location accessible by the computer where you want install Visual Studio
\n– Then start the installation by starting the vs_setup.exe application located in the VS2019_Layout folder you copied<\/p>\n
\"\"<\/a><\/strong><\/p>\n
Useful links:<\/strong>
\n– Create an offline installation package of Visual Studio for local installation
\nhttps:\/\/docs.microsoft.com\/en-us\/visualstudio\/install\/create-an-offline-installation-of-visual-studio?view=vs-2019<\/a><\/p>\n
Installation of the SSAS and SSIS Visual Studio extension<\/h2>\n
– Download the SSAS and SSIS extensions from the Visual Studio Market place<\/p>\n
\u25cb SSAS:\u00a0 https:\/\/marketplace.visualstudio.com\/items?itemName=ProBITools.MicrosoftAnalysisServicesModelingProjects<\/a>
\n\u25cb SSIS:\u00a0https:\/\/marketplace.visualstudio.com\/items?itemName=SSIS.SqlServerIntegrationServicesProjects<\/a><\/p>\n
– Copy the SSAS extension VSIX file to the computer where you installed Visual Studio
\n– Close the Visual Studio application if it is open
\n– Execute the Microsoft.DataTools.AnalysisServices.vsix application and click on Install button<\/p>\n
\"\"<\/a><\/p>\n
 <\/p>\n
\"\"<\/a><\/p>\n