What are the challenges you face when working across database platforms? Take the survey
Options

setting multiple columns at the same time

fatherjack2fatherjack2 Posts: 311
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

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    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
  • Options
    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
  • Options
    Anu DAnu D Posts: 876 Silver 3
    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
Sign In or Register to comment.