Moving table data from one PDI to another PDI

[Kishore32]

Hello,

I'm having an Application with 50+ tables in 2 different PDI's. Now i wanted to move the all tables data from 1 instance to another instance. Can it be done in one shot instead of doing export xml and import xml for every individual table?

Please let me know if you need more detail on this question.

Thank you

[Chuck Tomasi]

Depending how many records, you might want to use the "Create Application File" option from the list menu to add the data as "demo data" to your application. If you have <20 records per table, this is an easy way to include it all, but you still have to visit each table. If you have hundreds or thousands of records, then you'll want to do export XML/import XML.

[Kishore32]

Hi Chuck,

There are some lookup tables which contains maximum of 300 records in one table and other tables contains actual data from hundreds to thousands of records and there is relation between them.

So, is there any other way to upload all xml table data in an orderly manner?

Other question is, if i want to move this application to production, same process applies?

Thank you

[Chuck Tomasi · Accepted solution]

Hi Kishore,

You may find these apps on the share site helpful.

Multi-Table Data Export Tool and Interface - Share | ServiceNow Developers

Multiple Table Exporter with Filters - Share | ServiceNow Developers

@Jeremy Duncan is a big advocate of one of these, but I don't recall which one. It could save you lots of time, especially on the bigger tables.

As a footnote to your last comment, make sure you are only exporting data and importing it in to production if it truly is production data. Once done, don't do it again, you should clone data from prod downwards to refresh it. If you need tables to stay in sync, consider IDR.

[Jeremy Duncan]

As @Chuck Tomasi mentioned, one of my all-time favorites is using the Multi-Table export tool originally published by @John Andersen in the link above. It allows you to export multiple tables (filtered if you desire) in one click!