...

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 173 of the scramble.sql file)

...

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

...

1. Scramble_Step1file

2. After finishing the process, run the second file

What the script does

...

1. Change PW001P01 First and Last names

...

1. 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", "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 database "COMMENTS", "COMMENT", "REMARK", "REMARKS" of database to "Remember pancake day"

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

6. Drop “Utvalg” tables

7. Rename Company and Vessels to "CompanyX", "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. Scramble telecommunications of PW001P01

12. Scramble

...

Scramble PERSONALIDNO of PW001P01

...

1. PERSONALIDNO, Bank account numbers, and SWIFT in Personal Details

2. Change all Enclosed documents to Adonis Logo

3. Drop BACKUP and Temp tables

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

5. Scramble ACC users and security levels