Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

AX 2012 R3. Copy application to an emtpy database.

Posted on by 2,983

We have this AX 2012 R3 environment where we've installed a lot of hotfixes and developed many customizations in VAR and USR layer.

Now, we would like to take this exact application, into an empty database. Normally, what I've done so far is install AX from installation media, apply hotfixes and export the VAR and USR models using "Export-AXModel" Powershell tool and import it in my new environment.

 

But now, we've lost sight of all the hotfixes we installed, and the model list shown by "Get-Axmodel" is very large, so its not an option to use "Export-AXModel" for each model in the database.

 

¿What would be the best way to make an exact copy of the application? 

*This post is locked for comments

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    RE: AX 2012 R3. Copy application to an emtpy database.

    As you have Install-AXModel for individual models, you have Import-AXModelStore for the complete model store database.

  • Suggested answer
    syed baber Profile Picture
    syed baber 11,627 on at
    RE: AX 2012 R3. Copy application to an emtpy database.

    So its look so simple, just copy the database MyDevApp_model to MyProdApp_model i.e. restore MyProdApp_model database with MyDevApp_model. This will copy the whole model store into MyProdApp_model database.

    Please let me know if you have further queries.

    Thanks,

    Baber.

  • Ghetz Profile Picture
    Ghetz 2,983 on at
    RE: AX 2012 R3. Copy application to an emtpy database.

    Thanks for the answer, I will try to explain myself better.

    I have an AX instance with 2 databases: MyDevApp and MyDevApp_model

    I want to setup a new instance with MyProdApp and MyProdApp_model.

    I need MyProdApp to be empty so I can create a new company and start creating data. And I need to copy all the models in MyDevApp_model into MyProdApp_model so that both applications are the same.

    As there are more than 400 models in the MyDevApp_model, I need a faster way to copy the application.

  • Suggested answer
    syed baber Profile Picture
    syed baber 11,627 on at
    RE: AX 2012 R3. Copy application to an emtpy database.

    Hi Ghetz,

    AX 2012 R3 needs two databases i.e. business and model database. So you need two databases basically. You cannot just copy the model database to the empty database and run AX. Do you want to use that empty database for another AX environment? I assume it is the case, so you need to have two databases and then you need to run AX setup and point to that database.

    Please confirm what you are after and then I will let you know what you need to do.

    Thanks,

    Baber.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans