Hello Everybody, I have installed the test data transfer tool for ax 2012 r3 and imported job and generated the metadata.xml. But after running the command prompt the following error is shown. Please let me know if I am missing anything.

C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)

dp.exe IMPORT “C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Tran
sfer Tool (Beta)” AXDB LOCAL\SQL2014

  1. Import to Production is not Supported with this tool.
  2. The import action truncates data in the table before importing.
  3. Target Tables that are not present in the source, are not touched by the impo
    rt.Please remember to look at these tables and clean data if necessary. The list
    of these tables will be generated at the end of the Import
    Please choose an action:
  4. enter y/Y if you understand and agree to continue with Import.
  5. enter l/L to abort and open license terms.
    3.enter any key to abort
    Direction: Import
    Database : AXDB
    The list of target Tables Untouched by the Import is saved in C:\Program Files (
    x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)\ImportUnotuchedTa
    Truncate table statements for these tables are saved in C:\Program Files (x86)\M
    icrosoft Dynamics AX 2012 Test Data Transfer Tool (Beta)\ImportUntouchedTables.s
    ql Examine and use this file to truncate the data in these tables
    Log file: C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer T
    ool (Beta)\DPLog.xml


What’s the error? I would think it’s all just informative.
Anyway, you should be able to find details in those files (ImportUnotuchedTables.txt, ImportUntouchedTables.sql, DPLog.xml).

DPLog.xml is empty and the ImportUnotuchedTables file is having following information in first six lines

ACCOUNTANT_BR \ Missing in Source

I still don’t see any error. This message just says that the target environment has some extra tables.

But data is not imported into AX. what could be the issue ?

Why didn’t you said that before, instead of talking about some error message? We wouldn’t have to waste time with unrelated topics.

Are you sure that the data isn’t there? Maybe you’re in a wrong company or partition. Try checking it in SQL Server Management Studio.

Did you see information about progress during the import? It should show the number of processed tables.

It didn’t show any progress and number of processed tables and even the databases in sql server is not having data.

It’s weird. Does the folder contain any data for import?

The import folder under Microsoft Dynamics AX 2012 Test Data Transfer Tool is having only readme.txt file whereas Lists folder is having metadata.xml which i copied from temp folder. Can you let me know which file will have data?

Well, if you don’t have data, there is nothing to import.
What are you trying to import? Where did (not) you get it?

I have installed the Microsoft Dynamics AX 2012 Test Data Transfer Tool and followed the procedure mentioned at…/. Is the data file installed by tool or I have to download from any link.

The tool doesn’t contain data from any AX database. That wouldn’t make any sense.

You either export data from one of your environments, or you can download demo data prepared by Microsoft, depending on what you’re trying to achieve.