setting multiple columns at the same time

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

setting multiple columns at the same time

Postby fatherjack » Mon Aug 02, 2010 10:25 am

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
fatherjack
 
Posts: 224
Joined: Tue Mar 13, 2007 12:33 pm
Location: Cornwall

Postby Anu Deshpande » Tue Aug 03, 2010 4:52 pm

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby fatherjack » Thu Aug 12, 2010 11:56 am

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
fatherjack
 
Posts: 224
Joined: Tue Mar 13, 2007 12:33 pm
Location: Cornwall

Postby Anu Deshpande » Fri Aug 13, 2010 1:44 pm

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests