Test Data Transfer Tool - TDTT is unable to transfer memo fields

we recently had problems transfering test data from a test to a dev environment using the test data transfer tool. After some research we figured out that the problem occurs when transfering tables that contain memo fields.

the error log is always showing the following BCP Error: "Warning: BCP Import with a format file will convert empty strings in delimited columns to NULL"

Error = [Microsoft][SQL Server Native Client 11.0] Warnung: Beim BCP-Import mit einer Formatdatei werden leere Zeichenfolgen in durch Trennzeichen getrennten Spalten in NULL konvertiert.
After some discussions with Microsoft the actual Statement is that TDTT is still beta and right now it is not supported to transfer tables with Memo fields containing NULL Values.

So we transfered These tables manually with some SQL commands and requested MS to add this functionality in the final Version of the Test Data Transfer Tool.

Please vote for this request on the connect platform:  https://connect.microsoft.com/dynamicssuggestions/feedbackdetail/view/957734

TDTT - Test Data Transfer Tool - Part 2

To just exprot some tables from AX 2012 navigate to the [lists] folder of the test data transfer tool and open one of the exclude files. Add the following regular expression

.*(?<!^InventTable)

This will exclude all tables except the one defined wthin the brackets. If you want to add more tables just add them in the following way

.*(?<!^InventTable)(?<!^VendTable)(?<!^CustTable)

or use regular expresseions within the brackets

.*(?<!^SysVersion.*)

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"