axapta - What is the best way to migrate or export/import data from Microsoft AX4 to AX7 -

on 1 side have working ax4 environment , want upgrade new ax7.

therefore need tables of database imported or migrated new one.

what best way achieve that?

there no direct upgrade path ax4 ax7 (afaik), nor there way directly move objects.

how many objects need migrated? you're left 2 options.

1. xpo objects ax 2012 staging environment, upload ax 2012 modelstore lcs , migrate code , create migration project in ax7 (see https://ax.help.dynamics.com/en/wiki/upg101-preparing-for-migration/)

2. recreate objects hand :(

a little more detail on (1.) in ax 2012, instead of code being stored on disk in bunch of layer files, it's stored in separate sql database. , modelstore conceptually *.bak file of database. when import xpo ax 4.0 cus layer, ends in axcus.aod; likewise when import xpo in ax 2012, ends in modelstore in cus layer.

to uplift code in ax7 ax12, take *.modelstore file , .zip (compress) , upload on lcs.dynamics.com. must connect lcs vso (visual studio online), because creates tasks , things do.

you wait while (usually hour, i've had take 1-2 days when changing framework), have objects in vso , can sync them ax7 environment.

edit: regarding data ax 4.0...i'm not yet expert on getting data ax7 push data entities, abstraction of parts of database. if it's one-time data moves, can possibly use excel data connector.

see these resource:

• http://msdax7.blogspot.com/2016/02/open-to-excel-in-microsoft-dynamics-ax.html
• http://msdax7.blogspot.com/2016/02/exportimport-data-using-data-management.html
• https://ax.help.dynamics.com/en/wiki/data-entities/