In article <5.2.0.9.2.20050210095423.0551ae30@...>, Helen Borrie
wrote:

> To answer the question in your thread subject, "you can't tell". In short,
> don't use either gfix or the dialect 2 route to change the dialect. There
> are so many traps that something is going to catch you. Instead, use a
> reliable metadata extract tool to script the database, recreate the empty
> database as dialect 3, and datapump everything. This is the only reliable
> way to convert dialect 1 objects and data to dialect 3.

I thought that setting the database to dialect 3 and then doing a backup
& restore would effectively do the same thing or does it backup the BLR
and restore it instead of recompiling the source when doing the restore?

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly