Options

Can I roll back changes from Utils.ExecuteBlock?

spireitespireite Posts: 25
edited September 30, 2004 10:53AM in SQL Toolkit Previous Versions
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
· Share on Twitter

Comments

  • Options
    chris sampsonchris sampson Posts: 38
    Hi,

    Do you mean rollback the sql compare generated change script if your script fails, or rolling back the changes made by your script?
    Chris Sampson
    Support Engineer
    Red Gate Software
    · Share on Twitter
  • Options
    Neil DavidsonNeil Davidson Posts: 281
    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.
    - Neil Davidson
    Red Gate Software Ltd
    · Share on Twitter
  • Options
    spireitespireite Posts: 25
    Ah...ok... thx.
    · Share on Twitter
This discussion has been closed.