Red Gate forums :: View topic - Generating rows with a composite PK
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

Generating rows with a composite PK

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



Joined: 18 Feb 2010
Posts: 16

PostPosted: Fri Jun 10, 2011 5:23 pm    Post subject: Generating rows with a composite PK Reply with quote

How do I use Data Generator to create rows which use a PK consisting of two foreign keys?

It doesn't seem that DG can consider both columns when testing the uniqueness requirement, but instead requires that at least one of the columns be unique or it will end prematurely due to duplicates.

A good example is the northwind database order details table. I can only get DG to insert 1000 order details to go with 1000 new orders, but that limits generated orders to one product each, which is not realistic.

Have I missed something?
Back to top
View user's profile Send private message
Linda Hawksworth



Joined: 25 Jun 2007
Posts: 192

PostPosted: Tue Jun 14, 2011 9:13 am    Post subject: Reply with quote

This is a known issue for which your workaround is the recommended solution (drop the constraint, generate the data and re-enable the constraint). It is logged in our tracking system with reference SDG-849. I will be informed if/when the status changes.
Back to top
View user's profile Send private message
gvsoft



Joined: 19 Jul 2012
Posts: 16

PostPosted: Mon Oct 01, 2012 10:58 pm    Post subject: Reply with quote

What is the status of this bug? I have DG 2.0.3.1 and it still has the same problem.
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