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:
http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;PAGES;NAME='ibp_60_overview
'
Alan