Sync data in sys_user table between multiple prod instances

[Nitin Duggal2]

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.

[Alikutty A]

You can refer to link provided by Pradeep. it explains all steps involved.

[Rahul Priyadars]

Similar post for same kind of requirements.

https://community.servicenow.com/community?id=community_question&sys_id=2f40a168dbdadf004816f3231f96...

https://community.servicenow.com/community?id=community_question&sys_id=b2eb95bddb2a1380e0e80b55ca96...

Regards

RP

[Nitin Duggal2]

The above link contains the manual steps we can do , i want to automate these steps while keeping the sys_id same in both the instance.

[Nitin Duggal2]

Thanks @Rahul

[Pradeep Sharma · Accepted solution]

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