Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Running SQL script in ...
Finance forum
Suggested answer

Running SQL script in production instance

Posted on by 165

Hi

If a user wants to update field value in production instance how he can do that ?

Suppose I want to update the value of accounting date in po header through back end in production how can I do that ?

Since the change management is disabled for the po and system is not allowing to update the value by editing the po .

User wants to confirm the po but since the accounting date is missing it is throwing error and not allowing to update the po .

  • Carlos L Profile Picture
    Carlos L 2 on at
    Running SQL script in production instance
    Now it's possible to run a executable class on producction with zero downtime.
     
  • Suggested answer
    Sheikh Sohail Profile Picture
    Sheikh Sohail 6,125 on at
    RE: Running SQL script in production instance

    There are two options.

    1st Option:

    Write SQL script and execute on multiple environment for verification, After verification create ICM with Microsoft They will execute the script on your behalf after some verification and documentation.

    2nd Option:

    Write rurnable job and deploy on production and execute like AX2012

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: Running SQL script in production instance

    You would deploy it like any other code that you write. So you would not use request type Other.

    1) Develop in Visual Studio

    2) Check in version control

    3) Build a deployable package

    4) Upload to Asset library

    5) Deploy to test

    6) Deploy to prod (request deployment from the DSE team)

    This blog describes how to use SysClassRunner to run runnable classes in your environment: blogs.msdn.microsoft.com/.../ax7-systablebrowser-sysclassrunner

  • ASHISH ANAND Profile Picture
    ASHISH ANAND 165 on at
    RE: Running SQL script in production instance

    Hi Nikolaos

    So the runnable class u are saying we have to make it as software deployable package ,then store it to asset library ,then raise a service request for new sdp deployment or package deployment .is this the correct way ?

    So the runnable class we have to create in Dev environment then run it there ,test and validate it ,then create a deployment package with the runnable class and then I need to upload it to asset library and request DSE team for package deployment by raising a service request of type other .

    Can you please share the link or explain in detail ?

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: Running SQL script in production instance

    You can deploy runnable classes in production and run them. That would be the equivalent of AOT jobs in earlier AX versions.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans