How to move the records of a parent table to one of it's child table.

[Harika Ravuri]

We got a scenario where we have to move the companies(core_company) to accounts(customer_account). I don't want to recreate the records again as customer as we need same sys id's to be maintained.

[Dr Atul G- LNG]

Hi @Harika Ravuri 

Have a look here

https://www.servicenow.com/community/developer-forum/is-it-possible-to-import-parent-table-records-t...

Credit @Anurag Tripathi 

[Harika Ravuri]

Hi @Dr Atul G- LNG,

I appreciate for the quick reply 🙂

I'm looking to move the entire data to child table but in the link you have shared is showing how to copy data and differentiate data using some custom field.

[Dr Atul G- LNG · Accepted solution]

Hi @Harika Ravuri 

https://www.servicenow.com/community/csm-forum/convert-companies-to-accounts/m-p/421745/page/2

[Harika Ravuri]

Thank you for the solution. If we just change the class to 'account' from 'company', it'll automatically move to customer_account table. This is as similar as CMDB class change.