The simplest way to populate your database with test data.
Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr
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.
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 12:03 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: 1144
- Joined: Wed Jun 16, 2010 11:10 am
- Location: My desk.
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 11:06 am
Return to SQL Data Generator 2
Who is online
Users browsing this forum: No registered users and 1 guest