Scrambling of Databases

Owned by Sigrid Kviteberg
Last updated: Apr 13, 2023 by Artem Finkelshtein
2 min read

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

  1. The fresh scramble script is stored under http://download.adonis.no/files/upgrade/Scramble/

  2. Upload script files

  3. Start SQL Server Management Studio

  4. Select the database that you want to scramble

  5. Run the first script from Scramble_Step1file

  6. After finishing the process, run the second file

What the script does

  1. Change PW001P01 First and Last names with random ones; wipe out the middle name and maiden name; randomize birthdays

  2. Change PW001P06 First and Last names with random ones; wipe out the middle name and maiden name; randomize birthdays

  3. Set all fields "NOTES" and "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!"

  4. Set all fields of the database "COMMENTS", "COMMENT", "REMARK", "REMARKS" of database to "Remember pancake day"

  5. Set all fields of the database "CreatedBY" and "ChangedBY" to "ADEMO"

  6. Drop “Utvalg” tables

  7. Rename Company and Vessels to "CompanyX" and "VesselX" (commented out in the script)

  8. Scramble telecommunications of PW001P0T

  9. Scramble telecommunications of PW001PT6

  10. Set the "DESCRIPTION" field of PW001OLEDOCS to "Enclosed document"

  11. Replace the enclosed documents with the Adonis logo

  12. Replace company and vessel logos with the Adonis logo

  13. Scramble telecommunications of PW001P01

  14. Scramble PERSONALIDNO, Bank account numbers, and SWIFT in Personal Details

  15. Change all Enclosed documents to Adonis Logo

  16. Drop BACKUP and Temp tables

  17. Delete irrelevant and sensitive data from "AUDIT" tables

  18. Scramble ACC users and security levels