ISQL vs. ISQLW vs. OSQL?

[TheDrider]

I'm running some simple DDL scripts against a few databases via command line. I see the different tools available but can't seem to find a decent article describing the differences between them.

Can anyone here describe the differences or point me in the right direction?

 

[gmmastros]

isqlw is the executable file name for query analyzer.
osql is the command line tool.



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[mrdenny]

osql is the more current command line tool for SQL 7 and SQL 2000. isql is the legacy tool from the SQL 6.x days.

If SQL 2005 isql goes away (as does isqlw). You should use osql so that your commands scale up to SQL 2005.

SQL 2005 introduces a new command time tool called SQLCMD to make things a little more confusing.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com