Question

I want to do a test instance of FogBugz, but don't want it to interfere with my current production instance. How do I do that?

Answer 1

Here is a sanitizer script that makes sure you won't conflict with their email boxes or send emails, and it will set the correct auth type so you can get into your test instance without a password.

DELETE FROM MailQueue; 

DELETE FROM Licenses;

UPDATE Person SET fNotify = 0, fEscalationReport = 0; 

UPDATE Mailbox SET fDELETED = 1; 

DELETE FROM Subscriptions; 

UPDATE Setting SET sValue = 'NONE' WHERE sKey= 'sSMTPServer';

UPDATE Setting SET sValue = '0' WHERE sKey= 'fPasswordEnable';

UPDATE Setting SET sValue = '0' WHERE sKey= 'iAuthType';