Adam wrote:

> --- 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.

As long as the file systems are the same then there should not be a problem.
But sod's law says that when you want to do something quick where you have not
tested it - Windows will bite back ;) I've been taking a little more care
recently because I'm running 32 and 64 bit Linux, but I'm only running 32 bit
windows even on the 64 bit hardware.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php