Microsoft Dynamics AX (Archived)

Table, Class, Form where store in database

(0) Share

Report

Posted on by @rp@n

Dear All,

We have 3 database :

1. MicrosoftDynamics AX
2. MicrosoftDynamics AX_Model
3. MicrosoftDynamicsAXBaseLine

Table :
When we create a new Table Or add new field in existing table. Then in SQL which database it will store?
EDT :
When we create a new EDT. Then in SQL which database it will store?
Base Enum :
When we create a new Base Enum Or add new field in existing Base Enum. Then in SQL which database it will store?
Class :
When we create a new Class Or modification in existing Class. Then in SQL which database it will store?
Form:
When we create a new Form Or modification in existing Form. Then in SQL which database it will store?

Please give me more shed on this.

Thanks!
Arpan Sen

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (3)

Verified answer

Martin Dráb 238,147 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

As usual, you can find the answer in AX documentation, in this case System architecture [AX 2012]. You really should learn how to use documentation, so you can find answers by yourself instead of having to wait for others.

In short, all code and metadata are stored in the modelstore database (MicrosoftDynamicsAX_model in your case). It's the same for tables, classes, forms and everything else.

If you create a new table, for example, and synchronize your application with the transactional database (MicrosoftDynamicsAX in your case), the table will be added there. Modelstore holds the definition and code, the transactional database holds actual company data.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report
Copy link

Link copied!

Thanks Martin,

Sure i will go through the link.

As i understood only Tables are added in both database (MicrosoftDynamicsAX and MicrosoftDynamicsAX_Model) right?

And others objects are stored in MicrosoftDynamicsAX_Model only.

Thanks!

Arpan Sen

Was this reply helpful? Yes No
Verified answer

Hariharans87 3 on at

Like (0)

Report
Copy link

Link copied!

@rp@n,

"As i understood only Tables are added in both database (MicrosoftDynamicsAX and MicrosoftDynamicsAX_Model) right?"

No. The table definition stores in model db. But, physical table will be created in transactional db.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report
Copy link

Link copied!

Thanks Hariharan,

And other all objects like Form, Class, EDT, Base enum etc are stored in Model DB only right?

Thanks!

Arpan sen

Was this reply helpful? Yes No
Verified answer

krishna.rao@dax 3,008 on at

Like (0)

Report
Copy link

Link copied!

Yes, all objects are stored in Model db. ( MicrosoftDynamics AX_Model)

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot Krishna

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 238,147 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

It seems that you don't understand the purpose of database synchronization, despite answers you got in your thread What does database synchronize do?. You also don't distinguish between two meanings of "table", which may be another reason for your confusing.

Again, all X++ code and metadata is in the modelstore database and none in the transactional database. It doesn't matter which type of object it is. For example, there is information that your application contains a table called CustTable, but there is no SQL table called CustTable in the modelstore database.

Some objects, such as tables and views, define the structure of the transactional database. The synchronization then reads information about the required structure from the modelstore database and send appropriate SQL commands (such as CREATE TABLE) to the transactional database. The transactional database then contains CustTable table, created by database synchronization based on the AX table object modeled in AOT.

Was this reply helpful? Yes No