This blog contains posts by the Microsoft Dynamics AX Support Teams Worldwide

New import/export tool and updated guidance!

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.

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

I found on of the causes of the “No databases found” issue, that some of us are experiencing. The migration tool only searches for the databases with sid != 0x01 (to leave out all system databases). But by doing that, it also leaves out all databases with “sa” owner.

Hello
I spent so much time using the syntax
dp.exe import C:\local\MicrosoftDynamicsAXR3DemoData Microsoft\DynamicsAX
I was getting mad and backspaced the server/instance name and hit the enter button and it started to work, go figure
So it looks like all you need is the path where the demodata is and the name of the database