2,409
Hi, I trying to migrate invoice data from environment to another, and calculating products price, changing status. It seems quite slow, is there anyway I can speed up?
*This post is locked for comments
Same issue here, 10.5 million invoice details to migrate and hitting deadlocks all over kingdom come. Tracking shows all kinds up updates to the invoice detail itself after the insert (_base) fields. As well as updates to the invoice header, sub queries to the product entity etc.
I attempted disabling foreign key constraints and nonclustered indexes. This seemed to help a long time ago (CRM 2011) but it actually hurt the process in 365. The fastest I could get it to push by reducing the execute multiple requests down to 4 at 100 per batch, was around 5k a minute, over 10.5 million records, we are looking at over 80 hours of migration. This seems like a bunch of malarkey to me. I'm thinking about passing all the data in without product (ie, as override) and then coming back and back-filling the data properly with straight SQL using a while loop or something to make the transaction size smaller over the 10.5 million (ie, productid, and all the other fields that get filled out when it's correct). At this point i'm about ready to open a ticket with MS. Heck, I wish we could disable the internal plugins that run the calculations even, so that way I could just back fill it myself. At least I could get it to work then.
Hi,
how do you migrate the data?
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,375
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
