Since you are using Java, here is another option worth considering. On
an oracle database, an early (untuned) version was as fast as Oracle's
import tool. Unlike the use of a backup/restore tool, you don't need
extra storage space, which is important in a large installation.

Another option the I am using with large databases (Oracle and DB2,
several TB) is to read with JDBC from one database and write directly to
the other with JDBS.

Snapshot the metadata and create the database from the snapshot
metadata.

For performance, separate the read thread from the write thread, and I
push the data between threads in a thread safe Queue (wrapper around
sun.misc.Queue in older JVM's, in newer JVM's threre are suitable
classes already available).

If you move the data as Strings, JDBC will automatically make the type
conversions for you, so you don't need to code specific classes for each
table. You may put the SQL in a configuration file so the migration
classes are completely agnostic of the database structure.

You may run as many of these migration threads in parallel as your
hardware will allow, so you can maximize throughput on the slowest part
of your overall system by simply adding threads until you don't gain
anything from it.

Good luck!

On Sun, 2005-04-24 at 11:00 +0000, java4sg wrote:
>
>
> Thanks Miroslav/Johan.
>
> What we'll lose by using transportable format?
> Assuming I used particular filesystem in Linux (say, ext3, reiser..,
> XFS, GFS) -- by using transportable format to Windows, any changes on
> the file content? Do we need to re-tune the database once it's
> restored from transportable format to other platform?
>
> Thanks.
>
> Cheers,
> BAM
>
>
> --- In firebird-support@yahoogroups.com, "Johan van Zyl" <johan@j...>
> wrote:
> > Can I simply copy a .fdb file from Linux to Windows and just carry on
> > working? (When a server goes down)
> > (Of course shutting down database and new connection parameters (from
> > 1.0.0.3:employee to 1.0.0.5:employee) in Client app first)
> > Thx
> > JVZ
> >
> > -----Original Message-----
> > From: firebird-support@yahoogroups.com
> > [mailto:firebird-support@yahoogroups.com]On Behalf Of Miroslav Penchev
> > Sent: 24 April 2005 12:04
> > To: firebird-support@yahoogroups.com
> > Subject: Re: [firebird-support] Does Firebird support file compatibility
> > across platforms?
> >
> >
> >
> > On Sun, 24 Apr 2005 09:35:15 -0000, java4sg <java4sg@y...> wrote:
> >
> > >
> > >
> > > Hi,
> > >
> > > Does Firebird support file compatibility across platforms?
> > > Can we easily perform (100%) cross platforms operations:
> > > - copy firebird data files
> > > - backup from one platform (i.e. Linux, or Windows) to other platforms
> > > (i.e. Windows, Linux, or Solaris)
> > >
> > > My requirement for "easily perform cross platforms operation" is that
> > > the file can be transport across platform without changes (as it is
> > > from original platform).
> > >
> >
> > Backup it in Transportable format and restore it in other platform.
> >
> > Cheers,
> > --
> > Miroslav Penchev
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Anti-Virus.
> > Version: 7.0.308 / Virus Database: 266.10.2 - Release Date: 2005/04/21
> >
> >
> >
> >
> > --
> > No virus found in this outgoing message.
> > Checked by AVG Anti-Virus.
> > Version: 7.0.308 / Virus Database: 266.10.2 - Release Date: 2005/04/21
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>