import/ export tables from DEV to Prod

[sonita]

I have created two tables in DEV instance which I'm trying to bring to prod , what I normally do is to export the table from DEV and import it to Prod. BUT It didn't work now. actually when I imported , the label of the table was label and the data was not inside it and when I tried to show list   , it said this table does not exist!

I'm not sure what is happening!

we had a clone recently , can it be the reason maybe?!

[Chuck Tomasi]

Hi Bobby,

Short answer - yes. You would need to create a new update set then go to the sys_update_xml table, locate all the entries related to those fields (which may also include form layout, list layout, etc.) and update the Update Set field from Global/default to your update set. Not for the uninitiated.

The faster way (since it's not in prod yet) would be to delete the fields, select the correct update set, then recreate them.

[paramveer]

Only dictionary entries(table and columns information) capture in update set. Table data does not capture. data you need to export import manually after table creation in other instances.

[david_loo]

A simpler way is to use a product like Perspectium Replicator and configure the export/import, no web service, coding - also sys_id is maintained.

Using Replicator to sync up ServiceNow instances - YouTube

We have a free trial happening now - let us know if we can help

David