Re: [NAnt-users] Nant capability

2007-04-03 Thread David Keaveny
What you want is the service::is-running () function in NAntContrib (http://nantcontrib.sourceforge.net/release/latest/help/functions/index. html) NAntContrib gives you a good amount of information from

[NAnt-users] Nant capability

2007-04-03 Thread Bobby Michael
Hi All, I have couple of questions regarding the capability of Nant scripts. I really need this requirements to write scripts for my ongoing project. Answers to these questions are highly appreciated. Is NAnt capable of verifying that a Windows Service is up and running? Can we start Windows Se

Re: [NAnt-users] Regarding DB Build Using NANT

2007-04-03 Thread Robert Kolev
Another option you might consider is spooling your sql files to a set of sql scripts such as storeProcedures.sql , Views.sql, Types.sql, Triggers.sql etc. during your build process... then during deployment you can organize in logical order on what you want to upload first (eg. Data Types, views,

Re: [NAnt-users] Regarding DB Build Using NANT

2007-04-03 Thread Bevan Arps
Hello Deepak. I've done exactly what you describe - check out the 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] [mail

[NAnt-users] Regarding DB Build Using NANT

2007-04-03 Thread Deepak Surendran
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 ex