Install Microsoft Build Tools for Visual Studio

Follow the procedure below to create an offline installer package for build tools and install it on a server that has no internet connectivity (that is, a server running the EFMBufferDacPacGenerator tool).

To install Microsoft Build Tools for Visual Studio

1. On a server with internet connectivity, navigate to the following site and download the Build Tools for Visual Studio installer:

   https://visualstudio.microsoft.com/downloads/?q=build+tools

2. Create a folder to store the offline files.

   The following steps, for example, use C:\BuildToolsInstaller.

3. Open a Windows PowerShell session and navigate to the location of the Build Tools installer (vs_BuildTools.exe).

4. Execute the following command:

   .\vs_BuildTools.exe --layout C:\BuildToolsInstaller --lang en-US --add Microsoft.VisualStudio.Component.SQL.SSDTBuildSku --add Microsoft.Net.ComponentGroup.4.8.DeveloperTools

5. Wait for the download to complete.

6. Move the contents of the offline Build Tools files (for example, C:\BuildToolsInstaller) to the server on which you want to install Build Tools.

   This is the server where you will run EFMBufferDacPacGenerator to create the Data-tier Application Package (DACPAC) file for the Electronic Flow Measurement (EFM) Buffer database.

7. Start an elevated PowerShell session.

8. Navigate to the location of the Build Tools installation files that you copied over in step 6 (for example, C:\BuildToolsInstaller).

   It is possible for files to be blocked if they are copied from a jumpbox to a SCADA machine and the mspatch levels at the jumpbox are outdated. To unblock the files, proceed as follows:

   1. Open a Windows PowerShell session.

   2. Set the location to the location of the files.

   3. Execute the following command:

      dir -Recurse | Unblock-File

9. Execute the following command to install Build Tools without any user interaction (suitable for both Windows Server Core and Desktop Experience installations):

   $process = Start-Process -FilePath vs_BuildTools.exe -ArgumentList "--noWeb", "--add", "Microsoft.VisualStudio.Component.SQL.SSDTBuildSku", "--add", "Microsoft.Net.ComponentGroup.4.8.DeveloperTools", "--quiet", "--wait" -Wait -PassThru

10. Execute the following command (it should return zero to indicate a successful installation):

    Write-Output $process.ExitCode

    Note: The default location of the MSBuild executable is C:\Program Files (x86)\Microsoft Visual Studio\2022\BuildTools\MSBuild\Current\Bin. If this has been customized (by deviating from the steps above), you must update the MSBuildLocation configuration setting in the %DNADataRoot%\CloudData\Config\Settings\CloudData.json override file to match your actual installation directory.