I want to import a whole Table from one instance to another. What updates should I need to capture

Saurav Bhardwa2
Tera Contributor

I want to import a whole Table from Source instance to Target Instance. What updates should I need to capture in an update set so the form design, layout, acl/roles customization and everything will look same on the Target Instance

In Source Instance they imported that table from Push or Pull mechanisms and we have multiple update set in source instance, so I am not able to get all the details through sys_update_xml.list table. 

I have to capture everything from start, the question is what I need to capture so the form will look same on the Target Instance.

3 REPLIES 3

SatyakiBose
Mega Sage

Hello @Saurav Bhardwa2 

Please follow below steps.

  1. Go to the System Definition --> Tables and export the table record as XML  and import in other instance.
  2. Go to sys_dictionary.LIST .Filter the entries for the table name exported in the step 1. Export as XML and import in other instance.
  3. You also need to go to sys_documentation and export the columns for this table, and then import it.
  4. Go to System Definition --> Modules . Filter the module you want to move.Export as XML and import in other instance.
  5. Now you need to export all configurations like  Business rule, client script etc used for the table and import them in other instance.

If you want to move the records created in that table then like wise you need to export and import.

 

Please mark it as Helpful/Correct according to its impact.

I have followed the above steps. I have imported all the records, I can see the list view, but when I clicking on NEW button, it is showing me a empty white page.

Hello @Saurav Bhardwa2 

Thats because the form layouts for the specific table has not been imported.

Please follow the KB article below:

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

You need to move the below records as well for the table in question here to the target instance.