Subject Re: [firebird-support] gfix: "unavailable database" returned
Author Helen Borrie
At 04:51 AM 1/01/2010, you wrote:
>I am trying to convert FB 1.5 a dialect 1 DB to 3. pretty simple:
> gfix -user ... -pa ... -s 3 dbname

Did you know that this does not convert your data to dialect 3? It only changes the dialect flag on the header...but in future you will have a mixture of D1 and D3 data in your tables, i.e., unrecoverably inconsistent data.

The only condition where it is "safe" to do this is where you have a totally empty database, e.g., you have restored a metadata-only backup and you are going to pump the data from the original database into it after modifying the dialect flag.

The rest - as DS indicated.