Red Gate forums :: View topic - Order of data generation and dependency
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

Order of data generation and dependency

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
DAndres109@aol.com



Joined: 03 May 2008
Posts: 14
Location: New York

PostPosted: Sat May 03, 2008 2:23 am    Post subject: Order of data generation and dependency Reply with quote

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
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
benhall



Joined: 14 Dec 2007
Posts: 98

PostPosted: Tue May 06, 2008 2:41 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
DAndres109@aol.com



Joined: 03 May 2008
Posts: 14
Location: New York

PostPosted: Tue May 06, 2008 3:44 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
TSchwab



Joined: 11 Jan 2008
Posts: 62
Location: Germany

PostPosted: Thu May 08, 2008 8:52 am    Post subject: Reply with quote

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? Rolling Eyes

Thanks,
Thorsten
Back to top
View user's profile Send private message
benhall



Joined: 14 Dec 2007
Posts: 98

PostPosted: Thu May 08, 2008 9:45 am    Post subject: Reply with quote

Hello,

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

Thankyou

Ben
Back to top
View user's profile Send private message
TSchwab



Joined: 11 Jan 2008
Posts: 62
Location: Germany

PostPosted: Fri May 09, 2008 10:12 am    Post subject: Reply with quote

Thanks Ben,

we are really looking forward....
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group