Transaction Scopes & Multi-DBs
curt312
Posts: 1
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.
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
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.
Redgate Software