|Subject||RE: [firebird-support] Restoring a Backup with a NULL cntraint and NULL data|
>Before you do this, you'll want to ensure you can get valid metadatafrom somewhere, so
>you can compare and restore the constraints later. I've been burned bythis, it
>took me a while to fix manually. I had been keeping metadata-onlyexports around,
>but none were recent enough at the time. And you'd probably want a toollike EMS
>Metadata Comparer for Interbase/Firebird so you can restore such ametadata-only
>database, restore a no-constraint version, then fix the data, thencompare the
>two and restore the missing constraints.Thank you Philip and Ann for all your help, I seem to have come right
now, thanks to your advice.
I restored the corrupt DB first with no check constraints, and then with
I then corrected the NULL ID field in the DB with no validity checks.
I then used IBExpert DB Compare tool, which generated a script to put
all the not null's back, as the were before.