How to reverse a schema compare deployment

Robbie44Robbie44 Posts: 2 New member
in Schema Compare for Oracle
Can you advise what is the best method of reversing a schema compare deployment?

Thanks
Tagged:
· Share on Twitter

Answers

  • Robbie44Robbie44 Posts: 2 New member
    can a deployment be reversed?
    · Share on Twitter
  • David AtkinsonDavid Atkinson Posts: 1,458 Rose Gold 2
    Robbie44 said:
    Can you advise what is the best method of reversing a schema compare deployment?

    Thanks

    Can you share more about the problem you're trying to solve. Are you using the GUI or command line? Has the deployment happened already?

    If you're in the GUI you can reverse the direction of the deployment by double clicking on the large arrow either in the edit project dialog or the comparison results screen.



    If you're automating, one way of achieving this is to save a schema snapshot (.onp file) pre-deployment, which can later be used as the source for a roll-back. This can only recover schema changes. If data has been lost in a deployment you'll need to recover from a backup.
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.