AX Database - Execute SQL Executes a sql script on a Microsoft Dynamics AX 2009/2012 database

AX Database - Execute SQL
AX Database - Execute SQL
Topic Work with AX database (AX 2009/2012)
Description Executes a sql script on a Microsoft Dynamics AX 2009/2012 database
Category Utility
Special features
  • Execute inline sql statement
  • Execute sql script file
Microsoft documentation
Parameter: Server config file path (.axc)
Description The file path to of the server configuration file.
Type File path
Required True
Default value
Example value $/Microsoft Dynamics AX (Test)/Server.axc
Parameter: Script type
Description Do you want to execute a inline statement or sql script file? Possible values are "Inline", or "File".
Type Picklist
Required True
Default value Inline
Parameter: SQL statement
Description The sql statement to execute.
Type Multiline
Required True
Default value
Dependency Only visible if Script type is "Inline"
Example value DELETE FROM dbo.SysLastValue
Parameter: Sql script file (*.sql)
Description The file path of the sql script. (*.sql)
Type File path
Required True
Default value
Dependency Only visible if Script type is "File"
Example value $/Microsoft Dynamics AX (Test)/MySqlScript.sql
Parameter: Max wait time (min)
Description The number of minutes to wait before failing the step.
Type Integer
Required False
Default value 120

Go back