Ax 2012 R3 demo data & Test data Transfer Tool download

Ax 2012 R3 demo data & Test data Transfer Tool download

The contoso demo data for Dynamics Ax 2012 R3 is different from previous version.we used .dat file to load demo data in previous versions. Demo data is available in .exe file.
i.e DynamicsAX2012R3DemoData.exe available in partner Resource.

 Download Ax 2012 R3 demo data


To import this demo data we need  Test Data transfer Tool is available on partner resource.

Go on following link

Test Data Transfer Tool download

To import demo data we need to do the following steps.

Step 1:

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

Step 2:

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

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

Step 3 :

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

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

Step 4:

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

Step 5:

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.

Step 6 :

Stop MS Dynamics AX service.

Step 7 :

Open command prompt using administrator and navigate to the path where the Test Data Transfer Tool is extracted).

Step 8:

• Run the following command:

Dp.exe Import “C:\R3DemoData\DynamicsAXR3DemoData” DynamicsAXR3

C:\R3DemoData\DynamicsAXR3DemoData—— update the path (Demo Data extraced path)

DynamicsAXR3—— provide the actual database name.(Ax DB Name)

In case of 3 tier environment, you will get the following screen.

[Server] always looking for current machine.if DB in another server follow step 9. 

Step 9 : you need to install Test data transfer tool on SQL server and run DP command on same server. 

in case of standalone you will get the following screen.

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.

-----------------------------------------------------------------------

Note: Some time system will show below error

“Unhandled Exception: System.UnauthorizedAccessException: Access to the path ‘C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)\DP Log.xml’ is denied.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, I
nt32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions o
ptions, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolea
n useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access,
FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean
bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access,
FileShare share, Int32 bufferSize, Boolean useAsync)
at System.Xml.XmlWriterSettings.CreateWriter(String outputFileName)
at System.Xml.Linq.XDocument.Save(String fileName, SaveOptions options)
at DP.Program.Execute(String currentDirectory, DataportDirection direction, S
tring directory, String database, String server, DataportAction action) in e:\bt
\110700\Source\DataPort\DP\Program.cs:line 182
at DP.Program.Main(String[] args) in e:\bt\110700\Source\DataPort\DP\Program.
cs:line 82

If you are facing the same error than try to run following command (Its same command as above without “ ”)

DP.exe IMPORT C:\AXR3DemoData AX2012R3DB

Now it will work J

As next, Below window will open

Here you done your part, now wait to complete this operation and open your AX client.