| Subject | Re: [firebird-support] gfix: "unavailable database" returned |
|---|---|
| Author | Helen Borrie |
| Post date | 2009-12-31T20:39:40Z |
At 04:51 AM 1/01/2010, you wrote:
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.
./heLen
>I am trying to convert FB 1.5 a dialect 1 DB to 3. pretty simple: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.
>
> gfix -user ... -pa ... -s 3 dbname
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.
./heLen