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.

[Ankur Bawiskar]

@Dave_p 

Usually export import of XML is recommended.

It's the easy way.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Dave_p 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[sunil maddheshi]

@Dave_p 

Export & Import Method (Best for Small Data Moves)

Step 1: Export Data from DEV

1. Go to Table List View

   • Navigate to the table (e.g., incident.list).
   • Apply a filter (if needed) to limit the results to 500 records.

2. Export the Data

   • Click the List Actions Menu (≡) → Export → Choose one of the formats:
     • CSV (Recommended for small data sets)
     • XML (Best for structured data with relationships)

[Dave_p]

Hi @Joni V B,

When I do Add to Update Set. It gives me unwanted Update Sets. I am trying to export the data through Excel and follow through Transform Map as @Anubhav24 suggested.

Regards

Suman P.

[Dr Atul G- LNG]

Hi @Dave_p 

It is better to use XML if records mean data, not the business logic.