Product Home
DTM Data Generator Online Documentation
General
Product Profile
Product Versions
Quick Start
Rule Wizard
System requirements
Connect to Database
Execution
Fill Table
Table Fill Modes
Table Fill Options
Row count management
Fill Methods
Method options
Random values
Values list
From table
List from file
From Values Library
Incremental
By mask
By SQL statement
By formula
Field groups
Data Preview
Table Information
Advanced
Data Rule Properties
Project Properties
Tables Selection
Program Settings
File Structure
Values Library
Clear Rule
Project migration
Command Line
Performance Tips
Schema Viewer
Format Strings
Tables Creation Options
Select column
Objects Creation
Data export
How to...
Tools
Random BLOB Loader
Values Library Builder
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.