Online Documentation for SQL Manager for PostgreSQL
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:
- 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.
- On the second step check Generate differential script in order to generate a script reflecting difference between two database states.
- 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.
- Execution of this script will rollback your database to the necessary point.