Offline installation of mssql extention for vscode

[bcibiks]

Please can you point me to the location of the latest installation vsix file for my OS?
https://github.com/microsoft/vscode-mssql/releases/tag/v1.22.1 is the last version with these sort of vsix files

From reading the notes below - this is still supported
https://learn.microsoft.com/en-us/sql/tools/visual-studio-code-extensions/mssql/mssql-extension-visual-studio-code?view=sql-server-ver16

Supported operating systems

Currently, this extension supports the following operating systems:
Windows (x64 | x86 | Arm64)
macOS (x64 | Arm64)
Linux Arm64
Ubuntu 18.04, 20.04, 22.04
Debian 10, 11, 12
CentOS 7, 8 / Oracle Linux 7, 8
Red Hat Enterprise Linux (RHEL): 8, 9
Fedora 35,36
OpenSUSE Leap 15

Offline installation

The extension can download and install a required SqlToolsService package during activation. You can still use the extension for machines with no Internet access by choosing the Install from VSIX... option in the Extension view and installing a bundled release from our Releases page. Each operating system has a .vsix file with the required service included. Pick the file for your OS, download, and install it to get started. We recommend you choose a full release and ignore any alpha or beta releases, as these are our daily builds used in testing.

[kburtram]

@Benjin do you know if we reenabled the offline VSIX builds after the build pipeline updates?

[Benjin]

We didn't. IIRC, we were blocked on a signing issue that might've been related to/resolved the new VSIX signing operation. I'll revive that workitem.

[jerronl]

Yes please! I'm suffering the old issue #391 (comment) .
Also, my company blocked downloading from github, such as https://github.com/microsoft/sqltoolsservice/releases. Can we have such files downloadable from visualstudio.com, like the normal vsix files?

[kburtram]

Yes please! I'm suffering the old issue #391 (comment) . Also, my company blocked downloading from github, such as https://github.com/microsoft/sqltoolsservice/releases. Can we have such files downloadable from visualstudio.com, like the normal vsix files?

Unfortunately, visualstudio.com doesn't currently support hosting platform-specific VSIX files. However, we understand your concern, especially given the restrictions from your company's network.

One potential solution we could explore is refactoring the .NET Core binaries used for database interactions into a platform-independent package. This would allow us to use the .NET Install Tool extension to handle platform-specific runtimes. While this is a feasible direction, it would require some development effort and testing to ensure a smooth user experience.

We appreciate your feedback and will consider this as we explore future improvements.

[Benjin]

That may no longer be true, actually! I noticed this last week for the Jupyter notebooks extension:

And with some digging: https://code.visualstudio.com/api/working-with-extensions/publishing-extension#platformspecific-extensions

[kburtram]

That may no longer be true, actually! I noticed this last week for the Jupyter notebooks extension:

And with some digging: https://code.visualstudio.com/api/working-with-extensions/publishing-extension#platformspecific-extensions

Hmm, that might be a nice short term option. But removing the platform-specific installs seems like a better long-term option.