Open Forum

Expand all | Collapse all

#UATtoGoLive #RemoveTestTransactionsandData #TestDBtoLiveDB

  • 1.  #UATtoGoLive #RemoveTestTransactionsandData #TestDBtoLiveDB

    Posted Nov 18, 2019 03:38 AM
    Hello,

    Appreciate to guide me on the following query

    Which is the best practice to remove all the test transactions and keep the setup prior to moving Go-Live ?

    I have to keep all the setup & configurations in my DB for the company as done in UAT and need to remove all the test transaction data from the same. How this can be achieved in Microsoft Dynamics NAV 2016? Looking for an easy and best practice for UAT DB to Go-Live DB without any test data / transactions / values. 

    Appreciate your valuable advice,

    Best Regards


    ------------------------------
    Ranjith E S
    Functional Consultant
    SFO
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: #UATtoGoLive #RemoveTestTransactionsandData #TestDBtoLiveDB

    SILVER CONTRIBUTOR
    Posted Nov 18, 2019 01:14 PM
    Best practice is to not transact in the go live company at all prior to go live. After initial setups copy the go live company to UAT - and for every change you make in UAT (setup wise) replicate it to the go live company as well.
    There is not official tool for removing all of the transactional data (we had a one a few years back but abandoned it) you run the risk of missing a table of data with these tools and causing harm to the live system.
    If you run a mock go live after UAT you would start with a copy of go live and it would become apparent if you've forgot to duplicate setups from UAT to live

    ------------------------------
    Rick Tweedle
    BC/NAV Dev Manager
    Columbus Global
    Temecula CA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: #UATtoGoLive #RemoveTestTransactionsandData #TestDBtoLiveDB

    Posted Nov 19, 2019 12:51 AM
    Thanks Rick Tweedle for your valuable comment.

    Best Regards,


    ------------------------------
    Ranjith E S
    Functional Consultant
    SFO
    ------------------------------

    Academy - Online Interactive Learning from Experts


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