Sync data in sys_user table between multiple prod instances

Nitin Duggal2 · ‎12-20-2018

I need to sync data between 2 prod instances with same sys_id in both the instances.What is the best possible option to do that.

Pradeep Sharma · ‎12-21-2018

Hi Nitin,

You can automate this via XML Import sets. Please refer below link with the exact steps that you need to follow in order to automate this. In the last step, you will have a Transform script(mentioned in point no 4 in the below link) which will copy the sys_id of new records from the source to the target instance.

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/import-sets/concept/c_XMLImportSets.html

-Pradeep Sharma

View solution in original post

Nitin Duggal2 · ‎12-24-2018

Thanks @pradeep

Nitin Duggal2 · ‎12-26-2018

Hi Pradeep,

I tried using XML import on my personal instance, After following all the steps mentioned in the link. I clicked on the load data and data is loaded successfully in the import set and after that when i tried transform the instance got logged out and i am not able to login now.

Do you know why it is happening ?

Can you please help on this ?

Pradeep Sharma · ‎12-26-2018

Were you able to reset your personal dev instance password via "Manage Instance" page?

-Pradeep Sharma

Nitin Duggal2 · ‎12-27-2018

Reset admin password worked. It was actually happening because administrator user was also getting updated on destination side.

Thanks Pradeep for the help !!

Nitin Duggal2 · ‎01-11-2019

Hi Pradeep,

I am able to update sys_id at the time of insert using this approach but facing challenge at the time of update. The issue here is there are some record that are out of sync at this time in both the instance so at the time of update i want to update the sys_id as well of these records , will it be possible to do it ?