call multiple .sql files through single Batch file

• challa.narasaiah

  Newbie

  Points: 7

  More actions

  December 13, 2012 at 8:25 pm

  #98378

  In my sqlserver project so many .sql files in different folders Like

  C:\username\EtlcontrolDB\scrip1.sql.........script10.sql C:\username\configuration\scrip1.sql.........script10.sql C:\username\Think...........................

  My client requirement is , above folders contained sql files execution through single batch script. and sql filenames and filepath input geting from .txt file and also C:\username this one will be different for each user,remains path is similor to all users, also i want to execute some folders fully and some folders specific sql files only

  Please any one share ideas about this requirement..... Thaks for advance...

• e4d4

  SSCertifiable

  Points: 5777

  More actions

  December 14, 2012 at 2:37 am

  #1568599

  .CMD files with for loops and execute sql script by using sqlcmd, or more current and more powerfull PowerShell.