I have just sent Tim A a version of our database so that he can play with a system with a large amount of data. Before doing so I scrambled the data to hide the customer and product information using the SQL code given below. Note that the last 3 sql statements are designed to remove the 27000 attachments to hide information and save space. The others do the following:

all phone and fax numbers randomised; all addresses randomised (though the suburb and state have not been altered; all email addresses randomised; all last and company names randomised but keeping the first 3 letters, all first name randomised but keeping the first letter, all Hong Kong ID numbers (held in the travel slot) randomised; all product names and printed names randomised but keeping the first 3 letters; all microchip numbers randomised; users names and passwords randomised (but admin left as admin, and password set to ‘admin’)

I manually scrambled the email and sms gateway user names and passwords and the bank account names and numbers.

If you ever have need to anonymise things, the sql below will save you some time.

Regards, Tim G

PS - having just repeated the exercise, I realised that I omitted one final step.  If you do the above, then all the customer data is anonymised, however the derived description field still contains the original information. Hence you need to get this rebuilt. The easiest way is to use Administration|Archetypes to edit the party.customerPerson archetype.  Change the derived value for the description node from "concat(party:getBillingAddress(.),' - ',party:getHomeTelephone(.))" to say "concat(party:getBillingAddress(.),'  ',party:getHomeTelephone(.))" and then press Apply. When you get the 'Update Changed Nodes' window, press Cancel.  Then change the derived value back again, and this time, press the OK button on to get the changed nodes updated.  This will rebuild the descriptions from the anonymised data.

 UPDATE contact_details
    SET value=concat((floor(rand()*9000)+1000),' ',(floor(rand()*9000)+1000))
    where name='faxNumber';
UPDATE contact_details
    SET value=concat((floor(rand()*9000)+1000),' ',(floor(rand()*9000)+1000))
    where name='telephoneNumber';
UPDATE contact_details
    SET value=concat((floor(rand()*9000)+1000),' ',CONV(10+FLOOR(RAND()*26),10,36),' Street')
    where name='address';
UPDATE contact_details
    SET value=concat(lower(CONV(10+FLOOR(RAND()*26),10,36)),(floor(rand()*9000)+1000),'@gmail.com')
    where name='emailAddress';

UPDATE entity_details
    SET value=concat(left(value,3),(floor(rand()*9000)+1000))
    where name='lastName';

UPDATE entity_details
    SET value=concat(left(value,1),(floor(rand()*9000)+1000))
    where name='firstName';

UPDATE entity_details
    SET value=concat(left(value,3),(floor(rand()*9000)+1000))
    where name='companyName';

UPDATE entity_details
    SET value=concat(upper(CONV(10+FLOOR(RAND()*26),10,36)),(floor(rand()*9000)+1000))
    where name='travel';

UPDATE entity_details
    SET value=concat(left(value,3),(floor(rand()*9000)+1000))
    where name='printedName';

UPDATE entities
    SET name=concat(left(name,3),(floor(rand()*9000)+1000))
    where arch_short_name like 'product.%';

UPDATE entity_identities
    SET identity=concat((floor(rand()*900)+100),'*',(floor(rand()*900)+100),'*',(floor(rand()*900)+100))
    ,name = identity
    where arch_short_name = 'entityIdentity.microchip';

UPDATE entities
    SET name=concat(left(name,3),(floor(rand()*9000)+1000))
    where arch_short_name='security.user' and length(name)>3 and name <>'admin';

UPDATE entities
    SET description=concat('Dr ',left(name,3),(floor(rand()*9000)+1000))
    where arch_short_name='security.user' and length(name)<=3;

UPDATE users
    SET password=concat('p',(floor(rand()*9000)+1000))
    where user_name <> 'admin';

UPDATE documents
    SET contents=0, checksum=0, doc_size=0
    where (mime_type <> 'application/vnd.oasis.opendocument.text' and mime_type<> 'text/xml');

UPDATE acts a
    join document_acts da on (da.document_act_id = a.act_id)
    join documents d on (d.document_id = da.document_id)
    SET d.contents=0, d.checksum=0, d.doc_size=0
where (a.arch_short_name = 'act.patientDocumentLetter'
  or a.arch_short_name = 'act.patientDocumentForm');

OPTIMIZE table documents;