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
Hi,
how do you migrate the data?
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 2
HR-09070029-0 2
UllrSki 2
