Is it possible to export a table from instance 1 to instance 2 (with all its records, column fields, etc.) via a XML file?

[georgimavrodiev]

Hello all,

Today, a strange idea visited my mind: to export a table from one Helsinki Instance to another Helsinki Instance via a XML file.
I made two tests, in order to achieve this:

- Test 1 - exported a XML file of a global (default) table (which exists on both the Instances) from the first Instance and then imported the XML file on the second Instance.
In order to notice any changes, before exporting the XML file, I added an additional Table Column to the table, making the column count to 87, while the same table continued to have 86 on the second Instance.
Here are the steps I did:

Instance 1 -> System Definition > Tables > marked the checkbox of the selected table in the Tables list, then right - clicked the Name filed > Export > XML;
Instance 2 -> System definition > Tables > marked the checkbox of the selected table in the Tables list, then right - clicked the Name field > Import XML;

Result: nothing happened. The importation of the file was completed, but yet, the table of Instance 2 continued to have 86 Table columns, not 87 as the table of Instance 1;

- Test 2 - exported a XML file of a table from Instance 1, which table does not exist in Instance 2.
Result: nothing happened after the importation of the file. The table did not appear on the Instance 2;

I have to say that I read the following documents in Wiki:

Exporting Data - Exporting Data - ServiceNow Wiki

Exporting and Importing XML Files - http://wiki.servicenow.com/index.php?title=Exporting_and_Importing_XML_Files#gsc.tab=0

Importing from Another ServiceNow Instance - http://wiki.servicenow.com/index.php?title=Importing_from_Another_ServiceNow_Instance#gsc.tab=0

All of this leads me to the conclusion that I cannot export a table from one Instance and to import it to another one via a XML file.
I can import table records, but cannot import the table itself (if we have a scenario in which the table does not exist in the target instance, where the importation will be happening) or to import its fields (if we are talking about a scenario in which the table exists on both the instances, but the Table Columns count is different).

In order to be absolutely sure in this, I would like to receive an official confirmation of my understandings. Please let me know:

- If I got the things right or I am wrong and I can export and import a table (no matter existing or not) from one Instance to another. If so, then let me know how to do this;

- Confirm to me if the only way for this to happen (importing a whole table or only its fields from one Instance to another) is via an Update Set?

Thank you in advance!

Best Regards,

Georgi Mavrodiev

IT Consultant
Do It Wise

You may visit us in our Web Site: www.doitwise.com

[georgimavrodiev]

Hi Chuck,

I will actually mark the newest reply of yours also as Helpful.
This is because it is and also due to the fact the original question behind the opening of the thread was answered some time ago by Pradeep

Yet, thank you once again for covering the sub - question (about scenario 3) of mine, Chuck!

Cheers,

Georgi