Create Master script that calls other scripts files....

• Barkingdog

  SSCoach

  Points: 18670

  More actions

  October 15, 2007 at 8:50 am

  #70434

  I want to create a script, Master.sql, that looks something like this:

  ...

  Begin Transaction

  Execute ( c:\..\ .....\ file1.sql)

  Execute ( c:\..\ .....\ file2.sql)

  End Transaction

  But I can't figure out how to execute the "sql" files from the script.

  TIA,

  Barkingdog

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  October 15, 2007 at 8:55 am

  #742013

  use osql

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  October 15, 2007 at 9:02 am

  #742015

  I don't know how we can directly execute a script within another script?

  But here is, one of the ways which i used to execute a list of files from a batch file using osql utility..

  ECHO OFF

  CLS

  SET FilePath=C:\MySQLFiles\*.sql

  SET MyServer=NameOfTheServer

  SET MyLogin=LoginName

  SET MyPassword=Password

  SET MyDatabase=DefaultDB

  FOR %%i IN (%FilePath%) DO osql -S%MyServer% -U%MyLogin% -P%MyPassword% -d%MyDatabase% -i%%i -o%%i.log

  --Ramesh
  

  ---