This project is read-only.

Creating a new Project

First click the New button in the General group or in the main menu to bring up the new project form. 

 

Next supply the server name and database name. If you not using Windows Authentication please change the Authentication drop down and select SQL Auth and supply a username and password. 

 

Once you click connect Dafuscator will read the database schema and pull out the tables and columns to obfuscate. 

 

 

Obfuscating a Database

To obfuscate data in your database you need to first go through all the tables and select the proper generator for the data your trying to obfuscate. For example some data you may want to obfuscate are Names, Addresses, SSN's, phone numbers, email addresses, URL's, etc. When you select a generator it will either have options you need to specify, or not. 

 

Under the Run menu there are two options for starting the Obfuscation process, All or Table. When you select the All option all tables will being obfuscating, when you select Table only the currently selected table will obfuscate. 

 

 

Exporting SQL

You can export the underlying SQL script Dafuscator uses to obfuscate the database. This is useful when trying to discover issues with obfuscation, or testing obfuscation against your database with a limited set of data. Under the Export menu you will see four options All, Table, All (Test) and Table (Test). Like the options for running obfuscation under the Run menu here All will export a SQL script for all tables in your project that have obfuscation options and Table will do the currently selected table. 

The two options with (Test) will do the exact same thing as All/Table but will limit the records to 1000 so you get a good sample size to test obfuscation against your database. 

 

 

Reporting

Generating a report is a valuable way to determine all the columns being obfuscated in your project and what generator is being used. To generate a report from your project click the report button in the Project section of the main menu bar. 

 

You will then need to specify a location for where you want this report to be saved. You will get a report that looks something like the one below. 

 

 

 

 

Your database will most likely be in a state of flux and constant change. Or you will need to point Dafuscator at another database then the one you used to originally generated the project from. These are both very common scenarios and easily handled in Dafuscator. 

 

Updating your database

Update Dafuscator to reflect database changes

When you have your Dafuscator database project open press the Refresh button in the Project section of the main menu bar. Dafuscator will go out to the currently configured database and check for new tables, remove tables that don't exist anymore and verify the column information. 

 

Point Dafuscator at a different database

If you need to point a Dafuscator project at another database, for example a demo database, you can open up the Update menu in the Project section of the main menu bar and select the Connection String option. This will open up the New Database dialog where you will need to supply the connection information. 

 

 

Last edited Nov 22, 2011 at 2:01 AM by wavetech, version 4

Comments

No comments yet.