Subject Re: Windows/Linux Cross-Platform On-Disk-Structure Question!
Author Adam
--- In firebird-support@yahoogroups.com, "nathan_probst"
<nathan.probst@g...> wrote:
>
> Hello All -
>
> This is my first posting to firebird-support. I'm just learning about
> FB and all that is possible...and I have one very important question:
>
> "Is the ODS (on-disk-structure) of the Windows server compatible with
> the ODS used by the Linux server?"

Yes. A Firebird database on any OS can be backed up then restored to
any other OS that has a Firebird build (providing the transportable
backup option is used). In many cases, the fdb file can simply be
copied from one OS to the other (providing the service is shutdown
first to make sure it is not in use), but this depends on the endian
of the machines.

>
> My company intends to develop a device that can plug into both Windows
> and Linux machines. This device needs to contain a powerful RDBMS
> (residing on a FAT32 filesystem) such that the info stored under one
> OS is available on the other OS.

Fat32 is not a good solution, Firebird can be installed and run under
it, but forget any asperations you had at securing the database, as
Fat32 has no (real) capability of user level security.

The client and server may run different operating systems (but make
sure the library versions match, dont try and mix a 1.0 client with a
1.5 server etc).

The RDBMS needs to be as
> resource-efficient as possible (which rules out a Java solution). So
> far, FB is the only option I've located. But, I'm unsure if the ODS
> is compatible between OS's.
>

Adam