- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-27-2020 07:44 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-21-2020 12:33 PM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-01-2020 04:29 AM
Hi, Checking in on whether my reply resolved your issue? If so please Mark ✅ Correct and /or 👍 Helpful if you find my response worthy based on the impact.
By doing so you help other community members find resolved questions which may relate to an issue they're having.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-08-2023 10:16 AM
Hi Kieran,
The link above appears to be broken. Could you possibly provide a working link?
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-01-2020 05:03 AM
Hi,
The best practice is to request a clone from production instance to lower sub instances especially after finishing a major push to production to have newly fresh data in the DEV and Test instance.
Or else you can export the users from Production and import to TEST and DEV. There are several ways to move data from one instance to another instance.You can find the below links.
Please mark my answer as correct/helpful if it helps for you.
Thanks,
Pooja M
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-21-2020 12:33 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-22-2020 06:20 AM
Thank you Bachtiar for a detailed suggestions!