Skip to content

Release v1.0.0

Choose a tag to compare

@github-actions github-actions released this 13 Mar 12:29
· 35 commits to master since this release

FastWrappers-TSQL v1.0.0

πŸ”’ Security Notice - Certificate-Based Installation (No TRUSTWORTHY Required!)

This release includes a signed assembly that eliminates the need for TRUSTWORTHY ON.

One-Time Server Setup (Required Before First Use)

  1. Download FastWrappers-Certificate.cer and Install-Certificate.sql
  2. Place the certificate file in an accessible location (e.g., C:\Certificates\)
  3. Edit Install-Certificate.sql and update the certificate file path
  4. Run Install-Certificate.sql as sysadmin on your SQL Server instance

This setup is done ONCE per SQL Server instance.

After Certificate Installation

You can then deploy FastWrappers-TSQL using any method below WITHOUT TRUSTWORTHY ON:


πŸ“¦ Installation Methods

  • FastWrappers-TSQL.dacpac - Data-tier Application Package (recommended for Visual Studio / SQL Server Data Tools)
  • FastWrappers-TSQL.bacpac - Binary Application Package (for import/export between servers)
  • FastWrappers-TSQL.bak - SQL Server Backup (compatible with SQL Server 2016+, restore using SSMS)
  • FastWrappers-TSQL.sql - Pure SQL Script (execute using sqlcmd or SSMS)

πŸ” Security Files

  • FastWrappers-Certificate.cer - Public certificate for SQL Server (required for installation)
  • Install-Certificate.sql - Installation script for certificate setup

βš™οΈ Server Configuration

Once the certificate is installed, you still need to enable CLR:

EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
EXEC sp_configure 'clr enabled', 1;
RECONFIGURE;

Usage

See README.md for usage examples.