Running all sql scripts in folder from bat file

• justin-976626

  SSC Journeyman

  Points: 97

  More actions

  April 28, 2009 at 10:33 am

  #208887

  Hi guys,

  I'm trying to create a bat or cmd file that can run all the sql scripts in a folder, which is very useful for my sprocs folder especially. If I run the following script from command line it works fine:

  FOR %f IN (*.sql) DO OSQL -U username -P password -S localhost -d databasename -n -m-1 -b -i "%f"

  But if I put it in a .bat or .cmd file then it blows up:

  f" was unexpected at this time.

  How do I fix this?

  Thanks!

  Justin

• Jetro

  Ten Centuries

  Points: 1257

  More actions

  April 28, 2009 at 12:33 pm

  #985383

  Hi,

  you need two percent signs for your variable. (%%f instead of %f)

  Hope this helps 🙂

  -----------------------
  SQL Server Database Copy Tool at Codeplex

• justin-976626

  SSC Journeyman

  Points: 97

  More actions

  April 28, 2009 at 2:03 pm

  #985461

  That did it, thank you sir!!