Transaction Scopes & Multi-DBs

Hey there,

Was wondering if there is any pattern / approach for handling implementing a transaction scope around a set of scripts that are being executed against multiple DBs.

For example, we might have three scripts - an INSERT, UPDATE and then a SELECT. These scripts are being executed against ten different databases. If the INSERT or UPDATE fails on any one of the databases, I want all databases returned to their original state.

Very new to this software, did some research but I wasn't able to find anything that solves this problem across databases.
Tagged:

Comments

  • Hi,

    Sadly I don't think SQL Multi Script is capable of doing this. I'm not sure how I would go about implementing something like this but I'd recommend taking a look at SQLServerCentral.com to see if there are any articles or forum posts that might address a scenario like this.
    Software Engineer
    Redgate Software
Sign In or Register to comment.