Thursday, March 9, 2023

AX 2012 R2 CU9 DIXF Data Export

 As we are now moving to D365, we need to export our data. Our partner assumed we had DIXF, however, we are in CU6 and it doesn't have DIXF.

In order to use DIXF we upgrade one non-production environment to CU9. (Microsoft recommended either CU8 or CU9 not CU7).

Once we upgraded that, we could then use DIXF.  However, this left an issue of how to get new data from PRODUCTION into this CU9 environment.

  1. Using the test data transfer tool, export out ALL DMF tables.
  2. Refresh non-production environment transactional DB as usual. (DO NOT refresh model DB)
  3. Run CU9 KB upgrade to upgrade the DB
  4. Run and complete the software update checklist.
  5. Using the test data transfer tool, import ALL DMF tables.
Although this does take me about 3 hours to complete it gets the job done.  Steps 1 and 5 allow us to continue to develop our data entities in DIXF and perform refreshes without losing out progress.

No comments:

Post a Comment