HomeDTM Data Generator Online HelpRealistic data for database testing purposes
Table of Content
  • General Information
    • Product Profile
    • Product Versions
    • Quick Start
    • Rule Wizard
    • System Requirements
    • Execution
  • Project Properties
    • General properties
    • Scripts
    • Output
  • Database Connection
    • Quick Start
    • Direct Connection
    • Connect to Desktop File
    • Data Sources
    • DSN File
    • OLE DB Connection
    • Connection Profile
    • Connection Information
    • Troubleshooting Guide
  • Program Settings
    • General
    • Interface
    • Rule and Project
    • Execution
    • Date and Time
  • Table Rule
    • Table Fill Modes
    • Table Fill Options
      • General
      • Columns
      • Row count
      • Scripts
      • Output
      • Preview
    • Fill Methods
      • Random Values
      • Value List
      • Table
      • Text File
      • Value Library
      • Incremental
      • Pattern
      • SQL Statement
      • Regular Expression
      • Excel sheet
      • JSON File
      • XML File
      • By Script
    • Named Generators
    • Field Groups
  • Advanced Rules
    • Clear Rule
    • Tables Creation Options
    • Objects Creation
  • Built-in Tools
    • Project Migration
    • Data Masking Tool
    • Random BLOB Loader
    • Database Model Viewer
    • Library Manager
    • SQL Console
  • Advanced Rules
    • Project Report
    • Custom Generators
    • Tables Selection
    • Bulk Project Modification
    • Table Information
    • Value Library
    • Variables
    • Execution Report
    • Change Target Table
    • Command Line
    • Performance Tips
    • Performance Mode
    • Format Strings
    • Select Column
    • Data Export
    • SQL Library
    • Version Control Support
    • Hot keys
    • How to...
  • Additional Information
    • Runtime editions
    • Context menu
    • Product Ordering
    • Database Utilities
    • License Agreement
    • Syntax Mapping
    • Demo Version
    • Install
    • Uninstall
    • Upgrade
    • Support
    • Log File
    • Trademark Information
    • Glossary
Step-by-step quick start: operation selection

I want to:

  • Append test data to my table
  • Replace table's content by test data
  • Update data in my table by test values
  • Scramble my table data
  • Populate my database by test values

Fill methods (also known as predefined data generators):

  1. Random values
  2. From the list
  3. From database table.
  4. From the file (CSV/TSV,etc)
  5. .
  6. With incremental values
  7. Value Library
  8. Values according to the data generation pattern
  9. By SQL statement execution
  10. By regular expression
  11. Group item
  • 2004-2021. DTM soft. All rights reserved.

  • Privacy policy and Terms of Service