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...
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.
toby.Harman said:
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.