Re: Multiple batch files

2009-03-19 Thread David Scott
by AT&T > > -Original Message- > From: David Scott > > Date: Thu, 19 Mar 2009 11:16:03 > To: > Cc: > Subject: Re: Multiple batch files > > > Thanks for responding Gary > I get: > > --- > Volume in drive D has

Re: Multiple batch files

2009-03-19 Thread Andy Shellam
; Call batch file Sent via BlackBerry by AT&T -Original Message- From: David Scott Date: Thu, 19 Mar 2009 11:08:28 To: Subject: Multiple batch files HeyaI have folders of sql files which, when there were a few, I executed using "source d:\folder\file.sql"I now I have

Re: Multiple batch files

2009-03-19 Thread David Scott
> Dir *.sql > my.bat > > Edit batch file for each line to append "| mysql" > > Call batch file > > > Sent via BlackBerry by AT&T > > -Original Message- > From: David Scott > > Date: Thu, 19 Mar 2009 11:08:28 > To: > Subject: Mu

Multiple batch files

2009-03-19 Thread David Scott
HeyaI have folders of sql files which, when there were a few, I executed using "source d:\folder\file.sql"I now I have 100's, so is there a way to do "source d:\folder\*.sql" (which sadly does not work) ? How would you go about automating this? The DB is running on a windows box. Thanks for any