batch compilation of sql scripts

• dchris2k

  SSC-Addicted

  Points: 493

  More actions

  October 9, 2002 at 8:43 am

  #58044

  All,

  We have a whole bunch of .sql scripts for the stored procedures and triggers. I am wondering is there any easy way to compile these scripts as a batch or like a make, instead of opening each file in Query analyzer and compiling.

  Thanks in advance.

• Klaas-Jan

  SSCrazy

  Points: 2297

  More actions

  October 9, 2002 at 9:03 am

  #438168

  Hi,

  open a command window, go to the directory with the files and type

  copy *.* > sqlfile.txt

  The file sqlfile.txt is created with all the code in it.

  regards,

  Klaas-Jan

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  October 9, 2002 at 9:28 am

  #438172

  You can create a .BAT-file that executes them all using osql.

  --

  Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

  http://www.sql.nu

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/