Options
Primary key has moved on
joshdanhall
Posts: 2
Hi,
I'm using Data Compare to create scripts to populate reference data into multiple environments. With the scripts generated I now run into problems because the primary key from one INSERT may no longer be appropriate for the target environment. For example that environment may already have generated a row with that id value, so my script will fail.
Does the Data Compare tool offer a solution for this, or will I have to hand-edit the scripts to handle the dynamic nature of my requirements?
Note: The primary key value is also used in subsequent INSERTs, as it is a foreign key for other table.
Thanks in advance.
Regards, Josh
I'm using Data Compare to create scripts to populate reference data into multiple environments. With the scripts generated I now run into problems because the primary key from one INSERT may no longer be appropriate for the target environment. For example that environment may already have generated a row with that id value, so my script will fail.
Does the Data Compare tool offer a solution for this, or will I have to hand-edit the scripts to handle the dynamic nature of my requirements?
Note: The primary key value is also used in subsequent INSERTs, as it is a foreign key for other table.
Thanks in advance.
Regards, Josh
Comments
Red Gate Technical Support Engineer