It seems there are tons of ways to load data into salesforce - https://help.salesforce.com/HTViewHelpDoc?id=import_which_data_import_tool.htm&language=en_US
But I am specifically looking for the best option to manage reference data for our project. In ruby on rails you can create database migrations or load yaml files to do similar things.
Is there any command line tool that I can use to automate the creation of reference data in any new environment? Same thing for doing updates. Particularly interested in one that can create relationships between custom objects.
So my use case is Suzy creates some reference data records that need to be loaded into each environment for the business logic to work. Say there is a custom entity "task_templates" that relates to sf recordtypes of another custom entity. We want to baseline a script that will get run by other developers and also when pushed into the sandbox.
Bob comes along and needs to add more reference data and fix one of Suzy's records, so he needs to create a script that would be run after Suzy's script.
This seems like something every project would need. Is everyone just doing this manually?