On Tue, 12 Feb 2013 22:49:27 -0000, "jwcanada" <jwcanada@...> wrote:

> I have a Delphi web Server application using Firebird 1.5 as backend
> database. I am thinking about updating to new server. Few questions:
>
> 1. Could I install Firebird2 64 bits on a database server and access to
> the database from 32 bits web application on another machine?

Upgrade to Firebird 2.5, not Firebird 2. You can connect to a 64 bit
Firebird server with a 32 bit client (the wire protocol is platform
independent).

> 2. What is the process to convert Firebird 1.5 database to Firebird 2
> database?

Basically backup on 1.5 and restore on 2.5, but you might want to read up
on the changes and compatibility issues since 1.5 in the 2.0, 2.1 and 2.5
releasenotes. There are some caveats with upgrading due to charactersets of
data and metadata, new reserved words etc.

Documents of interest:
Firebird 2 Migration & Installation (covers upgrading from 1.0 and 1.5 to
2.0 and 2.1):
http://www.firebirdsql.org/file/documentation/release_notes/html/install210.html

And the Firebird 2.5 release notes section compatibility:
http://www.firebirdsql.org/file/documentation/release_notes/html/rlsnotes252.html#rnfb25-compat

On top of that: test the migration and your actual application well before
going to production.

Mark