How to migrate custom tables

chrish5
Giga Guru

‎01-24-2024 07:10 AM

We are in the process of migrating our ServiceNow instance to our new parent company that also uses ServiceNow.  Migrating the data between OOB tables like sys_user_* and cmdb_* has been pretty easy to accomplish.  Where we are not sure how to proceed is migrating our custom tables to the parent company instance where those table to exist.  Do you migrate the table structure first, then the data?  Or do you migrate it all at the same time?  And what is the process to migrate table structure and data?  

0 Helpfuls
  • 727 Views
2 REPLIES 2

Maik Skoddow
Tera Patron
Tera Patron

‎01-24-2024 08:25 AM

Hi @chrish5 

basically a custom table should be embedded into a custom application and transferring the complete application to another instance would be the preferred approach, as there is not only the structure but tons of additional artifacts (configurations) which also have to be transferred.

Apart from that, there is no easy answer and there are different approaches to achieve the goal depending on your special situation.

Maik

0 Helpfuls

Narsing1
Mega Sage

‎01-24-2024 08:45 AM - edited ‎01-24-2024 08:47 AM

Hi, 

You may consider the below 

  • If it is Greenfield instance, then would be good to have all your custom tables in a custom app instead of in the global scope. (Note:  you may consider to create multiple apps based on the nature of your custom table and its functionality)
  • If the above not possible, first do the code search via Studio application and provide your custom table for search.  
  • Check whether you have any BR/client scripts/script includes involved and make a note of it.
  • Go to the definition of the custom table and observe for any reference fields.  If exists, you need to make sure those tables also exists in the other instance / need to copy these as well.
  • Copy the Table definition and copy the all the related scripts into your new instance.

Thanks,

Narsing

0 Helpfuls