Queries on Administration tasks

(0) Share

Report

Posted on by Community Member

Hi AXperts,

Question1:

If we restore a environment AX Databases(pre-compiled) with another environment and then finish all the required changes in tables and service accounts.

Is Full CIL and DB SYnc required here?

Question2:

Where does the information about the relation between DynamicsAX database and DynamicsAX_Model get stored?

Eg: If I have multiple instances of DAX and DAX_model databases in one sql server and If I miss the naming convention of DAX_Model how do I know the databases?

Thanks,

SAA

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

1. Which database? The transactional database, the modelstore database, or both?

2. As far as I know, AX simple looks for the same name plus _model suffix.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

1. Both Transaction and Model store databases.

Thanks Martin.

Was this reply helpful? Yes No
Suggested answer

Umesh Pandit 9,315 User Group Leader on at

Like (0)

Report

Answer 1) Is Full CIL and DB SYnc required here.?

No As such, but its recommend to run DB Sync and generate the Full-CIL, if you face any issue.

Answer 2) Where does the information about the relation between DynamicsAX database and DynamicsAX_Model get stored?

Method 1) You can check in AX Server Configuration

Method 2) Click System administration > Setup > Database >

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,801 Most Valuable Professional on at

Like (1)

Report

If you move the complete modelstore, then it's not necessary to recompile it.

And if you move the transactional database with it, there is no need to synchronize it, because nothing has changed.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Umesh,

from server config utility we get the DAX and DAX_Baseline databases but not the model information and the same from Database information.

I need to know if any thing which stores that clearly tells DAX and DAX_model are linked.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Martin.

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

I believe I've already answered the question about modelstore databases.

If you agree, please close the thread by marking verified answers. If not, please tell us what you need to get everything answered.

Was this reply helpful? Yes No