Skip to content

Releases: PierreAntoineAP/FastWrappers-TSQL-Dev

Release v0.7.0

16 Mar 08:10
@github-actions github-actions
v0.7.0
43d8c5b

Choose a tag to compare

View all tags
Release v0.7.0 Latest
Latest

FastWrappers-TSQL v0.7.0

Installation Files

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

Installation

Option 1: Restore from backup (.bak file)

-- Restore database
RESTORE DATABASE [FastWrappers-TSQL] FROM DISK = 'FastWrappers-TSQL.bak';
GO

-- Enable TRUSTWORTHY and CLR
ALTER DATABASE [FastWrappers-TSQL] SET TRUSTWORTHY ON;
GO

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

-- IMPORTANT: Change database owner to 'sa' 
-- Required for signed UNSAFE assemblies to load properly
USE [FastWrappers-TSQL];
GO
EXEC sp_changedbowner 'sa';
GO

-- Test
SELECT dbo.EncryptString('test');

Option 2: Deploy DACPAC
Use SqlPackage or Visual Studio to deploy the .dacpac file, then run:

USE [FastWrappers-TSQL];
GO
EXEC sp_changedbowner 'sa';
GO

Usage

See README.md for examples.

Assets 6
Loading

Release v0.6.0

16 Mar 07:45
@github-actions github-actions
v0.6.0
5c6cf9d

Choose a tag to compare

View all tags
Release v0.6.0

FastWrappers-TSQL v0.6.0

Installation Files

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

Installation

Option 1: Restore from backup (.bak file)

-- Restore database
RESTORE DATABASE [FastWrappers-TSQL] FROM DISK = 'FastWrappers-TSQL.bak';
GO

-- Enable TRUSTWORTHY and CLR
ALTER DATABASE [FastWrappers-TSQL] SET TRUSTWORTHY ON;
GO

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

-- IMPORTANT: Change database owner to 'sa' 
-- Required for signed UNSAFE assemblies to load properly
USE [FastWrappers-TSQL];
GO
EXEC sp_changedbowner 'sa';
GO

-- Test
SELECT dbo.EncryptString('test');

Option 2: Deploy DACPAC
Use SqlPackage or Visual Studio to deploy the .dacpac file, then run:

USE [FastWrappers-TSQL];
GO
EXEC sp_changedbowner 'sa';
GO

Usage

See README.md for examples.

Loading

Release v1.0.0

13 Mar 12:29
@github-actions github-actions
v1.0.0
79c2ed3

Choose a tag to compare

View all tags
Release v1.0.0

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.

Loading

Release v0.5.5

13 Mar 16:13
@github-actions github-actions
v0.5.5
aba6c9c

Choose a tag to compare

View all tags
Release v0.5.5

FastWrappers-TSQL v0.5.5

Installation Files

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

Installation

Option 1: Restore from backup (.bak file)

-- Restore database
RESTORE DATABASE [FastWrappers-TSQL] FROM DISK = 'FastWrappers-TSQL.bak';
GO

-- Enable TRUSTWORTHY and CLR
ALTER DATABASE [FastWrappers-TSQL] SET TRUSTWORTHY ON;
GO

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

-- IMPORTANT: Change database owner to 'sa' 
-- Required for signed UNSAFE assemblies to load properly
USE [FastWrappers-TSQL];
GO
EXEC sp_changedbowner 'sa';
GO

-- Test
SELECT dbo.EncryptString('test');

Option 2: Deploy DACPAC
Use SqlPackage or Visual Studio to deploy the .dacpac file, then run:

USE [FastWrappers-TSQL];
GO
EXEC sp_changedbowner 'sa';
GO

Usage

See README.md for examples.

Loading

Release v0.5.1

13 Mar 13:21
@github-actions github-actions
v0.5.1
2fe3c40

Choose a tag to compare

View all tags
Release v0.5.1

FastWrappers-TSQL v0.5.1

Installation Files

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

Installation

Option 1: Restore from backup (.bak file)

RESTORE DATABASE [FastWrappers-TSQL] FROM DISK = 'FastWrappers-TSQL.bak';
GO

-- Enable TRUSTWORTHY and CLR
ALTER DATABASE [FastWrappers-TSQL] SET TRUSTWORTHY ON;
GO

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

Option 2: Deploy DACPAC
Use SqlPackage or Visual Studio to deploy the .dacpac file.

Usage

See README.md for examples.

Loading

Release v0.4.3

13 Mar 12:56
@github-actions github-actions
v0.4.3
0fbe474

Choose a tag to compare

View all tags
Release v0.4.3

FastWrappers-TSQL v0.4.3

Installation Methods

This release provides multiple installation options:

  • 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)

Prerequisites

After deployment, you must enable CLR and set TRUSTWORTHY:

USE [FastWrappers-TSQL];
GO

ALTER DATABASE [FastWrappers-TSQL] SET TRUSTWORTHY ON;
GO

EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
GO

EXEC sp_configure 'clr enabled', 1;
RECONFIGURE;
GO

Usage

See README.md for usage examples.

Loading

Release v0.4.2

13 Mar 12:48
@github-actions github-actions
v0.4.2
8785df3

Choose a tag to compare

View all tags
Release v0.4.2

FastWrappers-TSQL v0.4.2

Installation Methods

This release provides multiple installation options:

  • 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)

Prerequisites

After deployment, you must enable CLR and set TRUSTWORTHY:

USE [FastWrappers-TSQL];
GO

ALTER DATABASE [FastWrappers-TSQL] SET TRUSTWORTHY ON;
GO

EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
GO

EXEC sp_configure 'clr enabled', 1;
RECONFIGURE;
GO

Usage

See README.md for usage examples.

Loading

Release v0.4.0

13 Mar 12:41
@github-actions github-actions
v0.4.0
af98fc1

Choose a tag to compare

View all tags
Release v0.4.0

FastWrappers-TSQL v0.4.0

Installation Methods

This release provides multiple installation options:

  • 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)

Prerequisites

After deployment, you must enable CLR and set TRUSTWORTHY:

USE [FastWrappers-TSQL];
GO

ALTER DATABASE [FastWrappers-TSQL] SET TRUSTWORTHY ON;
GO

EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
GO

EXEC sp_configure 'clr enabled', 1;
RECONFIGURE;
GO

Usage

See README.md for usage examples.

Loading

Release v0.3.9

13 Mar 12:17
@github-actions github-actions
v0.3.9
2c03c55

Choose a tag to compare

View all tags
Release v0.3.9

FastWrappers-TSQL v0.3.9

Installation Methods

This release provides multiple installation options:

  • 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)

Usage

See README.md for usage examples.

Loading

Release v0.3.8

13 Mar 12:05
@github-actions github-actions
v0.3.8
0277a00

Choose a tag to compare

View all tags
Release v0.3.8

FastWrappers-TSQL v0.3.8

Installation Methods

This release provides multiple installation options:

  • 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)

Usage

See README.md for usage examples.

Loading