Hi Deepak.
I had a quick look at your script and you are trying to run every script
with a single invocation of SQLCMD.exe.
You may be running into a limitation on the maximum length of a command
line, or into some other limitation of SQLCMD.exe.
I've always used a <foreach> to run my database scripts:
<foreach item="File" property="ddl.file">
<in>
<items>
<include name="Schema-???.ddl"/>
</items>
</in>
<do>
<echo message="Running script ${ddl.file}"/>
<sql connstring="${database.connection}"
delimiter="go" delimstyle="Line" print="true"
transaction="false"
source="${ddl.file}"/>
</do>
</foreach>
Hope this helps,
Bevan.
PS: It's a good idea to give your questions an informative subject line.
******************************************************************************
"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
