CMDB Data and Relationship Migration

rahulyamgar
Tera Guru

‎10-18-2023 08:43 AM

My fellow SN masters,

 

We had the custom CMDB tables/classes created and through custom integrations we have been populating them. Now, SN provided the module which has new CMDB tables with fields. Now, we would like to migrate the data from multiple OLD CMDB tables to NEW CMDB tables. There are 7 such tables and around 200K records across these various tables.  This migration is going to be one time activity.  What`s the efficient way of getting this done?

 

Much appreciated,
Rahul

 

 

Labels:
0 Helpfuls
  • 805 Views
2 REPLIES 2

Niklas Peterson
Mega Sage
Mega Sage

‎10-20-2023 11:00 AM

Hi,


My recommendation is to make sure you reclassify the records. Do not copy records. By reclassifying you will keep the sys_id and all references to other records.

The only issue with reclassifying is if there is a big difference in the class hierarchy. Then you may risk losing data because attributes are missing or are different in the new class compared to the old. So your migration script needs to ensure that for each record that you reclassify you need to either have the same attribute or you need to copy the data from an old attribute to a new attribute.

And as always. Test in non-prod first!

Regards,
Niklas

0 Helpfuls

Pratiksha
Mega Sage
Mega Sage

‎10-23-2023 07:43 AM

Few things : Check if you have all fields  in the new table, do a detailed mapping. If the feilds are not present make sure you create custom fields on the target table. 

 

We recently working on moving oob for service offering table. The custom one was extended from service table so few of the fields were already present. Rest we created and changed the class. The data moved perfectly. 

 

You will also need to check where all it has been refrenced in scripts. SNUtils is great tool to find out refrenced up to an extend. Please try in non prod instance first. 

0 Helpfuls