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

Alikutty A · ‎12-20-2018

Hello,

If you need to maintain same SYS IDs, You can perform a clone back from your source to target instance.

Cloning

If this is just for a single table, then you could export the XML of records and then import at your target instance.

XML Export

Thanks!

Nitin Duggal2 · ‎12-21-2018

I used to do this manually right now exporting and importing but i need some ideas regarding automating this.

Alikutty A · ‎12-21-2018

If users exists on both the instances, then it can be automated via a transform map but if there are new users then you need to manually synchronize them because if you use transform map then it will create a new user with a different SYS ID whereas existing users will be an update on same SYS ID.

Nitin Duggal2 · ‎12-24-2018

Thanks ...will try using XML import