SQLVer Optional Advanced Server Environment Overview - DavidRueter/SQLVer GitHub Wiki

SQLVer is primarily made up of SQL objects. The basic functionality (of version tracking) as well as most of the utility procedures and functions provided need only have the database objects installed.

However there are some optional advanced features that require some additional installation on the SQL Sever Windows machine. These features include:

  1. Building and deploying CLR assemblies directly from a stored procedure (that uses C# source code stored in the database) ...without needing a Visual Studio environment. This is needed especially for the VERY useful GetHTTP functionality.
  2. Hosting arbitrary CLR assemblies that can be called from inside SQL (via the GetHTTP functionality) even though the assemblies cannot run directly inside the SQLCLR environment
  3. Utilizing the SQL-based npmjs repository package manager (that is part of the Theas package)

There are more details to know about each of these steps, but here is a high-level outline of how to install the prerequisites for these optional advanced features:

  1. Create a folder C:\SQLVer on the SQLServer
  2. Install NuGet (if not already installed)
  3. Install the C# command line compiler (csc.exe) using NuGet (if not already installed) and create symbolic link
  4. Copy or install the Microsoft sn.exe utility
  5. Install 7-Zip
  6. Optionally install the SQLVerCLR.exe server that hosts CLR assemblies used by SQL
  7. Optionally Disable Windows Defender (not required and not specific to SQLVer, but avoids performance problems)