Friday 27 November 2015

Import Model store AX 2012

During AX 2012 upgrade steps there is the step required to import model store. The AX upgrade guide given the steps but it could not work to me. For that I found other way on technet steps as below:

- Create a temporary schema
- Import model store to temporary schema
- Apply the model store


Import model store

Create a temporary schema
Create a temporary schema in AX database to be used on next step during import model store.

Steps:
1. Open SQL Server Management Studio
2. Connect to the SQL Server instance where AX database resides
3. Expand to Databases > MicrosoftDynamicsAX_model > Security > Schemas
4. Right click > New schema
5. Type in the temporary schema name (TempSchema) and select the schema owner and click "OK"
6. Initialize the temporary schema

Initialize-AXModelStore -AOSAccount "Domain\AccountName" -SchemaName <NewSchema> -Server <ServerName> -Database <DatabaseName>)


Import model store to temporary schema
Syntax: Import-AXModelStore -File <filename> -SchemaName 

Example:
Import-AXModelStore -File “C:\AX_Model_and_ModelStore_Backup-Export\AXModels_11-9\AXModelStore.axmodelstore” -SchemaName “TempSchema” –IdConflict overwrite



This will take a long time (might be 2+ hours)


Apply the model store

Example: Import-AXModelStore -Apply:TempSchema  





Restrat AOS, compile and synchronize application


This helped you..!! Then comment below..:)

No comments:

Post a Comment