Red Gate forums :: View topic - Feature Request: Automatically populate "Weighted List"
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

Feature Request: Automatically populate "Weighted List"

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
DAndres109@aol.com



Joined: 03 May 2008
Posts: 14
Location: New York

PostPosted: Sat May 03, 2008 1:54 pm    Post subject: Feature Request: Automatically populate "Weighted List" Reply with quote

Hi,

In some cases, a Check constraint may exists that limits a field to only a handful of values.

Is there any way for the Data Generator to automatically pick up and list these values during these circumstances?

Thanks,

David Andres
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
benhall



Joined: 14 Dec 2007
Posts: 98

PostPosted: Tue May 06, 2008 2:18 pm    Post subject: Reply with quote

Hello,

Thanks for your feedback. You should find that we parse a check constraint and convert it into a regular expression assigned to the column.

Currently, there is no way to assign these values automatically to a weighted list, however I have added a requested into our system to consider for a future release. Out of interest, what would you assign the default 'weight' out these values to be?

Thanks

Ben
Back to top
View user's profile Send private message
DAndres109@aol.com



Joined: 03 May 2008
Posts: 14
Location: New York

PostPosted: Tue May 06, 2008 3:57 pm    Post subject: Reply with quote

Ben,

I agree that there's no "correct" solution to assigning weights. The only thing that comes to mind is if there are 100 or fewer constraints, then at least you can do an average, where the first option is modified to sum up to 100 percent.

What do you think?

David
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
benhall



Joined: 14 Dec 2007
Posts: 98

PostPosted: Tue May 06, 2008 4:54 pm    Post subject: Reply with quote

David,

That was my initial thought as well, thanks for the reply.

Ben
Back to top
View user's profile Send private message
jnahmias



Joined: 30 Apr 2008
Posts: 11
Location: NYC

PostPosted: Tue May 06, 2008 5:47 pm    Post subject: Reply with quote

Not to hijack this request, but it would also be nice to automatically populate a weighted list generator from a foreign key.
Back to top
View user's profile Send private message
tkdennis



Joined: 29 Feb 2008
Posts: 75

PostPosted: Fri May 16, 2008 3:10 am    Post subject: Reply with quote

I would really like to see a weighted list populated from a foreign key also.
Back to top
View user's profile Send private message
benhall



Joined: 14 Dec 2007
Posts: 98

PostPosted: Fri May 16, 2008 4:36 pm    Post subject: Reply with quote

Thanks for the additional comments, I have made a note of all of them for reviewing for a later release.

Thanks

Ben
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