Red Gate forums :: View topic - Data fr. SQL Table with relation to a other Column
Return to www.red-gate.com RSS Feed Available

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

Data fr. SQL Table with relation to a other Column

Search in SQL Data Generator 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ULRICHS



Joined: 22 Aug 2012
Posts: 1

PostPosted: Wed Aug 22, 2012 12:37 pm    Post subject: Data fr. SQL Table with relation to a other Column Reply with quote

Hi I'm new to Data generator, so if this is a silly easy qurestion - sorry for that, but I can't find an answer on my own.

I have to generate data in an SQL Table that has to be very realistic.
The data are individual related. Eg. Name, Firstname, gender, street, birthdate, etc.

An example:
I have some thousand female and male firstnames in a (source) table.
1st Column: Firstname (~5000 unique in the table)
2nd Column: Gender (m / w) w == female in german.

I have to generate realistic test data, so eg. "Susanne" should'nt be "male" in the data.

Generating the firstnames is no problem.

How can I add the correct gender in the second column ??
I don't know how to refer to the same row using the second column in the source table.

Can anyone help ?

Ulrich
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1120
Location: My desk.

PostPosted: Wed Aug 29, 2012 4:42 pm    Post subject: Reply with quote

Unfortunately, you can't really do this. SQL Data Generator cannot generate information in one column based on the value in another.

It's a pretty common request, but there's no immediate likelihood of this change being made I'm afraid.
Back to top
View user's profile Send private message
jean-rator



Joined: 02 Feb 2012
Posts: 13

PostPosted: Tue Oct 02, 2012 7:56 am    Post subject: Reply with quote

Hi,


If you need to generate data with columns value related to other one (eg : Suzan with a 'female' data column), you could use csv Import.

In that case, the column values are picked from an unique row.

hope it helps...
regards.

JL.
_________________
using SQL data Generator 2.0
----
dedicated CRM Software build with dotNet WPF / SQLServer 2008R2
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