Question for developers...
Wouldn't be easely to specify dialect on restore?

Paul

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

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