Installing OSQL on SQL 2008

Question

Post reply

Installing OSQL on SQL 2008

SQLisAwe5oMe

SSChampion

Points: 14052
More actions
January 7, 2014 at 7:11 am

#302910

I have a requirement to install OSQL utility on an existing sql 2008 server.
Can OSQL be used as a stanalone utility? if so, how can I get it installed, not too familiar with this tool. Please share your experience. Thanks.
Regards,
SQLisAwe5oMe.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 1

I just read that "with SQL2005 osql and isql have been replaced with SQLCMD"....is this true? please advise.

Regards,
SQLisAwe5oMe.

george sibbald SSC Guru Points: 104210 More actions · Answer 2

SQLCMD did replace OSQL so you should use SQLCMD if you can. However OSQL should still be there if you have installed SQL2008

You would find it in c:\program files\microsoft SQl Server\100\tools\binn unless you specified somewhere else for you your shared tools directory.

If you did not install the client tools on the server you can get OSQL by rerunning the installer, selecting client tools (including COMPLETE SSMS).

Pretty sure you can download OSQL exe from the web as well but don't know for sure or where from at the moment

---------------------------------------------------------------------

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 3

george sibbald (1/7/2014)
SQLCMD did replace OSQL so you should use SQLCMD if you can. However OSQL should still be there if you have installed SQL2008
You would find it in c:\program files\microsoft SQl Server\100\tools\binn unless you specified somewhere else for you your shared tools directory.
If you did not install the client tools on the server you can get OSQL by rerunning the installer, selecting client tools (including COMPLETE SSMS).
Pretty sure you can download OSQL exe from the web as well but don't know for sure or where from at the moment

If SQLCMD replaced by OSQL, how would it will be available in the installer of 2008?

Regards,
SQLisAwe5oMe.

george sibbald SSC Guru Points: 104210 More actions · Answer 4

backward compatibility. I expect Microsoft used the term 'deprecated.'

Microsoft are giving you a chance to wean yourself off OSQL. expect it to disappear at some point. Its still in 2008R2.

Cannot find a download of just OSQL, only via a management studio download, so I expect you need to install client tools if its not already there.

---------------------------------------------------------------------

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 5

george sibbald (1/7/2014)
backward compatibility. I expect Microsoft used the term 'deprecated.'
Microsoft are giving you a chance to wean yourself off OSQL. expect it to disappear at some point. Its still in 2008R2.
Cannot find a download of just OSQL, only via a management studio download, so I expect you need to install client tools if its not already there.

ok, Thank you. Appreciate it.

Regards,
SQLisAwe5oMe.