What are the ways to do Data Migration in Production Organization. I am trying to do something like
- Migrate data from Account lookup field in Lead to new lookup field in the same object (lookup for a custom object)
- Move data from one object's fields to another custom object.
- Change all null values of a field to 'Default'
How to achieve this in salesforce. I know SOQL queries can only be used for selecting records and not for inserting/updating. I find using Apex Data Loader as a good solution. I tried exporting data from the object, modified values, created new csv to support new objects and copied data and imported back into salesforce. Is this the right way of doing it?Please suggest me a solution. I am new to salesforce!.