Subject Re: How to migrate to new database Server?
Author Marianne
If you move from 32 bits firebird server to 64 bits, if you have specific udfs, you'll have to recompile them in 64 bits.

We moved from 32 bits to 64 bits, and we also changed from dialect 1 to 3. Which add other things like changing the " (double quote) in ' (simple quote).

--- In firebird-support@yahoogroups.com, Mark Rotteveel wrote:
>
> On Tue, 12 Feb 2013 22:49:27 -0000, "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
>