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 – Samuel Robert Mar 22 '17 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 '17 at 8:36
  • @Rickey What tool did you use for data migration? – Reshma Mar 22 '17 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. – Samuel Robert Mar 22 '17 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 '17 at 9:03

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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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