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

JLeong
Mega Sage

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

 

 

1 ACCEPTED SOLUTION

BachAF
Tera Contributor

Hi Jocelyn,

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

  1. 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...
  2. Request Cloning for your Prod instance.
  3. Perform XML file import.
  4. 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

12 REPLIES 12

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.

Hi Kieran, 

 

The link above appears to be broken. Could you possibly provide a working link?

 

Thank you. 

Pooja Mallikarj
Kilo Sage

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.

https://docs.servicenow.com/bundle/jakarta-servicenow-platform/page/administer/import-sets/concept/c...

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

Please mark my answer as correct/helpful if it helps for you.

Thanks,

Pooja M

BachAF
Tera Contributor

Hi Jocelyn,

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

  1. 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...
  2. Request Cloning for your Prod instance.
  3. Perform XML file import.
  4. 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

 

Thank you Bachtiar for a detailed suggestions!