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
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.
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
Thanks for the knowledge.
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.
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.
#1
André Arnaud de Cal...
294,261
Super User 2025 Season 1
#2
Martin Dráb
233,013
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
