Data fr. SQL Table with relation to a other Column

The simplest way to populate your database with test data.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr

Data fr. SQL Table with relation to a other Column

Postby ULRICHS » Wed Aug 22, 2012 12:37 pm

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
ULRICHS
 
Posts: 1
Joined: Wed Aug 22, 2012 12:03 pm

Postby james.billings » Wed Aug 29, 2012 4: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.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

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

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
jean-rator
 
Posts: 13
Joined: Thu Feb 02, 2012 11:06 am


Return to SQL Data Generator 2

Who is online

Users browsing this forum: No registered users and 1 guest