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
EXEC MLtools.Obfuscator.SetFullNameParts @DatabaseName = 'Adventureworks', @TableSchema = 'Person', @TableName = 'Person', @FirstNameColumn = 'FirstName', @LastNameColumn = 'LastName', @MiddleNameColumn = 'MiddleName', @DisableTriggers = 1;
Before | After |
---|---|