Can osql.exe run as a standalone?

Question

I have a program that runs osql.exe from microsoft sql server tools directory and runs a script.

The problem is that on computers that don't have an installation of sql server, this tool is missing. So my question is whether or not is possible to run it as a standalone( along with any dll that may be required ) meaning that run them from Process.Start from a local directory of the application.

Matthew Farwell · Accepted Answer · 2011-12-07T07:50:27.700

1

Yes, you can. Just copy the binary and off you go.

edited Dec 07 '11 at 07:50

answered Nov 08 '08 at 19:37

Matthew Farwell

60,889
18
128
171

With SQL Server 2012 you need to also copy osql.rll, then it works. Default paths are `C:\Program Files\Microsoft SQL Server\120\Tools\Binn\OSQL.EXE` and `C:\Program Files\Microsoft SQL Server\120\Tools\Binn\Resources\1033\osql.rll`. – OutstandingBill Feb 25 '16 at 18:31

kͩeͣmͮpͥ ͩ · Answer 2 · 2016-02-26T14:23:43.917

0

Why are you spawning osql?

I've written simple programs to execute scripts using SMO - mostly insired by this post.

EDIT

The jist of the post is to use SQL Server Management Objects (SMO). Server.ConnectionContext.ExecuteNonQuery parses SQL with GO statements in it.

edited Feb 26 '16 at 14:23

answered Nov 06 '08 at 15:18

kͩeͣmͮpͥ ͩ

7,783
26
40

its an already written application(not by me), and i don't want to switch its way of running the script. – Kostas Konstantinidis Nov 06 '08 at 15:20
It's a nifty way to test the right ports are open between servers. – OutstandingBill Feb 25 '16 at 18:32

Can osql.exe run as a standalone?

2 Answers2

Linked