How to move 500 records from one instance to another

[Dave_p]

Hi,

How can I copy or move 500 records of a table from DEV to SANDBOX. Kindly help.

Regards

Suman P.

[Joni V B]

Hi @Dave_p ,

You can export data records by right clicking on the column header and choosing 'Export > xml', afterwards on Dev you can import them in a similar way.

Alternatively you could use the 'Add to update set utility' for this:

https://www.servicenow.com/community/developer-blog/add-to-update-set-utility-documentation-and-cust...

Best regards,

Joni

[Dave_p]

Hi @Joni V B,

The table has got 500000 records. I think i will try Add to UpdateSet Utility and let you know.

Regards

Suman P.

[Joni V B]

There is also the Instance Data Replication tool from ServiceNow, but that is not free of charge:

https://www.servicenow.com/docs/bundle/xanadu-servicenow-platform/page/administer/instance-data-repl...

[Anubhav24]

Hi @Dave_p ,

Simple export of records in excel and then importing them through a transform map , assuming if tables and columns are not in sync.

Please mark correct/helpful if my response helped you.