News and Announcements icon

Dynamics 365 CommunityForums Finance forum Execute a SQL script i...

Finance forum

Execute a SQL script in PROD

(0) Share

Report

Report

Posted on by Adrian Pascari A

1,683

It is possible to execute a sql script in AxDB in Production ?

The installation package has a file what seems to run the script 'ExecuteSqlAXDB'.

Anybody knows if this file can be used to execute a SQL Script?

Categories:

Development / Customization / SDK

All responses Img

All responses (3)

Answers Img

Answers (1)

Suggested answer

Anton Venter 19,593 Super User 2025 Season 1 on at

Like (0)

Report

Execute a SQL script in PROD

Hello,

No they don't help with creating SQL scripts, that is not their role. As an alternative (to executing a SQL script in production) you can create and execute your own custom scripts in production, see link below.

Run custom X++ scripts with zero downtime

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/deployment/run-custom-scripts

By the way, next time just create a new post instead of replying to a post from 2018 ;-).
CU01052230-0 on at

Like (0)

Report

Execute a SQL script in PROD

I just started working with D365 F&O. Does contacting Microsoft support help write SQL scripts for invoices—unpaid/paid, open invoices?
Verified answer

André Arnaud de Cal... 294,060 Super User 2025 Season 1 on at

Like (1)

Report

RE: D365 execute a SQL script in PROD

Hi Adrian,

If you need to run a script, contact Microsoft Support to have it executed. Don't experiment with unsupported ways of getting it done. We had some issues at a customer where we worked together with Microsoft to have scripts executed.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,060 Super User 2025 Season 1

#2

Martin Dráb 232,858 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans