Take the 2-minute tour ×
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.

Is there already a SFDC tool that will take a set of test data - similar to what is part of every developer org - and load it into a new developer sandbox?

Is there a tool to wipe out an entire org's data, in order to get ready to reload the test data?

I am aware of Data Loader and similar tools for loading data - I am tired of using those and am looking for something more efficient.

I am assuming that I would have to follow some sort of CSV or JSON formatting - but before I build my own tools here, I want to see if something similar already exists.

Thanks!

share|improve this question
add comment

2 Answers

There is Test.loadData() which can be used to load a number of testing records from a CSV file stored as a static resource.

This is great if the intention of the data is for running automated test cases. Not so useful if you want to setup an org for an actual user.

share|improve this answer
add comment

To wipe out a sandbox, simply refresh from Production and activate the refreshed sandbox.

If it is not a full copy sandbox, the data will be wiped clean.

DreamFactory do a tool called Monarch, which I have seen widely used for moving data between sandboxes for setting up seed test data.

Also, although it isn't really meant for this, I've read about Salesforce 2 Salesforce being used for this purpose, although I haven't tried it out myself.

Dataloader can be quite handy if you have a set of CSV files and external id fields on each object to marry up the relational data on load. You could save the mappings and make this process repeatable by setting up Dataloader to run command line.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.