Random data generator
Generate random dummy data for test purposes.

Table or element name
Output type
Nr of output records
Amount of rows/elements to generate fixed amount fixed data rows
Data definition
Type or paste datadefinition.
Fixed data rows
Use data input for fixed rows.
Word lists
Use words lists to generate random data.

Instructions for datadefinition and masks:
Each datadefinition line should be separated by space or tabcharacter, example: FIELDNAME DATATYPE MASK
Allowed datatypes are: INT, VARCHAR, NUMERIC, DATETIME, DATE, TIME
Last parameter per line is range or mask. Use "min::max" for range, "code1,code2,code3" for random codes, listname for random phrases.
Varchar without mask or codelist will default to random snippets from the "lorem ipsum" text.
Use character mask to generate random zipcodes, phonenumbers, passwords etc. For example 999-999-9999 or ABABAB00 or #FFFFFF etc.
A: random vowel
B: random consonant
9: random digit
F: random hexdigit
S: random symbol
X: random letter
Y: random letter or digit
Z: random letter or digit or symbol
Lowercase a,b,1,x,y,z is same as above, except only "password safe" characters, so no l, 1, O, 0, S, 5 etc.

BdR©2018 Free to use - send questions or comments here