Options
Generating rows with a composite PK
whenriksen
Posts: 25
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?
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?
Comments