X++ custom script

(1) Share

Report

Posted on by GhulamRasool

Hi,

I’d like to get an official clarification from Microsoft regarding a critical question that doesn’t seem to be explicitly documented anywhere.

Is it permitted to execute SQL kernel-level code within an X++ custom script deployable package for minor data correction activities in a Production environment?

I understand this approach is not recommended, but in some scenarios, converting the logic to pure X++ AOT objects results in significant performance degradation—particularly when temporary tables cannot be used (as they exist only within the original model). In such cases, a well-written and optimized SQL script can perform the operation far more efficiently.

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

Could you please confirm Microsoft’s official stance on this?

Thank you,
Ghulam Rasool

Categories:

Microsoft Dynamics AX

I have the same question (0)

All responses (1)

Answers (0)

Sohaib Cheema 49,053 User Group Leader on at

Like (0)

Report

X++ custom script

Hi,

SQL execution is not recommended in general because one can damage the system data integrity for some of the following reasons.

1) it skips table AOS methods.

2) it skips the Delete Actions and other validation checks

3) it skips any associated events, methods, x++ logic and everything and leads to direct SQL execution.

People have made UI that directly executes the SQL queries on production, however that comes with the risk, as Microsoft does not support any issue occurred out of such executions.

Is this some update that you want to perform in standard tables or are these any custom tables where you want to update the records? What is your business scenario.

Was this reply helpful? Yes No