Data fr. SQL Table with relation to a other Column

The simplest way to populate your database with test data.

Data fr. SQL Table with relation to a other Column

Postby ULRICHS » Wed Aug 22, 2012 11:37 am

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 ?

Posts: 1
Joined: Wed Aug 22, 2012 11:03 am

Postby james.billings » Wed Aug 29, 2012 3:42 pm

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.
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Postby jean-rator » Tue Oct 02, 2012 6:56 am


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...

using SQL data Generator 2.0
dedicated CRM Software build with dotNet WPF / SQLServer 2008R2
Posts: 13
Joined: Thu Feb 02, 2012 10:06 am

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests