web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

DEPLOYMENT OF PRODUCTION DATA INTO TEST ENVIRONMENT

(1) ShareShare
ReportReport
Posted on by 166

Hi

I've recently joined an organization where no test environment exist for AX 2012 R3 built 6.3.164.0 (AX2012R3). I want to import production data into test environment. How to perform this act.

Regards,

Irshad

I have the same question (0)
  • Suggested answer
    YY Lim Profile Picture
    960 on at

    You need to install the same version for the test, then just restore the production data DB and model DB to the test environment will do, you will need to run script to clean up production related parameter too, file path, integration path and etc.

  • haidarmca Profile Picture
    25 on at

    Dear Irshad,

    First you install the Microsoft SQL Server compatible to Microsoft Dynamics AX 2012 R3 (In my environment using the Microsoft SQL Server 2014 Standard edition) then install the Application Object Server (AOS) . And after successful installation of AOS Server with their required prerequisite .Net framework , Finally install the client application.

    Click on the client application, if your installation mode of AOS Server and their setting will be in correct format then client application will open with Microsoft default entity (.dat) name.

    Note: Before going to restore database you have to make sure the 'MicrosoftDynamicsAX' database should be in 'Single user mode' and also  stop the AOS during the restoration time of DAX database.

    After successfully restoration of database , start the AOS Server.

    Before going to connect with your client application , first go to the 'System Administration' module . Go to Setup-> Checklists -> Initialization checklist.

    Once the 'Compilation application' and then 'Compile into .NET Framework CIL' will be complete also verify the rest of the application checklist.

    And finally connect with Microsoft Dynamics AX client application with AOS server.

    The Microsoft Client application will connect with AOS server with your entity and all modules of the production environment will appear with in your test environment.

    Hopefully it will help out to you.

  • Sayed Sufiyan kadiri Profile Picture
    5 on at

    Thanks for the knowledge.

  • Irshad Speaks Profile Picture
    166 on at

    Good Morning Mr. Haider,

    Following your instructions, I am in process of installing the virtual machine where I've installed SQL Server 2014 and now running the AX 2012 r3 setup where I've created a test db (TEST_DEV_TEST) and baseline as well. Installation is in process. Once it's done then shall post my further comments. Once again thanks a lot.

    Regards,

    Irshad

  • haidarmca Profile Picture
    25 on at

    Dear Irshad,

    No need to create a new 'test db' on the server (TEST_DEV_TEST), whenever you shall install the AOS, at the time of installation the AOS itself create 'MicrosoftDynamicsAX' database as well as 'MicrosoftDynamicsAX_model' in under your SQL instance.

    Note: No need to create any user database under the SQL instance.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 551 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans