Release v1.0.1

FastWrappers-TSQL v1.0.1

Installation Files

• 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: Execute SQL Script (.sql file)

-- Simply execute the script in SSMS or using sqlcmd
sqlcmd -S YourServer -i FastWrappers-TSQL.sql

Usage

See README.md for examples.