AX6 sneak preview – SQL AOD

Today we built the first official build of Dynamics AX ever that does not run on AOD files. Starting today Dynamics AX’s model database is stored in a Microsoft SQL Server database.

Seen from within MorphX you hardly notice the difference. Everything works as it used to; there are no new feautures; but yet it feels different. The responsiveness of MorphX has slowly been deteriorating as the number of elements in the model has grown over the last releases. Today the speed is back. Navigating the AOT is suddently a pleasure again. Meta data heavy operations, like searching, completes an order of magnitude faster. For example; searching all methods on forms for any text completes in 2 seconds.

But wait a minute; AOD files were not just a database, they were also a deployment vehicle – what is the replacement? Dynamics AX supports a new file format: axmodel-files. (extension: “axmodel”, example: “AxSYS.axmodel”). These are binary files, and provides the same deployment capabilites as AOD files did – and yet they are less than half size. Using a new tool you can import/export axmodel files to/from SQL. You can also import AOD files into SQL.

So far we have aimed at providing 1-to-1 parity with AOD files; but the potential of this is amazing – I hardly know where to start…

  • Performance can be further improved as the subsystems querying the meta data store starts levarging the powers of SQL. For example; the ISAM database used for the AOD files (and still used by temp tables) doesn’t support joins. Due to this many subsystems are overly chatty when reading meta data as they query row-by-row.

  • Solving the element ID problem is now possible, as we can leverage the flexibilty and powers in SQL for modifying and extending the model schema.

  • Capabilities… There are so many cool scenarios we can enable – but you’ll have to wait for an sneak preview after the next milestone to learn more. But to get you thinking: What deployment capabilties did AOD files lack?

To night we celebrate this major achievement with the team. 


Comments (14)

  1. msmfp says:

    j.a.estevan: The labels are now also stored in SQL. We still support export and import of ALD files to support localization – but at deployment you don't need to worry about ALD files, as the labels are also contained in the .axmodel files.

  2. sye zaim raza kazmi says:


    Is there anyway to execute Axapta query or tool which convert the axapta query in SQL server?


    Zaim Raza.

  3. j.a.estevan says:

    it would be nice if you can do same way for the anoying label files 😉

  4. msmfp says:

    Yes – the compiled source is also stored in the database (as a blob)

  5. AndiRudi says:

    Does this mean the compiled source code is also in the database in a blob?

  6. Vitaliy says:

    Will the AX6 support Oracle? How will changed the language of queries to the database? Is it possible to create nested queries?

  7. Andi says:

    Hello. I am currently trying to get the concept of edt’s in c#, but did not get it to work. Does anybody has some tips? I tried it with extensions methods and operator overloads but that isn’t working good. You can write me

  8. msmfp says:

    axstart: OSLO is a very interesting technology offer; our first step does not use any OLSO bits.

    Dan James: As I mentioned in my post, we are now capable of adding many new exciting features to the model store. RTM is still a few milestones out; and I anticipate the database schema will change as we add new capabilites. Please stay tuned.

  9. Dan James says:

    Any chance of posting the table structure for this 🙂 Would be a big help for the add-on developers out there!

  10. axstart says:

    is there a relation between the OSLO project of MS and AX 6.0

  11. Najmi says:

    Very exciting news indeed mfp.

  12. Arijit Basu says:

    This really is very very exciting. Looking forward to the next sneak peek and perhaps get a chance to play with it.

  13. Robert says:

    Very nice mfp!!! Congratulations!! BTW, we miss yours x++ screencasts, please make more =)

  14. Steffen says:

    This is truly exciting news. Can’t wait to get my hands on AX6 😀