Running a .sql script w/o SQL Query Analyzer

• lleone

  Old Hand

  Points: 375

  More actions

  October 13, 2003 at 8:02 am

  #83131

  Help! I am new to SQL and am trying to use a script that will create tables, etc.. I have an instance of SQL on my desktop, but I don't have SQL Query Analyzer. I did find the osql utility. Is there anyway I can run the script or download a utility that will allow me to run it? It's quite long, so an automated way would be preferred. Thanks!

• joachim.verhagen

  Hall of Fame

  Points: 3560

  More actions

  October 13, 2003 at 8:31 am

  #478009

  osql will do fine

  Run it on the command line.

  osql -? will give options.

  If your login user has sufficient permissions on SQLServer the following should work:

  osql -E -d database-name -i script-name -o outputfile