Subject RE: [firebird-support] Firebird on FreeBSD
Author Helen Borrie
At 09:42 AM 15/01/2005 +1100, Alan McDonald wrote:

>For starters - I hope you backed it up

under the InterBase server

>and restored it

under the Firebird server.

>(and not copied it).
>Secondly, you should ensure your restore is Dialect 1 and not Dialect 3

Only **IF** it is a Dialect 1 database. Let's not assume the old IB server
was IB 5 or lower. A dialect 1 client connecting to a dialect 3 database
will be a problem (if it can even connect at all).

>Otherwise - it all depends a little on what you use to connect to the
>database (components?), language, environment etc tell us more.

Actually, the gotchas will depend most on the SQL language used by the
applications, not on components, etc. used. Firebird is a lot more fussy
about legal SQL than InterBase is, especially ambiguity in joins.