Dear community,
i have the following requirement.
Currently there is 1 custom table u_category. Which already contains data.
I am extending this table to have child table u_category_1 with brand new data.
+
We would like to move existing data from parent 'u_category' to another child e.g. u_category_2, because of data consistency, reporting, also there could be other child category tables needed in the future.
Please, could you have a look on the following questions and answer them? thank you
1.) What would be the best way to transfer data from parent table level to child?
- update the sys_class in parent to new class? (field is editable...but I am not sure if it would work)
- script ?
- ...
2.) Currently data from parent table are in use (referenced) on incident record. What will happen if we change where the data are stored?
- I guess the field won't show anything and the related logic/ref qual will have to be updated accordingly...
- ...?
3.) We will have to move new data stored in table u_category_1 to TEST/PROD instances + eventually also data from 'u_category_2' table. What would be the best approach to move them?
- XML?
- update set?
3.a) In case we upload those data from DEV to TEST. Does it change the data in any way? Mainly the sys_id?
p.s.
I will test approaches on my PDI ... once it is available again 😞
thank you
Regards
Ales
