D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Automating Code and Data Refresh Environments in Dynamics AX 4.0/2009

  • 1.  Automating Code and Data Refresh Environments in Dynamics AX 4.0/2009

    Posted Apr 12, 2019 07:47 AM
    Is there any a tool or has anyone automated code and data refresh environments in AX 4.0/2009?

    Thank you


    ------------------------------
    Ahmad El-Masri
    New Process Steel
    Houston TX
    ------------------------------


  • 2.  RE: Automating Code and Data Refresh Environments in Dynamics AX 4.0/2009

    GOLD CONTRIBUTOR
    Posted Apr 12, 2019 10:22 AM

    Here at Dynamics Resources we specialize in Dynamics 365, all versions of AX, and CRM. I ran your question by one of my experts.

    Under Menu items > Action I. SysFlushAOD II. SysFlushData III. SysFlushDictionary
    There are three menu action items that can be used to flush system data, the AOD, and dictionary, but they are set to run at "called from" which when ran clear the client cache.
    It's possible to copy these three menu items, and then change the run from property to server.
    Once done this, launch these menu items, and they will run on the server, therefore clearing the AOD, sys data, and dictionary, causing a refresh.



    ------------------------------
    Michael Gonzalez
    Account Executive
    Dynamics Resources
    Venon Hills IL
    ------------------------------



  • 3.  RE: Automating Code and Data Refresh Environments in Dynamics AX 4.0/2009

    Posted Apr 15, 2019 03:28 PM
    Michael

    Thank you for your response. I meant refresh data & code from production to test environments.

    ------------------------------
    Ahmad El-Masri
    New Process Steel
    Houston TX
    ------------------------------



  • 4.  RE: Automating Code and Data Refresh Environments in Dynamics AX 4.0/2009

    SILVER CONTRIBUTOR
    Posted Apr 15, 2019 03:18 PM
    Please clarify - do you mean
    1) refresh the currently cached code/data in the live AOS servers
    2) refresh updated code from one AOS to other AOS servers
    3) refresh data & code from live to test environments


    The prior response gave you an answer for #1.

    I've made my own a solution for #3 (on AX2009) -  a combination of Idera virtual database (using database backups as the writable database) and powershell for the primary scripts, and TSQL scripts for changing settings from live to test.
    You can use native SQL backups, but Idera's compression is far better than native - important for copying the backup files across network & mounting the file as database.
    Message me here on AXUG if you want more info on this solution.

    ------------------------------
    Tony Malarz
    ERP Architect; Sr. Database Analyst
    Nortek Air Management
    MN
    ------------------------------



  • 5.  RE: Automating Code and Data Refresh Environments in Dynamics AX 4.0/2009

    Posted Apr 15, 2019 03:27 PM
    I meant refresh data & code from live to test environments.  Thank you for your response.

    ------------------------------
    Ahmad El-Masri
    New Process Steel
    Houston TX
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role