DTM Database Tools Home  

DTM ODBC SQL runner

Download free demo version right now!
How to buy DTM software?
 
DTM ODBC SQL runner icon

DTM ODBC SQL runner is a command line tool that alows the user to run SQL statements using specified ODBC data source (DSN). It is most suitable for batch and scheduled execution.
Download: 32 bit and 64 bit. No installation is required.

Usage:
sqlrun [optional params] [space delimited filenames]

Params:
-I[<config file name>]

  • by default uses sqlrun.ini in program directory.
  • empty arguments list means -I
  • '*' and '?' are acceptable in SQL file name
  • see config file format below

-H
(add column header to output file, for 32 bit version only).

-D<data source name>

-U<user name>

-P<password>

-O<standard output file name>

  • uses terminal output by default

-L<log file name>

  • uses terminal output by default

Important: command line parameter overwrites config file value.

Configuration File Format

[Connection]
DSN=<data source name>
User=<user name>
Password=<password>

[Settings]
Output=<standard output file name>
Errors=<uses terminal output by default>
Header=<0|1>

[Script]
File=<files specification>

DTM ODBC SQL runner screenshot
 
 

Copyright © 2004-2012 DTM soft. All rights reserved. Privacy policy.