How can I check that a data migration project (data migration from excel sheets to salesforce) is done completely right ?

  • @Ricky You can try close.io to migrate data from excel to salesforce and also can track the status of the Migration Mar 22, 2017 at 8:07
  • the data migration is already done , I just don't know to test if it is done completely correct or not? for example I found some duplicate records right now so I found that I must do a deep test to be sure about everything
    – Rickey
    Mar 22, 2017 at 8:36
  • @Rickey What tool did you use for data migration?
    – Reshma
    Mar 22, 2017 at 8:49
  • @Rickey Try Apex coding to query the duplicate record and process it if you want to delete it or you can try Custom report type on the object and delete the duplicate records. Mar 22, 2017 at 8:53
  • can you take a look at these codes and advice me which one is better : select name,last name count() from Contact group by name having count()>1 ___________________________________________ List<AggregateResult> acc=[SELECT Name, Lastname count(Id) FROM Contact GROUP BY Name HAVING count(Id)>1]; for(AggregateResult aggres : acc) { System.debug('Finding duplicate names'+aggres); }
    – Rickey
    Mar 22, 2017 at 9:03

1 Answer 1


Some of the steps to validate data after migration ,

  1. Generating reports on source & target to verify record count

  2. Checking data integrity by verifying some test records.

  3. Check if the duplicate already exist in source & if you have already moved in duplicates then use some free apps on appexchange to identify & eliminate the same.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .