web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AxUtil schema, what do...
Microsoft Dynamics AX (Archived)

AxUtil schema, what does it do?

(0) ShareShare
ReportReport
Posted on by Klaas Deforche 2,433

Hi everyone,

Who here knows exactly what "AxUtil schema" does and when to execute it? From what I understand it either creates a schema for the model store, or it updates an existing schema (create/modify indexes, fields in the model store tables?).

It's not clear to me when you should execute the command. Should you do it after installing a kernel fix? Should you do it after installing an application fix? Both? Would you recommend executing it every time after installing a fix or CU? Can it hurt?

Thanks

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Dick Wenning Profile Picture
    Dick Wenning 8,705 Moderator on at

    Create an empty model store that is associated with the specified schema, update the existing schema for a model store, or remove a non-default model store.

  • Verified answer
    Munib Profile Picture
    Munib 2,500 on at

    Model schemas are not changed when hotfixes are installed.

    But when you are doing a CU upgrade or similar then it is very important you run it.

    I didn't realize how important it was until I accidentally ran into problems my self.

    dynamicsnavax.blogspot.com.au/.../the-given-value-of-type-string-from.html

  • Verified answer
    Klaas Deforche Profile Picture
    Klaas Deforche 2,433 on at

    Hi guys,

    Thank you for you answers.

    Allow me to share my findings:

    I notice that some kernel fixes do change the modelstore schema. For this reason, I would recommend that after installen a kernel fix, you always run this command:

    axutil schema

    (so just this without any parameters, maybe except for the server (/s:) and database (/db:) you want to apply it to.

    This will update the schema of the modelstore so it is up to date. If you do not do this, you can get all kinds of errors, both while working with AX or AxUtil. It can never hurt to run this command either.

    As Dick says, you can also using it to import the modelstore into a temporary schema, en then also use it to apply that schema. I would also suggest using this method so that you can decrease the time that your production environment is offline.

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans