Comments
Sort by recent activity
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...