Question Status

Suggested Answer
Kk AA asked a question on 27 Apr 2012 11:25 PM

Dear All,

i have worked on a dynamics ax 2012 testing environment, and i finished setting up the parameters and basic data, now i want to import the whole testing environment as is into a fresh copy to be used as live company, i tried to do this by creating a new legal entity but i got some errors while exporting and importing, any ideas with some screen shots ??

 

Reply
Hardik responded on 26 Mar 2013 6:37 AM

can you suggest any answer

Reply
Andreas Rudischhauser responded on 26 Mar 2013 8:20 AM

Hi,

this is not that easy. You might try the export / import framework (formerly know as data migration framework).

blogs.msdn.com/.../microsoft-dynamics-ax-2012-data-import-export-framework-old-name-data-migration-framework-is-now-available-on-information-source.aspx

Reply
Suggested Answer
Steven Weaver responded on 26 Mar 2013 11:18 AM

I would suggest creating a specific definition group.

We are fairly deep into AX2012 now so there are lots of interpretations of how to do this out there. This is one, but given with a complete disclaimer, I have not done it myself, have a look around to get a feel:

blogs.bojensen.eu

There is also DMF Beta 2 now that will also enable this I believe.

Steve Weaver | Dynamics AX Solution Architect - UK | My Blog

This forum post is my own opinion and does not necessarily reflect the opinion or view of my employer, Microsoft, its employees, or other MVPs.

Reply
André Arnaud de Calavon responded on 26 Mar 2013 3:01 PM

With the Data Import/Export Framework as mentioned in the comment of AndiRudi it is possible to achieve. You have to create new entities for all setup that is not supported out of the box.

The option like mentioned in the post of Weaveriski is also possible, but many tables in AX2012 are record-id related. This might sometimes have some problems. This option is faster than creating new entities in the data import/export framework.If you plan multiple copy actions or like to test setup in a test environment and want to "merge" the setup later the Data Import/Export Framework is also suitable for this.

kind regards,

André Arnaud de Calavon  |  Microsoft Dynamics AX Solution architect  |  My blog  |  My company

This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.

Reply
Suggested Answer
Søren Rasmussen responded on 27 Mar 2013 6:15 AM

Since you want all data copied you could use a backup/restore strategy to make a copy of the databases and point your live AOS to the new DBs.

Reply
MBrown1185 responded on 29 Mar 2013 12:05 AM

Hi,

My 2 Cents:  It is always risky to copy setup tables from one instance of AX to another. AX 2012 is quite complex, with super-normalized tables. A single mistake / glitch can put you into serious trouble. Especially if you discover the issue a month after starting transactions, when it will be impossible to either roll back or to fix the data.

A better option is to do the setup directly on Production environment first and restrict user access. Then, restore a copy of production database to test environment. There, you can create some master and transaction entries for testing. Once you are satisfied with the setup, you can open it to users.

Since, you have already done the setup once on test environment, you can copy data in two stages:

1) Copy all the Parameters & setup (including small masters) manually.

2) Import Masters using Microsoft Data Import / Export Framework (you should test it first)

Best Regards,

Michael Brown

Reply
Suggested Answer
Steven Weaver responded on 26 Mar 2013 11:18 AM

I would suggest creating a specific definition group.

We are fairly deep into AX2012 now so there are lots of interpretations of how to do this out there. This is one, but given with a complete disclaimer, I have not done it myself, have a look around to get a feel:

blogs.bojensen.eu

There is also DMF Beta 2 now that will also enable this I believe.

Steve Weaver | Dynamics AX Solution Architect - UK | My Blog

This forum post is my own opinion and does not necessarily reflect the opinion or view of my employer, Microsoft, its employees, or other MVPs.

Reply
Suggested Answer
Søren Rasmussen responded on 27 Mar 2013 6:15 AM

Since you want all data copied you could use a backup/restore strategy to make a copy of the databases and point your live AOS to the new DBs.

Reply