Red Gate forums :: View topic - Regarding SQL data generation
Return to RSS Feed Available

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

Regarding SQL data generation

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message

Joined: 02 Jan 2009
Posts: 4

PostPosted: Mon Jan 05, 2009 1:58 pm    Post subject: Regarding SQL data generation Reply with quote

I have 2 tables. like:


CCB_ID FixedRate DefaultRate

And another table(destination):


SC_ID CCB_ID DefaultRate

I need to fill this Scheduling table. So I made a relationship between the CCBudget and Scheduling on CCD_ID field. So this will get populated from the CCBudget.CCB_ID. So with respect to that Scheduling.CCB_ID i need to populate the DefaultRate from the CCBudget into Scheduling table.

Can anyone give me suggestion to solve this by using SQL DataGenerator.
Back to top
View user's profile Send private message MSN Messenger
Matthew Flatt

Joined: 15 Jan 2008
Posts: 253

PostPosted: Wed Jan 07, 2009 5:49 pm    Post subject: Reply with quote

Hi kiran,

If I am understanding correctly this should be possible with SQL Data Generator.

If you connect to your database and make sure only Scheduling is selected for generation. Select the Scheduling table and choose Use existing data source>SQL Table or View and hit Browse.

You should now select your database again and the CCBudget table.

You can then select a generator for SC_ID if it is not server assigned and choose the CCB_ID and DefaultRate fields from your table for generation.

I hope this helps.
Matthew Flatt
Test Engineer, HyperBac
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