Red Gate forums :: View topic - setting multiple columns at the same time
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

setting multiple columns at the same time

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



Joined: 13 Mar 2007
Posts: 224
Location: Cornwall

PostPosted: Mon Aug 02, 2010 10:25 am    Post subject: setting multiple columns at the same time Reply with quote

This may be tricky to implement but I have a table with 30 columns that are all INT and should have values between 1 and 10 to store survey responses. Is it possible to select all these columns in the SQL Data Generator UI and set them all to be RegEx [0-1][0-9] in one step?
_________________
-----------------------------------------
Senior DBA
Careers South West Ltd
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 661
Location: Cambridge

PostPosted: Tue Aug 03, 2010 4:52 pm    Post subject: Reply with quote

Many thanks for your post.

Yes you can do that but it will do it in batches of 10.

To do that you need to follow below mentioned settings:

You have to select them one at a time and set there Min value as 0 and Max value as 9 and than set the distribution as 'Random'

Kindly let me know if this answers your question.

Mean while I will try to find best way to do it.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
fatherjack



Joined: 13 Mar 2007
Posts: 224
Location: Cornwall

PostPosted: Thu Aug 12, 2010 11:56 am    Post subject: Reply with quote

Anu, I can get the values in to the columns fine, its just I have to do it 30 times. The feature I am asking for is to be able to select more than one column and apply the same data generation rules to them all.
_________________
-----------------------------------------
Senior DBA
Careers South West Ltd
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 661
Location: Cambridge

PostPosted: Fri Aug 13, 2010 1:44 pm    Post subject: Reply with quote

Many thanks for your e-mail.

We appreciate your feedback and hence logged this as a feature request in our internal tracking system whose tracking id is SDG-908.

It will be reviewed by product manager and than marked for the next release.

I will update you as soon as it is incorporated.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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