Hello Deepak.
I've done exactly what you describe - check out the <foreach> task and
use it to loop over your SQL files, running each in turn.
My scripts have to be run in proper sequence, so I've numbered them.
Hope this helps,
Bevan.
________________________________
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Deepak
Surendran
Sent: Tuesday, 3 April 2007 8:29 p.m.
To: NANT Mailing List
Subject: [NAnt-users] Regarding DB Build Using NANT
Dear All,
We have automated the database build. The script will get the script
from VSS.Then i will execute the script if it is Table..it will update
in the table..if it is stored procedure...then ti will update the stored
procedure.
I am finding some problem while using SQLCMD command for execute the
script in my DB script folder in VSS...i have 10 DB script. But when the
nant script start execution it is not executing more than one script..i
have to enter the file name manually ....is there is any way to run the
enitre database scriipt at a time. So tht all my DB script will be
updated.....Please find the script
.5 <!-- Executing the Script and updating in SQL Database -->
<target name="Execute">
<exec failonerror="false" program="C:FilesSQL Server90.EXE" commandline
=' -i "${script}_solicitorContact_update.sql" -S "${server}" -d
"${database}"'/>
</target>
Regards,
Deepak S
******************************************************************************
"This message (and any files transmitted with it) are confidential and
may be legally privileged. If you are not the intended recipient please
notify the sender immediately and delete this message from your system.
This message does not necessarily reflect the views of the
Reserve Bank of New Zealand. If the recipient has any concerns about
the content of this message they should seek alternative confirmation
from the Reserve Bank of New Zealand."
******************************************************************************
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
NAnt-users mailing list
NAnt-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nant-users
