Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012CRM Connector in Microsoft Dynamics AX 2012Financials Management in Microsoft Dynamics AX 2012Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
Inventory Costing in Microsoft Dynamics AX 2009
Invoice Settlements/Discounts/Reversals
SSRS and SSAS Integration
Workflow
Hello,
I have a question regarding AX2012 upgrade considerations when doing data upgrade from AX4.0/AX2009.
It is said:
Make the following changes to indexes:
- InventTrans table : Prior to running the upgrade scripts, change the clustered index on the table so that it is on the RecID field, and make sure that it is the only index that exists within the SQL Server database. This will enable the updateInventTrans method to run much faster (in some cases, hours to days faster) for larger InventTrans tables.
If I understood correctly, would that mean that even after bulk copying inventtrans, (and after the reindexing following the bulk), the table will still have only one index on RecId ? If so, I saw that there were some DEL_ indexes on inventtrans created especially for post-sync scripts. So I presume, these won't be used by upgrade scripts, is it ok to do so? Or is this something more complex?
Is this recommendation also applicable for migrations to AX2012 R2?
Thanks
Hello Nicolas --
I have the following reply from one of our senior support people:
"The indexes on the table get recreated as part of the bulk copy process automatically.
"For the second question, we implemented the change to the clustered index through upgrade scripts with R2 so the manual step is no longer required."
I hope this helps.
Best wishes,
David
David W. Robinson
Technical writer | Microsoft Dynamics AX | Upgrade