Subject Re: [firebird-support] change sql dialect at database
Author Helen Borrie
At 05:08 PM 27/07/2004 +0700, you wrote:
>hello all,
>i just wanna ask, can we change sql dialect at database after we create the
>database? suppose i create a new database with sql dialect 1 and i want to
>switch it to sql dialect 3, is it possible?

It is *possible* - there is a gfix switch that enables this. However, it
won't convert existing data and definitions to dialect 3: existing stuff
will conform to dialect 1 rules and new stuff to dialect 3. It's a case of
"can do" but it's not the right way to convert: it's quick, dirty and
prone to problems.

Best by far is to use your DDL schema script (or extract the complete DDL)
for your database to recreate the database as dialect 3 and pump the
data. It's such a common need that there are excellent tools around for
doing it.