Can osql.exe run as a standalone?

Question

Hi,

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.

Answer 1

Why are you spawning osql?

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

Answer 2

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