Question Status

Suggested Answer
AX2012AX asked a question on 9 Nov 2011 2:14 AM

After the duplicate company feature was abolished in AX 2012 I'm having difficulties finding a proper replacement feature. I am currently working in different environments and need to transfer a "template company" from my test-environment, I have been experimenting with the export/import function but have not been able to find a solution that works well enough, it may be because I'm having difficulties finding the right combination when I'm configuring the definition group.

 

Any ideas on how I can duplicate a company in the best possible way in AX 2012? 

Reply
Suggested Answer
Dirk Spicker responded on 28 Jun 2012 9:44 AM

Hi,

we are running in the same troubles with AX 2012. We are transfering the whole datebase from source to target enviroment (With SQL server backup and restore).

But there are some issues:

- If you transfer the database, you transfer the application. You can export the model, make the database update and import the model in the target enviroment (not needed with same app).

- After the dump, you have to change the specific enviroment parameters (Reporting Server, Help Server, EP, perhaps some folder references). I wrote a script for these parameters, so it is easy to repeat the dump.

Regards, Dirk

Reply
Suggested Answer
Steven Weaver responded on 28 Jun 2012 11:15 PM

The whole environment management policy is now down to SQL backup's and restores. We have looked into writing our own duplicate company as well as exploring the import/export but with the new data structure you encounter issues at every turn. Now it is all about management, the old days of a simple import/export or duplicate have gone, putting it into the realms of SQL backups and restores.

Definition groups with avoidance of shared tables is also an option.

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
EKCDynamics responded on 27 Jun 2012 3:34 PM

Has anyone found a systematic approach to duplicate a company in AX 2012?

Reply
Suggested Answer
Dirk Spicker responded on 28 Jun 2012 9:44 AM

Hi,

we are running in the same troubles with AX 2012. We are transfering the whole datebase from source to target enviroment (With SQL server backup and restore).

But there are some issues:

- If you transfer the database, you transfer the application. You can export the model, make the database update and import the model in the target enviroment (not needed with same app).

- After the dump, you have to change the specific enviroment parameters (Reporting Server, Help Server, EP, perhaps some folder references). I wrote a script for these parameters, so it is easy to repeat the dump.

Regards, Dirk

Reply
Dirk Spicker responded on 28 Jun 2012 9:58 AM

... we tried other possibilities:

Data export and import in AX 2012 was nonsatisfying caused by the new data model.

We sometimes used testing and prod companys in the same AX 2009 system. In AX 2012 we strictly isolate the enviroments. All caused by the new data model.

Reply
EKCDynamics responded on 28 Jun 2012 10:07 AM

what do you mean by "export the model"?

I also tried the Data expor/import and had unsatisfying results.

Reply
Dirk Spicker responded on 28 Jun 2012 1:12 PM

AX 2012 uses layer and models (e.g. VAR model) for application objects. If you transfer the database from source to target enviroment, you have to save your customizations at first. E.g. you can export the VAR model, restore the database from the source system in the target system and import the VAR model. (only needed if source and target app are different.)

Reply
Suggested Answer
Steven Weaver responded on 28 Jun 2012 11:15 PM

The whole environment management policy is now down to SQL backup's and restores. We have looked into writing our own duplicate company as well as exploring the import/export but with the new data structure you encounter issues at every turn. Now it is all about management, the old days of a simple import/export or duplicate have gone, putting it into the realms of SQL backups and restores.

Definition groups with avoidance of shared tables is also an option.

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