TDTT - Test Data Transfer Tool - Part1

The test data transfer tool is a good way to move test data from one environment to another. Always keep in mind that it transfers data from all companies. Always backup the target environment cause the import deletes all the records in tables that are part of the import.

The generall process is done in two steps. Export data from source environment and import data into target environment.

Export data from source environment

The procedure for exporting data consists of these general steps:

1. Generate a Metadata.xml file. (This can be done on every machine running an AX 2012 R2 Client)
1. Import the MetadataXMLGenerator.xpo into the environment where you want to export data from.
   
2. After the import is done open the aot and run the job. This will take some time. After two cups of coffee you'll get an infolog with the path where the Manifext.xml is stored.
3. Copy the generated Manifest.xml into the [Lists] folder of the test data transfer tool C:\Program Files(x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)\[Lists]
2. Determine which data to export (This must be done on the SQL Server)
   Check the Exclude….txt files to define what tables will be exported.
3.  Run the tool (This must be done on the SQL Server)
1. Open a command prompt.   
2. Change directory
   cd "c:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)
3. DP.exe Export E:\Temp\TDTT20140102 AX2012R2CU7_TEST
   DP.exe Export "folder" "db"
   This will also take 10 to 15 minutes depending on the performance of the SQL Server.

Import data into target Environment

1. Run the tool (This must be done on the SQL Server)
   1. Open a command prompt.   
   2. Change directory
      cd "c:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)
   3. DP.exe Import E:\Temp\TDTT20140102 AX2012R2CU7_DEV
      DP.exe Import "folder" "db"