Backout an applied Delta

[jstormoen]

Is there a way to backout an applied delta.df to a database ?

 

[toby.Harman]

Restore from the backup you took immediately prior...

There is no other way really.

If your delta did not contain any DROP commands then you can just change your ADD commands to DROPs, but it will not give you the same CRC as you had before...

 

[jstormoen]

What we did

There was some some drop statements in the original delta applied so I had to hunt down and older testing version of the DB and do an incremental against that in order to create a delta to back out the changes.

Since we are using V9.1A the CRC's went back to the same. In V9 the CRC's are based off the overall definition of the database not the order in which fields/tables were changed which is an excellent feature.

Restore from the backup you took immediately prior...

There is no other way really.

If your delta did not contain any DROP commands then you can just change your ADD commands to DROPs, but it will not give you the same CRC as you had before...