Export SQL Script

 

The Export SQL Script tool writes the current DMS internal SQL script to a file called SQLScript.txt in the DMS \Export folder. 

 

Sometimes IT or other personal may wish to see what the SQL script code is to populate the Mfg Orders Job Grid in order to write a similar script in a third party tool.

 

In Mfg Orders Job Grid, select Grid Tools | Export SQL Script.  The following window is displayed:

 

 

Select Yes to export the SQL script.  Select No to cancel the command.

 

Note that the SQL scripts built by DMS do not use the DMS SQL Views and instead use the database tables.  The reason why the Views are not used is to enable the user to edit the data in the Job Grid as views cannot be edited.  For reporting purposes, developers will probably want to use the DMS views instead of the DMS tables.