Get in touch

AX Database - Execute SQL

Executes a sql script on a Microsoft Dynamics AX 2009/2012 database

TopicWork with AX database (AX 2009/2012)
CategoryUtility
Special features
  • Execute inline sql statement
  • Execute sql script file
Microsoft documentation

Parameters

ParameterTypeRequiredDefaultExample
Server config file path (.axc)The file path to of the server configuration file.File pathTrue—$/Microsoft Dynamics AX (Test)/Server.axc
Script typeDo you want to execute a inline statement or sql script file? Possible values are "Inline", or "File".PicklistTrueInline—
SQL statementThe sql statement to execute.Depends on: Only visible if Script type is "Inline"MultilineTrue—DELETE FROM dbo.SysLastValue
Sql script file (*.sql)The file path of the sql script. (*.sql)Depends on: Only visible if Script type is "File"File pathTrue—$/Microsoft Dynamics AX (Test)/MySqlScript.sql
Max wait time (min)The number of minutes to wait before failing the step.IntegerFalse120—