Moving AXModelstore from Source environment to Target environment with different DB collation
AX 2012 R2/R3
We have in support received some queries for recommendations moving the AXModelStore from a Model
database to another Model database with different collation.
Conclusion:
The AXModelStore file we create is specific to SQL_Latin collations, saying that, for metadata,
AX only supports the SQL_Latin… collation on string fields, and that is why even Model database
is running on Server with other collations, we still enforce SQL_Latin collation at schema level.
So, there should not be an issue (we are aware of), when importing the AXModelStore file
from one (Source environment) to another (Target environment) having different collations.
