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-------------------------------------------------------------------------
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
