Yes. FAT32 is rather limited. But here's the rub...we need to be
able to mount the same filesystem under both OSes with out an
export/reload. As far as I know, FAT32 is the only option for a
stable, natively support filesystem that can cross over from Windows
to Linux and back. Of course, Helen's mention of a raw partition is
intriging...got any other ideas?

Nathan

--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:
>
> --- 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
>