Product Home
DTM Data Generator Online Documentation Prev Page Prev Page
General
Product Profile
Product Versions
Quick Start
Rule Wizard
System requirements
Connect to Database
Quick Start
Direct Connection
Connect to Desktop File
Data Sources
DSN File
OLE DB Connection
Connection Profile
Connection Information
Troubleshooting Guide
Project Properties
Program Settings
General
Interface
Rule and project
Execution
Date and Time Formats
Execution
Random BLOB Loader
Project migration
Database Model Viewer
Fill Table Rule
Table Fill Modes
Table Fill Options
Tables options
Columns options
Row count tab
Scripts
Rule Output
Preview
Fill Methods
Method Options
Random values
Values list
From table
List from file
From Values Library
Incremental
By pattern
By SQL statement
By formula
Custom generator
Named Generators
Field groups
Advanced Rules
Clear Rule
Tables Creation Options
Objects Creation
File Rule
Advanced Features
Tables Selection
Bulk project modification
Table Information
Value Library
Change target Table
Command Line
Performance Tips
Performance mode
Format Strings
Select column
Data export
How to...
Additional Info
Product Ordering
Database Utilities
Licence agreement
Demo version
Install
Uninstall
Upgrade
Support
Trademark Information
Glossary

Step-by-step quick start: update 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 "Update" with related drop-down menu.
  4. Select table to be updated 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. Select table from the list
  5. If the source table has no Primary Key, you should specify unique key manually using "..." button near table name.
  6. Save the rule and run it using "Run All" button.

Optional steps. You can to:

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