Import Model Store in AX 2012 R2\R3 by Creating the Temporary schema

Import Model Store in AX 2012 R2\R3 by Creating the Temporary schema

Importing  Model Store in AX 2012 R2\R3 by Creating the temporary schema involves these three basic steps:

• Creation of a temporary schema
• Importing model store to temporary schema
• Applying the model store

Let's Start!

• Creation of a temporary schema

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

Steps:
1. Open SSMS (SQL Server Management Studio) (Press the Windows Key + R, Run will open Type SSMS and enter)
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 (TempoSchema) and select the schema owner and click "OK"
6. Initialize the temporary schema

For Initialize the temporary schema Use the command below:

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

• Importing model store to temporary schema

Import model store to temporary schema

Syntax: Import-AXModelStore -File <filename> -TempoSchema

Example:
Import-AXModelStore -File “C:\AX\AX_ModelStores\AXModelStore.axmodelstore” -SchemaName “TempoSchema” –IdConflict overwrite -Config MicrosoftDynamicsAX -Details

• Applying the model store

Apply the model store like this 

Import-AXModelStore -Apply:TempoSchema -Config MicrosoftDynamicsAX -details

Happy DAXing! 

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit