| Does SQL task support a single transaction for multiple sql files? | Does SQL task support a single transaction for multiple sql files? 2003-02-17 - By davexmail@(protected)
Hi,
We are using ANT for our deployments and want to automate the database updates
as well. We have multiple sql files for a single release to make it easier to
maintain them.
When we do a deployment I want to run all the scripts in a single transaction
so that if any go wrong I can roll them all back. Unfortunately the SQL task
says that it creates a new transaction for each file, this means that if one
fails it won't roll back them all. It needs to be all or nothing when it comes
to the database as the new code we deploy will expect all the changes there and
if we roll back, the old code will expect none of the changes.
Any suggestions?
Do I need to create my own custom task?
Cheers Dave
__________________________________________________________________
The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels
.netscape.com/ns/browsers/download.jsp
Get your own FREE, personal Netscape Mail account today at http://webmail
.netscape.com/
|
|
 |
