Generator can't proceed

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Generator can't proceed

Postby paulh » Thu Jan 08, 2009 3:32 pm

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 :-)
paulh
 
Posts: 33
Joined: Sat Oct 08, 2005 5:28 pm

Postby Linda Hawksworth » Mon Jan 12, 2009 7:02 pm

Please can you send the table creation SQL for the table in question to support@red-gate.com so that I can do some testing to see if SQL Data generator can do what you need.
Linda Hawksworth
 
Posts: 192
Joined: Mon Jun 25, 2007 11:32 am


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests