We're embarking on the task of moving to primary keys which use a UUID rather than a db identity sequence to be able to introduce syncing and offline functionality into our solution.
Does anyone have any do's or don'ts?
We are leaning toward making a new UUID PK column and the necessary UUID FK columns in our existing tables and NOT changing the existing column type and overwriting existing ID's with new ID's.
Is this a good idea?
Any better ideas?
Thanks.