We are pleased to announce the release of the Microsoft Dynamics AX 2012 Test Data Transfer Tool (beta) on InformationSource!This command-line tool exports data from a Microsoft Dynamics AX 2012 business database, and imports it into a Microsoft Dynamics AX 2012 business database ina non-production environment. Internally, we’ve called this the Dataport tool, and we use it to move demo data into our test and dev environments.
We’re aware that this new tool is one of many that we’ve shipped for Microsoft Dynamics AX, and that some guidance about which tool to use for whatwould be helpful.
For that reason, we’ve significantly updated the topic Plan data import, export and migration. It now includes a very large table that describes which import/export tool is best suited to which business task, and then provides information that you can use to become familiar with the tools, and compare them.
I have installed the Test Data Transfer Tool, imported the XPO and generated the Metadata and put it in the LIST directory.
The user id I am using is an administrator and has sysadmin as well as owner permission of the AX database.
I am running the DP program on the database machine. I opened the CMD window as an administrator.
C:\DP>"C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)\dp.exe" EXPORT . AXTST2 .
Cannot access database AXTST2
No databases found
Is there an indication of what the problem is? I can run the BCP utility from the same window and have no issue in exporting a table from the database.
I've checked in with the tool owner. He says:
"The only time I’ve encountered this is when the DB name is given wrong. Please make sure the DB name is correct. If it is, there is something more that is not obvious – I need a screenshot of the command line and the DB in ssms, if possible."
If this doesn't help, please feel free to send me an email at margoc at microsoft.com.
Hi Margo !
I am also facing the same Issue regarding access to the database
when I am running this command as an administrator :
DP.exe EXPORT c:\test AX6xxx VELxxx\VELxxx
Error: cannot access the database AX6xxx but the database Name is correct. Similarly I have another database and I am able to run this command and able to Export the data perfectly .
what can be the Issue of not accessing database AX6xxx?
Waiting for your reply.
The tool owner asks if you can help us understand the following questions:
- Does the database have the “SysConfig” table?
- What is different on the other database where it worked? Is it the same server, but a different database, or was it a different server altogether?
If you can email me at firstname.lastname@example.org, the tool owner and I will be happy to continue to help you troubleshoot.
I am getting an error "A connection with the server="our server" cannot be established. Please check the Server is accessible. Where "our server" is the server it is running on... Please help
Could you please give us the exact command you used, with placeholder server and database names, not your real ones. We'd like to see if the usage and parameters passed are right.
Here are my experience with the DP.exe tool:
On the error “A connection with the server="ServerName" cannot be established. Please check the Server is accessible.
I used a / instead of a \ in the parameter “ServerName\InstanceName”. Yep – typo….
After that, I got the “Cannot access database “DbName”, No databases found”. On a newly created AX database (empty DB) you have to create the tables before you can make the import.