You could create nant targets using EXEC task that calls the sql client and runs the sql script to see if it returns an error and fails the target, or something to that affect. Roger
--- On Thu, 4/9/09, Outlaw1803 <[email protected]> wrote: From: Outlaw1803 <[email protected]> Subject: [ccnet-user] Basic SQL Validation Tests To: "ccnet-user" <[email protected]> Date: Thursday, April 9, 2009, 4:34 AM Hi, I have an app that combines multiple .sql files as 1 script. I would like to do some validation tests on the script to ensure there are no syntax errors (usually I would parse the script in SQL2005/2008) Is there an automated way of doing this? What tools can I use to perform this task? Any ideas whould be appreciated Regards
