Order of data generation and dependency

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Order of data generation and dependency

Postby DAndres109@aol.com » Sat May 03, 2008 2:23 am

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
DAndres109@aol.com
 
Posts: 14
Joined: Sat May 03, 2008 1:25 am
Location: New York

Postby benhall » Tue May 06, 2008 2:41 pm

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
benhall
 
Posts: 69
Joined: Fri Dec 14, 2007 11:15 am

Postby DAndres109@aol.com » Tue May 06, 2008 3:44 pm

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
DAndres109@aol.com
 
Posts: 14
Joined: Sat May 03, 2008 1:25 am
Location: New York

Postby TSchwab » Thu May 08, 2008 8:52 am

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
TSchwab
 
Posts: 62
Joined: Fri Jan 11, 2008 9:47 am
Location: Germany

Postby benhall » Thu May 08, 2008 9:45 am

Hello,

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

Thankyou

Ben
benhall
 
Posts: 69
Joined: Fri Dec 14, 2007 11:15 am

Postby TSchwab » Fri May 09, 2008 10:12 am

Thanks Ben,

we are really looking forward....
TSchwab
 
Posts: 62
Joined: Fri Jan 11, 2008 9:47 am
Location: Germany


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests