Move data from instance to another instance

[Heba Mohamed1]

I have a need to copy table data from one instance to another ... I'm aware that there are 2 ways to do so 

• Export and import XML records directly from lists
• Create XML import sets and transform data as needed

since I need to move all the data not just one record I should use imports sets, but the import set table name only accepts user defined tables I want to move that data of kb_knowledge table whenever I write this in the import set table name field it gets converted to u_kb_knowledge

Is there a way to move the data ?

[Susan Britt]

You can export XML for all records in a table.  Navigate to the list of records you want to export.  For example, type 'kb_knowledge.LIST' in the filter navigator box to open all of the kb_knowledge records in a new tab.  Filter, if needed, to show only the articles you want to export.  Export > XML as normal.  It will export all of those records.  Go to your target instance, from any list view (doesn't have to be kb_knowledge records, but easier to verify import if you are there), select "Import XML" from the menu option.  

As far as Import Set table, you are creating the staging table, which will be a custom table.  After you create the import set, you will create the Data Source and Transform Map. The transform map is where you will map from your custom staging table (u_kb_knowledge) to the actual ServiceNow table (kb_knowledge).

[Heba Mohamed1 · Accepted solution]

Thanks sbritt that was useful 🙂