Online Documentation for SQL Manager for DB2

Rollback to previous revision state


If you want to rollback a database to the state of a previous revision then you need to perform the following actions:

  1. Right-click database in the DB Explorer and select Change management | Get Change Script item from the popup menu or select the Tools | Change Management | Get Change Script in the main program menu. Get change script wizard will appear.
  2. On the second step check RadioButton Generate differential script in order to generate a script reflecting difference between two database states.
  3. On the third step specify a date or tag as a script end point so as to define a state to which you want to rollback your database and create a reverse script.
  4. Execution of this script will rollback your database to the necessary point.