Skip to main content What is Dynamics 365? Guided tours Customer stories Try our products Build your own agents CRM ERP Sales Service Sales Customer Insights Customer Service Contact Center Field Service Supply Chain Management Commerce Finance Project Operations Human Resources Business Central Pricing Business application topics Training & certifications Documentation Migrate to the cloud Private equity Migrate to Dynamics 365 Events Dynamics 365 Blog Product updates Onboarding and implementation Community Find a partner Software Development Companies Partner resources Microsoft Marketplace Product documentation Technical support On-premises product support Contact us Try for free Sign in
1 min read

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.

Get started with Dynamics 365

Drive more efficiency, reduce costs, and create a hyperconnected business that links people, data, and processes across your organization—enabling every team to quickly adapt and innovate.