Subject RE: [firebird-support] Re: gfix: "unavailable database" returned
Author Alan McDonald
> > 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.
> >
> Then why let FB change dialect of a database if it makes data
> inconsistent?
> How to change dialect to databases in production 24x7?
> What inconsistent data is unrecoverably?
> I thought that the changes of dialect are only language and data types,
> but not the data itself.
> Jesus

read this and get back to us:;PAGES;NAME='ibp_60_overview