This article explains how to scramble databases using attached scripts and files
Introduction
Sometimes Adonis needs to receive a database or to use a customer’s cloud database for extensive error searching, or for testing a new functionality towards a specific customer’s setup. In these cases, the database will be scrambled before any further actions are taken.
A customer with local installation should always scramble the database before transferring it to Adonis possession.
Attachments
How-To
Create directory C:\Scramble (the path can be changed in line 161 of the scramble.sql file)
Copy files family.txt, name.txt into C:\Scramble
Start SQL Server Management Studio
Select the database that you want to scramble
Run the script from file scramble.sql
You might get some errors during this process but that is fine as there are tables that have been removed from the Database structure, but that are still here in the script.
What the script does
Update PW001P01 First and Last names
Update PW001P06 First and Last names
Set all fields "NOTES", "NOTE" in the database to "Not me, Chief!" the Seaman replied. "Once I get out of the Navy, I'm never going to stand in line again!"
Set all fields of database "COMMENTS", "COMMENT", "REMARK", "REMARKS" of database to "Remember pancake day"
Set all fields of database "CreatedBY", "ChangedBY" to "ADEMO"
Drop “Utvalg” tables
Rename Company and Vessels to "CompanyX", "VesselX" (commented out in the script)
Scramble telecommunications of PW001P0T
Scramble telecommunications of PW001PT6
Set the "DESCRIPTION" field of PW001OLEDOCS to "Enclosed document"
Scramble telecommunications of PW001P01
Scramble BIRTHDATE of PW001P01
Scramble PERSONALIDNO of PW001P01
Set the Enclosed document to NULL
Drop BACKUP tables
Delete data from "AUDIT" tables