setting multiple columns at the same time

[fatherjack]

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

[Anu Deshpande]

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

[fatherjack]

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

[Anu Deshpande]

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