Find and eliminate implicit dependencies (OSOE-458)

[sarahelsaig]

The Get-FtpFiles script relies on WinSCP via "WinSCPnet.dll", although it looks like this task can be done without using third party resources.

Also there are some hard-coded paths which rely on the default Program Files locations which is not in C for everyone or the app may not be installed in the default location.

• Utility-Scripts/Azure/Start-AzureStorageEmulator/Start-AzureStorageEmulator.psm1

  Line 21 in 478d28d

  $path = "C:\Program Files (x86)\Microsoft SDKs\Azure\Storage Emulator\AzureStorageEmulator.exe"

• Utility-Scripts/SqlServer/Import-BacpacToSqlServer/Import-BacpacToSqlServer.psm1

  Line 70 in f4104dc

  $defaultSqlPackageExecutablePath = "C:\Program Files\Microsoft SQL Server\$($i)0\DAC\bin\SqlPackage.exe"

• Utility-Scripts/SqlServer/Import-BacpacToSqlServer/Import-BacpacToSqlServer.psm1

  Line 78 in f4104dc

  $defaultSqlPackageExecutablePath = "C:\Program Files (x86)\Microsoft SQL Server\$($i)0\DAC\bin\SqlPackage.exe"

There might be others.

Jira issue