Primary key type change is a tricky change. This is valid for any type change, not only the primary keys:
Client data might not be compatible with the new type, for the fields that directly changed its type and for those that are dependent (by formula, procedure, etc...), so mapping scripts will be necessary.
In fact, only a few cases are compatible with changing the type. (i.e: string is not compatible to int if the string has anything in its context that's not integer or space)
So, with this in mind, might as well take safe measures to ensure the client data is not lost. First thing: Backup.
Now for primary keys:
There will be the need to map things from the older value to the new value, where the primary keys are being used in other tables (foreign keys). So in each table, as a golden rule: its recommended to have a new field that has the old value, so mapping can be done by script.
Other things to consider (in Genio or final data) are the other fields that use the ones that changed its type, that might require some adjustments (formulas, replicas, manual code, views, procedures, triggers, etc...)
About the Community
|Asked: 8/20/19, 1:51 PM|
|Seen: 899 times|
|Last updated: 10/3/19, 4:07 PM|