+ Start a Discussion
GAURAV SETHGAURAV SETH 

Export Data from Production to Developer edition Sandbox

Need help to understand the best way to move Data from Production to Developer edition Sandbox with every refresh.
Do we have any tool which can be used for free and can we automate the process do complete it ?
Best Answer chosen by GAURAV SETH
VinayVinay (Salesforce Developers) 
Hi Gaurav,

Please find below available details.

>> Dataloader
https://developer.salesforce.com/docs/atlas.en-us.dataLoader.meta/dataLoader/data_loader.htm

>> Try using Talend Open Studio for Data Integration. It's a free tool, find some info here: http://www.talend.com/products/data-integration.

>>Also you might find tools available in appexchange.

Below is sample for reference.

https://appexchange.salesforce.com/appxListingDetail?listingId=a0N3A00000EJxQHUA1

Hope above information was helpful.

Please mark as Best Answer so that it can help others in the future.

Thanks,
Vinay Kumar

All Answers

VinayVinay (Salesforce Developers) 
Hi Gaurav,

Please find below available details.

>> Dataloader
https://developer.salesforce.com/docs/atlas.en-us.dataLoader.meta/dataLoader/data_loader.htm

>> Try using Talend Open Studio for Data Integration. It's a free tool, find some info here: http://www.talend.com/products/data-integration.

>>Also you might find tools available in appexchange.

Below is sample for reference.

https://appexchange.salesforce.com/appxListingDetail?listingId=a0N3A00000EJxQHUA1

Hope above information was helpful.

Please mark as Best Answer so that it can help others in the future.

Thanks,
Vinay Kumar
This was selected as the best answer
vinie benetvinie benet

My Org is currently testing some integrations in the Sandbox and we require actual data that is in production for it. The current way we are working is manually creating the records but this is very tedious and error-prone. I thought about using Salesforce Inspector's data import and export but I believe it breaks with relationships, which our objects have (correct me if I'm wrong).

Is there a better way to transfer records while keeping relations between objects?

Thank you for your time.
VinayVinay (Salesforce Developers) 
Hi Vinie,

The best way is to use Data Loader  and try to load some data for your testing purpose or you can spin up new full copy sandbox and deploy metadata of integration components and do testing in new org.

Dataloader:
https://help.salesforce.com/articleView?id=exporting_data.htm&type=0

Hope above information was helpful.

Please mark as Best Answer so that it can help others in the future.

Thanks,
Vinay Kumar