[James Carroll]

I’d like to suggest a feature of the DB explorer plugin(s) to add test data generation.

Use case:

User connects to DB.
User selects table
For each field in table user selects data or pattern to fill
+ for boolean/bit – true, false, random
+ for numeric – range, random, constant
+ for string – random, pattern (regexp), length
+ common fields like “State” (“IN”, “AK”, “OK”)
+ common patterns like SSN or Phone
User selects number of rows
Data generated

Concerns:
+ ensuring that DRI(PK/FK) constraints are maintained
+ multi to mutli relationships

Make no promises. This is pure TEST data. But atleast it could allow you to develop apps.

Very best wishes,

James

[Riyad Kalla]

Interesting idea, I’ll pass it along.

[Author]

Posts