Complicated data generation question

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Complicated data generation question

Postby dcolbert » Fri Mar 11, 2011 9:51 pm

Is it possible to generate four INT columns of data, where:

Code: Select all
Column2 + Column3 + Column4 <= Column1


We receive data from an outside source with those fields populated, but the final three added together should always equal the first. We'd like to generate data to test our logic that ensures those fields meet data quality requirements.

Thanks in advance!

Dan
dcolbert
 
Posts: 9
Joined: Fri Feb 09, 2007 3:59 pm
Location: Oak Brook, IL

Postby peter.peart » Mon Mar 14, 2011 8:36 pm

Hi there,

Thanks for your post.

Unfortunately, SQL Data Generator doesn't support this sort of parent > child relationhip between columns when generating data. It is something we have logged as a feature request but I am sorry to say I am not sure if we have a date on it being implemented. It will definitely be reviewed for the next release though.

In the meantime, ?I don't know if it's a vible solution for you however you could always select to generate data from an existing source for that table (those affected tables) only, pull in the real data for those particular columns only and then change the generator to one of the random generators for the rest of the columns.

HTH!

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Postby dcolbert » Fri Mar 18, 2011 2:40 pm

Thanks for the reply. Your suggestion will help, but I would definitely love it as a new feature!
dcolbert
 
Posts: 9
Joined: Fri Feb 09, 2007 3:59 pm
Location: Oak Brook, IL


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests