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
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 mask
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
Table Information
Value Library
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
Glossary

How to...

Q: How to fill two linked tables with data?
A: Create a project with two data rules: the first one will fill in the parent (master) table and the second one will fill in the child (detail) table. At the same time, the program will automatically offer the method of filling based on FK (foreign key) values.
A: Run rule wizard and to select "create data generation rules for the selected tables automatically" options. The program will create necessary rules automatically.

Q: Are there any restrictions concerning the number of fields in a table or a file?
A: Yes, the program supports approximately 420-440 fields per table. If you need more fields, let us know and we will make a custom build for you.

Q: How to make the number of digits in the generated number fixed?
A: The easiest variant is to specify a range. For example, if you want integers to have 3 digits each, specify the range from 100 to 999.

Q: How to fill fields with values depending on other values in this or some other table?
A: Fill the column with random values and then use an update statement, specifying it as a script executed after the rule. During the rule execution, the program will fill out the table, while the script will set the values of calculated or dependent columns.
A: Use "by expression" fill method. Please note that this solution is faster that previous but some database systems does not compatible with it.

Q: How to enter a date value into a field without specifying time?
A: Open the Settings page and specify the time format as an empty string.

Q: How to fill two columns (A and B) from one linked table coordinated?
A: Fill the first by SQL query like "select Column1,Column2 from LinkedTable". Next, create group consists of A and B columns.
A: Use "from table" fill method for both columns with required linked columns (Column1 and Column2 from example above) and switch ON "use vaues from list sequentally". In this solution data will be not really random but it is acceptable for most cases.