Competition: What’s your favorite Redgate tool? Enter now.

Generator can't proceed

paulhpaulh Posts: 35 Bronze 2
I have three table A, B and C with FKs A->B, A->C and B->C

Table C has a multi-column constraint across A, B and another column U.

When I try to generate 50K rows into C it stops saying that I've violated the constraint event though I have discard invalid row.

Any way of making the genenerated data unique across all the values or handling the exception?

If I change the FK generation from random to number of items I can get up to 300 rows but that's not too useful :-)

Comments

Sign In or Register to comment.