How to Create a batch file which runs sets of sql files on different database

• nehal2000

  Newbie

  Points: 7

  More actions

  October 30, 2009 at 6:39 am

  #213063

  I have say couple of sql files which needs to be executed on batch of database (variable).

  For sql files - i will keep this files in one local folder.

  For database (variable) - i will keep the information about dbs and their server in one txt file.

  Variable - Different databases from different servers.

  Now i want to create one batch file i.e *.bat which will execute 'sqlcmd' picking up *.sql files from folder and database information from the txt file.

  How can i achieve this ?

  Note: I would not like to use 'SET' command.