Step-by-step quick start: scramble table
  1. Run the program and setup connection for your database.
  2. Press "Add Data Rule" button to create new rule.
  3. Change mode to "Scramble" with related drop-down menu.
    DTM Data Generator: Select scramble mode
  4. Select source table from drop-down list. If this list is empty you should check schema/owner name in the Connect Window. There is important that schema/owner name is case sensitive.
    DTM Data Generator: Select table to be scrambled from the list
  5. If the source table has no Primary Key, you should specify unique key manually using "Unique Key" button near table name.
  6. Enter name for a table where scrambled data be saved. Please note that target table should not exist except "Recreate table for scramble mode" option in the Settings Window is turned ON.
    DTM Data Generator: Select target (scrambled) table name
  7. Specify database where target table will be created with "Connection for Target" button near target table name. By default the program will save created or recreated table into the database specified at the project properties window. Please refer to "Default Target Database" option.
  8. Save the rule and run it using "Run All" button at the main window.

Optional steps. You can to:

  • change transaction size for scramble operation. Default value can be specified in the Settings Window.
  • enter WHERE clause. The program will scramble only rows corresponding with entered condition.
  • change fill method or method properties. By default the program will scramble all columns except identity and auto-incremental. You should change fill method to "Ignore" to save original values. The simplest way to do it is check required columns using check-boxes in the columns list and open local menu with right mouse button in the list:
    DTM Data Generator: Column list context menu
  • view sample data with preview tab.
  • create prologue and epilogue SQL scripts for the rule.
  • define short text note for created rule. The program shows is note in the rule list.
  • specify custom output files for text and SQL output.