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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Running SQL script in ...
Finance forum

Running SQL script in production instance

(0) ShareShare
ReportReport
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 .

I have the same question (0)
  • Carlos L Profile Picture
    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
    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
    101,160 Moderator 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
    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
    101,160 Moderator 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.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans