Primary key violation populating an empty table

I have a three-column table (table1) with columns ID (int), key (varchar) and value (varchar). The primary key on the table is formed from columns ID and key.

The data generator is setup to populate this table using the rules:
ID = Reference Foreign Key FK_table1_table2 for column [dbo].[table2](ID), seed = 0, All key values unique
key = [sourcedb].[dbo].[table1].[key]
value = [sourcedb].[dbo].[table1].[value]

table2 has about 150 unique rows, table1 (in the source database) has about 3000. The target table is empty before the generator is run.

The problem is that this is violating the primary key when populating the target table. Is there a way to handle this type of population where both halves of a primary key are coming from different sources but must remain unique?


  • Alex BAlex B Posts: 905 Diamond 3
    Hi pebishop,

    Unfortunately SQL Data Generator does not handle composite Primary Keys - the issue has internal reference SDG-921 and I have added a reference to your issue there.

    Kind regards,
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.