Export Import of Standard Change Templates

Bruler1230
Tera Expert

‎08-16-2022 09:02 AM

I need to export the standard change templates out of one instance and then import them into a new, separate instance. I am looking any suggestions on the correct tables, as well as, the order that i should import the data. I have found a few articles on this but nothing that gave concrete answers.

I have exported the std_change_record_producer, std_change_proposal, std_change_producer_version tables...is this all that i need? and is there a certain order that these tables should be imported?

Thanks!

0 Helpfuls
  • 1,935 Views
2 REPLIES 2

cynlink1
Tera Expert

‎10-24-2023 03:02 PM

Hi @Bruler1230,

 

Did you figure out the order for importing the tables? I found a list of tables in KB0779255, but order is not mentioned.

 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0779255

 

As a workaround, the following could be applied:

  • XML Export/Import all related [std_change_proposal], [std_change_record_producer], [std_change_producer_version], [change_request] and approval records to the target instance. These records are not intended to be migrated via Update Set. In case you are getting a permission denied error while importing XML, you may need to create an ACL on the std_change_record_producer for create operation to allow admin users to create a record in this table.
  • OR recreate the Standard Change Template manually on the target instance.

Related Problem: PRB1178710