Order of data generation and dependency

DAndres109@aol.comDAndres109@aol.com Posts: 22 Bronze 2
edited May 9, 2008 5:12AM in SQL Data Generator Previous Versions
Hi,

Is it possible to configure the table order that the data generation operation should use? There are some tables I would prefer to have populated before others.

Thanks,

David Andres
· Share on Twitter

Comments

  • benhallbenhall Posts: 70
    Hi David,

    At the moment, we control the order the data is generated in based on dependencies within the database.

    For example, if there is a FK relationship, then we will generate that in the correct order. Similarly, if you use the SQL Statement generator or Manual FK Generator, this will be taken into account.

    Out of interest, what is the scenario for altering the order of generation?

    Thanks

    Ben
    · Share on Twitter
  • DAndres109@aol.comDAndres109@aol.com Posts: 22 Bronze 2
    Ben,

    You've answered my basic concern, that rows are added in a smart way.

    I can't think of a specific need to alter the order of generation if it already takes into account dependency.

    Thanks,

    David
    · Share on Twitter
  • TSchwabTSchwab Posts: 80
    Hi,

    we do not have any dependency in the database due to the complexity of our solution.

    In order to use the SQL Generator we would need a way to order the generation of the data...

    Is there any chance that it will be available in a future version? :roll:

    Thanks,
    Thorsten
    Regards,

    Thorsten
    · Share on Twitter
  • benhallbenhall Posts: 70
    Hello,

    Thanks for your post, I have added a note into our system to review for the next release.

    Thankyou

    Ben
    · Share on Twitter
  • TSchwabTSchwab Posts: 80
    Thanks Ben,

    we are really looking forward....
    Regards,

    Thorsten
    · Share on Twitter
Sign In or Register to comment.