The simplest way to populate your database with test data.
Moderators: David Atkinson, Anu Deshpande, Lionel
Is it possible to generate two (or more) sets of data into the same table?
For example, I have generated a table of "Persons" and a table of "Organisations". Now I want to generate a table of "Addresses" which sources data from both the "Persons" and the "Organisations" tables (so that there is one address record for every person and every organisation)
Is this possible?
I tried about setting a a view across both parent tables and sourcing from that but the generation does not seem to occur in the right order and the Addresses tables ends up blank.
- Posts: 3
- Joined: Wed Oct 01, 2008 2:34 pm
In the current version of Data Generator, you cannot generate the data in one column based upon SQL Data Generator-generated data in another column. It works only with existing data. This could be addressed in a future version.
- Posts: 6670
- Joined: Mon Aug 23, 2004 10:48 am
Return to SQL Data Generator 1
Who is online
Users browsing this forum: No registered users and 1 guest