Installation To start with, you will need to download the latest version of the application from here. Download the binary .zip release and then extract it on your computer. Inside the folder you extracted it to you will find the RockSweeper.exe application. Run this. If you have used this application before, you can skip to the next section. Otherwise we'll explain a few things about the program. This program is designed to help you scrub your database of any personal, identifying or sensitive information. For example, changing people's names, addresses, e-mail addresses, etc. All these tasks are broken up into individual actions that can be performed, as seen in the list of checkbox items. Each action performs a fairly specific action. For example, the "History" action cleans up the history table and nothing else. A few actions, such as "Names" branches out into other areas. This action gives all the people in your database random names and then also looks at various related tables and updates those as well. For example, it will look at Prayer Requests and either update the first and last names to match the person record if there is one. If not it will generate a random name. To run the scrubbing process, you click the pencil and enter the information required to connect to your database (the one to be scrubbed, not your production database). Then you turn on/off any actions you want and click the run button. ImportantThis tool should not be treated as a magic eraser. Nothing magic is going on here. This is simply a collection of actions that were created based on looking at real data and deciding what needs to be cleaned up. Never send your database to someone you do not explicitly trust even if it has been scrubbed with this tool. Usage The first step is to click on the pencil and enter the connection string to your database. Next, copy the JSON below and save it to a file called standard-settings.json. It contains the recommended actions to be performed. { "Actions": [ "8b6a47eb-006a-4734-a876-94f20b43b994", "705c42d1-5600-418c-b0bd-7c3a3ac9c982", "9083a514-b9bc-418c-b48f-86355399c37a", "944fea3a-7826-4e9b-9539-eae3f26fa2ac", "1e7dac9c-3002-4896-9dd3-fa2e4964e241", "f489a377-d4a5-4737-9657-53a7b3b7374f", "6ecb7b00-e1ed-44e9-b24e-e4beffbac9f3", "d23bfc10-7c58-4f9c-8497-553a6a5c7c1c", "7d14924a-b367-4495-b480-96b86bcf712b", "89b28ddd-a138-4b59-91e4-ebf8019c1cad", "73a6169f-6552-4dfd-b759-774573280cad", "f6a44b98-2eb0-4e0e-a821-ee5997b9a56d", "02c2d628-ac02-4a36-9f0a-1f4b34c72036", "5cdcf31e-382f-4663-ad26-122814990187", "31200ef0-cad7-4775-8be8-c1a06a591e3f", "dad894c1-933b-4072-84e3-f6ae3320aa74", "8b164228-50a7-4abe-8769-096ea5157a88", "304cf8ff-a70d-4de1-95d0-e4262cf1bfeb", "811a270f-f655-4332-8737-367acf88b496", "d000b0a2-c318-4d72-93df-ed60dd3a015c", "756343a6-3473-4c3b-8ad9-f16ff604ae07", "664802e9-acc4-4257-9585-4a463b706b6b", "7a047807-1a42-413e-899a-b2a1fc90a889", "4f7df3ed-3797-49a5-995c-acd1463458c4", "50b87e79-f539-4fa5-b848-1b7a9fd00cc9", "c81ff0e1-f605-402a-9881-251dbf84c853", "46f34fe1-4577-425d-9cdf-cf54da349365", "f6a44b98-2eb0-4e0e-a821-ee5997b9a56d", "f81ab6fa-a219-40d1-9455-ea66c0d7aef4", "a46a95e5-d2c4-46fc-bffc-225ccc1a3987", "d6a36aad-f7ba-4ada-b018-f6aa4065f6bf", "24ea3e6e-04ab-4896-9174-bc275f67f766", "48f41eef-d394-49b8-a214-27c9f2a2abd0", "8c1155d0-6319-4750-a7ca-0d713740bfde", "d5e352c6-b1bf-405a-9934-6f875725a5c1", "dcb7cde1-7764-4ce4-bbb8-13001c4cc9dd", "ff2e4638-87ba-40eb-bda9-039d8277be8b", "da03b960-1bec-4c55-b966-537970cd6dcd", "e357c385-00bb-499b-b19e-f9438dba5f86", "a68b25fb-6ec2-4d3d-b1de-16aae76c47d6", "4d9f9857-429b-4e1b-8833-8e702bbc7952", "c1770744-9498-4b35-a172-f64ad00f74c0", "4e60e8cf-38aa-4cbd-9fd2-013ae2aab95a", "405bb345-d1a4-4bc3-861c-9fab90c0c2da", "57da3ba1-4166-446a-a998-be7229a32b52", "5e27c631-3681-4d1b-b50c-0e5f3898e541", "afee211e-2a2d-4d85-a428-81ac95637ed6", "59fd05b1-0263-4442-9d63-7491e254bcd1", "6be04438-0725-4ec6-b5be-adc2a03ab028" ] } Click the "Load Settings" button and then select the file, you should see the various selected actions get checked. Next, click the Run button. A new window will come up that shows you the progress of each action and the entire process. NoteWhile the operation is running, the sleep mode on your computer is disabled. Manually putting the computer to sleep will still work, but the idle timeout will not. If everything worked correctly, you can close the application and move on to the task of transporting the database.