Update 10,000,000 records only in one attribute (Email attribute of Account entity) any systematic way. Please suggest me

(0) Share

Report

Posted on by Community Member

I have been doing these with the help of workflow and I searched on import and export data but having issue of duplication data.

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Mojtaba 735 on at

Like (0)

Report
Copy link

Link copied!

Hi Sushi

Could u bring an example of update you would to try?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Have you tried unpublishing duplicate detection rules associated with the accounts and then trying the import?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I already had tried facing the problem of duplication data............. any other solution, suggest plz....

Was this reply helpful? Yes No
Donna Edwards 2,996 on at

Like (1)

Report
Copy link

Link copied!

Give kingswaysoft a try. This is a SSIS tool created by Daniel Cai, a Dynamics CRM MVP.

https://www.kingswaysoft.com

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Best way is going to be something like Kingsway as per the below (or Scribe), you can do it in SSIS (which you presumably have where Kingsway and Scribe are third party apps you have to pay for if you want to use commercially). Link on how to get started here (not by me) : a33ik.blogspot.co.uk/.../integrating-crm-2011-using-sql.html

Was this reply helpful? Yes No
Suggested answer

Ben John 559 on at

Like (0)

Report
Copy link

Link copied!

I would also use a workflow, but I wouldn't start all manually.

www.zero2ten.com/.../ms-dynamics-crm-2011-bulk-workflow-execution-tool

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Ya! Benjamin but is their any solution to work in update an existing record any other way which is much more smart, efficient and effective...

Was this reply helpful? Yes No
Ben John 559 on at

Like (0)

Report
Copy link

Link copied!

I should read what I wrote before sending :-)

My first answer is now edited and corrected.

I would try the bulk workflow execution tool.

I'm not sure if you can trigger all 10M records at once or if you need to split it in several packages.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi! Benjamin

I try but that tools is not supported in CRM 2015.

Thanks and Regards

Was this reply helpful? Yes No
Donna Edwards 2,996 on at

Like (1)

Report
Copy link

Link copied!

In all honesty, I don't understand why you are not going with a supported tool like KingswaySoft. It is a great SSIS tool and will handle this need easily.

Was this reply helpful? Yes No