Subject RE: [firebird-support] Re: [Firebird-devel] Necessary v1.5 tasks
Author Thomas Steinmaurer

> 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.

Personally, I would plan such a change more carefully, because
there might be more involved when switching from dialect 1 to

There are some good articles/papers on SQL dialects in IB/FB
at IBPhoenix.

For example:

There might be others as well. Have a look on them before
migrating a database from dialect 1 to 3.

Best Regards,
Thomas Steinmaurer

Logging/Auditing Suite for InterBase and Firebird
Logging/Auditing Suite for Advantage Database Server