Red Gate forums :: View topic - Complicated data generation question
Return to www.red-gate.com RSS Feed Available

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

Complicated data generation question

 Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dcolbert



Joined: 09 Feb 2007
Posts: 9
Location: Oak Brook, IL
PostPosted: Fri Mar 11, 2011 9:51 pm    Post subject: Complicated data generation question Reply with quote
Is it possible to generate four INT columns of data, where:

Code:
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
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids
PostPosted: Mon Mar 14, 2011 8:36 pm    Post subject: Reply with quote
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
Back to top
View user's profile Send private message Send e-mail
dcolbert



Joined: 09 Feb 2007
Posts: 9
Location: Oak Brook, IL
PostPosted: Fri Mar 18, 2011 2:40 pm    Post subject: Reply with quote
Thanks for the reply. Your suggestion will help, but I would definitely love it as a new feature!
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