3 ms·
> they never explain why they needed to change PKs when migrating DBs Not a migration scenario, but thinking of other kinds of consolidations, like folding tog
by mikepurvis 6y ago
> they never explain why they needed to change PKs when migrating DBs
Not a migration scenario, but thinking of other kinds of consolidations, like folding together separate Employee tables after a company merger.
- ldng 6y agoWouldn't you have a lot more issues than just ids ? It very improbable that folding 1:1 would be even possible. You'll much more likely have to do a migration merging relevant information into a new table. So the question holds, when do you change a PK ?
- oxfordmale 6y agoDatabase migrations