Is there a way to synch up tables from Prod to all sub instances?

JLeong · ‎05-27-2020

Hi Guys,

Is there a way to sync up tables from Prod to all sub instances?

Tables like:

- sys_user_group
- sys_user_grmember
- sys_choice

Thank you!

Regards,
Jocelyn

BachAF · ‎06-21-2020

Hi Jocelyn,

There are multiple ways to synch up tables from Prod to other instances:

Install Instance Data Replication (IDR) plug-in, you can purchase it from ServiceNow store. Product documentation is: https://docs.servicenow.com/bundle/orlando-servicenow-platform/page/administer/instance-data-replica...
Request Cloning for your Prod instance.
Perform XML file import.
Create your own ServiceNow integration with the following steps:

Create Scripted Rest API and use POST method,
Create Business Rule or Flow Designer and define your trigger (i.e. when a new record in that particular table is created),
Create table for import set row,
Create transform map (i.e. source: your_scope_app.table, target: sys_user_group), please note if you want the data to have the same sys_id across instances then you can do transform script before insert.

Hope my answers above help solving your need.

Thanks.

Bachtiar

View solution in original post

Tony Chatfield1 · ‎05-27-2020

Hi, if outside of a standard clone xml is normally used to copy user and group data from 1 instance to another, and in a well-managed environment I would expect sys_choice data to be replicated via update set from sub-prod to prod and either updateset or xml between subprod instances.

You could utilise some sort of integration (IE REST) or replication to do this for you;
But regular weekly\bi weekly or monthly clone (depending on your environmental requirements),
augmented by manual xml for any records that are 'specific' to the development being undertaken on the sub-prod instance may be the most cost efficient solution.

JLeong · ‎05-27-2020

Thanks Tony for replying to my email.

Regards,

Jocelyn

Kieran Anson · ‎05-27-2020

Hi Jocelyn,

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.

DOCS - XML Import Sets

If my reply helped with your issue please mark helpful 👍 and correct if your issue is now resolved. ✅
By doing so you help other community members find resolved questions which may relate to an issue they're having.

JLeong · ‎05-27-2020

Thanks Keiran.

I will try this and let you know.