Import Contoso Data Using Test Data Transfer Tool(Beta)

Pre-requisites:
1-      Download the test data transfer tool from the below mentioned link.
https://informationsource.dynamics.com//RFPServicesOnline/Rfpservicesonline.aspx?ToolDocName=Microsoft+Dynamics+AX+2012+Test+Data+Transfer+Tool+(Beta)+-+Updated+7th+Jan+2014%7cQJ4JEM76642V-8-1465

2-      Download demo data for AX2012 R3 from partner source site.

Steps: 

• Extract the demo data files from DynamicsAX2012R3DemoData.exe to a specific location.

• The output folder will contain the files of following extension types:

1. .OUT—– data file that contains metadata for AX transactional database
2. .OutModel —- data file that contain metadata for AX model database
3. .XML —- data file that contains AX table data.

•  Run the Test Data Transfer Tool.Exe file to install the utility.

 

• After successful installation, the folder will look like as shown below:

• Open AX client and import the .XPO named (MetaDataXMLGenerator.Xpo)

 

• On successful import a job will be created as shown below:

• Run the job <MetadataXMLGenerator(usr)>, a  meta data file will be generated and the path will be displayed in the infolog as shown in the snapshot below:

 

• Copy the metadata file from the above path and paste it in [lists] folder (where Test Data Transfer Tool has been extracted). If the file already exists, then overwrite the file.

• Stop MS Dynamics AX service.
• Open command prompt using administrator and navigate to the path where the Test Data Transfer Tool is extracted).
• Run the following command:

Dp.exe Import “C:\R3DemoData\DynamicsAXR3DemoData” DynamicsAXR3
C:\R3DemoData\DynamicsAXR3DemoData—— update the path accordingly
DynamicsAXR3—— provide the actual database name.

If you are multiple instances of a database server then use below,
Dp.exe Import “C:\R3DemoData\DynamicsAXR3DemoData” DynamicsAXR3 “DatabaseServerName\InstanceName”


If we enter ‘Y’, then following screen will open up describing the count for importing the table data and Error (if they come up)

 

• The process may prolong depending upon machine configuration.
• On successful import, Open AX client and data will show up.