The Zurich release has arrived! Interested in new features and functionalities? Click here for more

How to export/import table structure to another instance ?

Yusuf5
Tera Expert

Hi,

I wonder if there is any way to export a table structure to another instance, so I don't have to go through the table recreation in another instance.

Any help is appreciated.

Regards

Yusuf

1 ACCEPTED SOLUTION

Yusuf CELIK wrote:



I created the table in DEV environment and I didn't create an update set.


And I've gone through another update sets no clue, I think I have to go with the traditional way, just create.


Thanks



Regards


Yusuf


In this case create a Local Update set and then go to sys_update_xml table. This table contains all customer updates. Under the Update set field for your record update your newly created local update set name.



All your updates will be now available in newly created local update set. Now you can move your changes from Dev to Test or Prod using this update set.


View solution in original post

7 REPLIES 7

Yusuf CELIK wrote:



I created the table in DEV environment and I didn't create an update set.


And I've gone through another update sets no clue, I think I have to go with the traditional way, just create.


Thanks



Regards


Yusuf


In this case create a Local Update set and then go to sys_update_xml table. This table contains all customer updates. Under the Update set field for your record update your newly created local update set name.



All your updates will be now available in newly created local update set. Now you can move your changes from Dev to Test or Prod using this update set.


Open the global update set,



right click on the updaet set = default



find_real_file.png



find_real_file.png




if uoi created today you can add the filter and add those updaet set to another update set by chnage the name of updaet set in updaet set field


find_real_file.png


Khanna Ji
Tera Guru

There is no way to export and import table structure in ServiceNow.



Below are the possible ways to move customizations



  • If you have captured changes done in Update Set then you can use that update set to move to other instance.
  • Clone the instance (Like database refresh)
  • Manually do the changes if above two are not feasible