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
The fresh scramble script is stored under http://download.adonis.no/files/upgrade/Scramble/
Upload script files
Start SQL Server Management Studio
Select the database that you want to scramble
Run the first script from Scramble_Step1file
After finishing the process, run the second file
What the script does
Change PW001P01 First and Last names with random ones; wipe out the middle name, and maiden name; randomize birthdays
Change PW001P06 First and Last names with random ones; wipe out the middle name, and maiden name; randomize birthdays
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 PERSONALIDNO, Bank account numbers, and SWIFT in Personal Details
Change all Enclosed documents to Adonis Logo
Drop BACKUP and Temp tables
Delete irrelevant and sensitive data from "AUDIT" tables
Scramble ACC users and security levels