Hi folks,
Since ib6 I have been using dialect 1 for an app which I now want to
move to dialect 3. The database was originally designed for dialect 3,
(but it worked with interclient 1.6 which didn't support 3), so there
are no problems with quotes etc.

Whats the best way to switch the dialect?

If I use gfix to change it is there any gotchas that I should watch
out for?

Will a backup and restore after the gfix have any benefit?

I will need to upgrade relatively freqently, to allow the 'live' data
to be used for testing/demonstration purposes.

I am planning on targeting Firebird 2 for this upgrade, as my software
will not be ready for a good few months.

TIA

Ian Newby