Video Screencast Help
Endpoint Management Community Blog

Script Database Changes Using OSQL

Created: 25 Jun 2008
CondorMan's picture
+1 1 Vote
Login to vote

OSQL is a flexible command-line utility that allows you to run SQL Queries, Commands, and Stored Procedures from the command-line or through a Batch script.

In order to run OSQL, you can either run it on your SQL Server or copy OSQL.EXE and osql.rll to a location that a client machine can run them from.

The syntax for OSQL is:

usage: osql       [-U login id]     [-P password]
 [-S server]      [-H hostname]     [-E trusted connection]
 [-d use database name] [-l login timeout]   [-t query timeout]
 [-h headers]      [-s colseparator]   [-w columnwidth]
 [-a packetsize]    [-e echo input]    [-I Enable Quoted Identifiers]
 [-L list servers]   [-c cmdend]      [-D ODBC DSN name]
 [-q "cmdline query"]  [-Q "cmdline query" and exit]
 [-n remove numbering] [-m errorlevel]
 [-r msgs to stderr]  [-V severitylevel]
 [-i inputfile]     [-o outputfile]
 [-p print statistics] [-b On error batch abort]
 [-X[1] disable commands [and exit with warning]]
 [-O use Old ISQL behavior disables the following]
   <EOF> batch processing
   Auto console width scaling
   Wide messages
   default errorlevel is -1 vs 1
 [-? show syntax summary]