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
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