I need your help in determining the best and effective way to export data from one AX 2012 database to another. If anyone has done this and can shed some light, it would be greatly appreciated.
Here’s the background: We have two plain AX 2012 environments both running CU4 and both running on SQL 2008 R2. One of the environments contains data, transactions and a list of vendors. The other environment is a new install of AX and doesn’t have any data or transactions.
We need to export all the vendors from the environment with the transactions and import them to the new clean environment. I’ve heard that IDMF is the tool to use for this task but I also heard that it’s a timely process to set it up and get it running (I may be wrong).
The other method would be to get a list of all tables used/linked by the VendTable and copy the data through a SQL query or an AX job and insert it in the new environment. I’m a little hesitant to take this approach.
Has anyone done this? What tool do you recommend to use?
Thanks for any input!