Hello Ian,

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

Extract the metadata, create a new dialect 3 database.

Transfer the data.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

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