Red Gate forums :: View topic - Can I generate two sets of data into the same table?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

Can I generate two sets of data into the same table?

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
screek



Joined: 01 Oct 2008
Posts: 3

PostPosted: Mon Oct 06, 2008 11:19 am    Post subject: Can I generate two sets of data into the same table? Reply with quote

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.

Thanks
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6641

PostPosted: Tue Dec 30, 2008 1:02 pm    Post subject: Reply with quote

Hi Stephen,

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group