Subject Re: [firebird-support] Re: [Firebird-devel] Necessary v1.5 tasks
Author Lester Caine
Achim Kalwa wrote:
> Hi,
> Nando Dessena wrote:
>>A> Is there a way to _convert_ an existing database from dialect 1 to 3?
>>A> I have a database with ~180 Tables filled with 12.5 Gigabyte data.
>>Use gfix. Also, look at the IB migration guide.
> in gfix there is a switch -sql_dialect n. I'll try that.

Even given the amount of data you have, I would recommend
creating an new blank dialect 3 database, and pumping the
data from the old one. I found quite a few niggles when
converting my small databases over, and those needed to be
fixed before I could get a 'clean' dialect 3 copy. You need
to have a play with an old copy obviously first.

Once you know what the problems are, THEN you may be able to
create a faster conversion, for the real system :)

Lester Caine
L.S.Caine Electronic Services