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.