Can I roll back changes from Utils.ExecuteBlock?

spireite

I have a system where I can optionally apply a SQL script before or after (or both) the the compare takes place and differences applied. If my postcompare script fails, can I rollback the changes made by Utils.ExecuteBlock method?

Thx

chris sampson

Hi,

Do you mean rollback the sql compare generated change script if your script fails, or rolling back the changes made by your script?

Neil Davidson

If the script fails all changes will be rolled back automatically.

If you the script succeeds but you want to roll it back then you need to use the script that was generated for the migration in the opposite direction. If you're migrating A->B then the script generated for the B->A direction will be the roll-back script.

spireite

Ah...ok... thx.