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?
Tagged:

Comments

Sign In or Register to comment.