> If i compare a database using ibexpert or clever components dbcomparer,
> with a master sql schema, it shows they are identical.
>
> If i do a backup and restore and then compare them i get a ton of the
> following

you're not just doing a schema compare - otherwqise you would not get dml
statements in the resultant script.
You are doing a table data compare as well.
Why you are getting these differences in the data I'm not sure but I would
suspect that you have changed or FIBPLus has made some system table changes
which do not live thru a backup/restore.
These are all NULL Flag ssettings so somewhere along the line you have made
some changes to teh null flag which have been carried out directly on the
system tables and not done correctly. Instated of issuing a DDL statement.
I wonder waht version of admin tool you are using? Do you use IBExpert (e.g.
an old personal version with perhaps a bug in the not null flag setting?)?.
Alan

>
> /* Alter Field (Null / Not Null)... */
> UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = 1 WHERE
> RDB$FIELD_NAME='ALTMENUITEMID' AND RDB$RELATION_NAME='ALTMENUITEM';
>
> /* Alter Field (Null / Not Null)... */
> UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = 1 WHERE
> RDB$FIELD_NAME='NAME' AND RDB$RELATION_NAME='ALTMENUITEM';
>
> /* Alter Field (Null / Not Null)... */
> UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = 1 WHERE
> RDB$FIELD_NAME='DESCRIPTION' AND RDB$RELATION_NAME='BILLCAT';
>
> /* Alter Field (Null / Not Null)... */
> UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = 1 WHERE
> RDB$FIELD_NAME='BILLCATNUM' AND RDB$RELATION_NAME='BILLCAT';
>
> /* Alter Field (Null / Not Null)... */
> UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = 1 WHERE
> RDB$FIELD_NAME='CREATED' AND RDB$RELATION_NAME='BILLCAT';
>
> /* Alter Field (Null / Not Null)... */
> UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = 1 WHERE
> RDB$FIELD_NAME='CALENDARNOTEID' AND RDB$RELATION_NAME='CALENDARNOTE';
>
> /* Alter Field (Null / Not Null)... */
> UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = 1 WHERE
> RDB$FIELD_NAME='CALENDARDATE' AND RDB$RELATION_NAME='CALENDARNOTE';
>
>
> is the restore not restoring it identically? i'm using FIBPlus 6.25 to
> do the restore, but i would imagine its just part of the firebird server
> which is the latest 1.5.2.
>
> any ideas?
>
> thanks