begintry / sql-server-data-obfuscation

Stored procedures for overwriting existing data with randomly generated data.

SQL Server Data Obfuscation

This series of stored procedures uses SQL Server's built-in Machine Learning services and the R language for both generating data sets of fake data, and for obfuscating existing SQL Server data with fake data.

Additional details and examples are available in this blog post: Data Obfuscation for SQL Server

Example - Full Names

EXEC MLtools.Obfuscator.SetFullNameParts
	@DatabaseName = 'Adventureworks',
	@TableSchema = 'Person',
	@TableName = 'Person',
	@FirstNameColumn = 'FirstName',
	@LastNameColumn = 'LastName',
	@MiddleNameColumn = 'MiddleName',
	@DisableTriggers = 1;

Before	After