Activity overview
Latest activity by stephenm
I had to write a UPDATE statement to SET the child table's new FK prior to creating the FK constraints. I've seen Red-Gate issue warnings on tables without 2 primary keys, but maybe this is a corner case.
Also I did in fact have the newid() set for all the default values, but newid() doesn't seem to work the same in this case. / comments
I had to write a UPDATE statement to SET the child table's new FK prior to creating the FK constraints. I've seen Red-Gate issue warnings on tables without 2 primary keys, but maybe this is a corn...
Changing PK to compound primary key -> sync fails.
Well I'm sure I'm doing something wrong... yet it eludes me! I created a 2 table test database that targets my issue in my production upgrade (to simplify things). I'll post the definitions below...