Subject Re: 32bit -> 64bit compatibility
Author Adam
--- In firebird-support@yahoogroups.com, Lester Caine <lester@...> wrote:
>
> Adam wrote:
> > Hello Group,
> >
> > I have a Firebird 1.5 database on my laptop (XP 32bit) that I need to
> > upload to a server. Firebird is not running on my laptop, so it is
> > safe to file-copy the file, but I am copying it to a 2003 Server 64
> > bit running Firebird 1.5 (as a 32 bit process via WOW64).
> >
> > Is Firebird on the server going to have any trouble with this file? I
> > suspect it will be fine, but wasn't sure whether the 64 bit OS caused
> > different alignments within the fdb.
>
> Backup and restore is the SAFE way to do it. It will strip any
garbage and
> rebuild the indexes as well. I've copied databases in the past when
in a hurry
> but it's not recommended and would probably not work in your case.
>
> I suspect from your question that you don't have a backup of the
database?

You suspect wrong. The database was restored this morning and I ran a
bunch of scripts on it locally. During this time I was the only user
using the system and the index distributions would not have
significantly changed by the scripts.

If gbak could have backed up and restored the database within an hour
and without causing an additional core worth of CPU load on a
production server, I would not have posted the question. I was rather
hoping for a quick answer about whether on a system of the same
endian, there is any difference between a fdb restored on a 32 bit or
64 bit server. FWIW it seems to be fine.