Subject Re: [IBO] BatchOutput/Input
Author Don Gollahon
"Nando Dessena" <nandod@...> wrote in message
news:<166263239969.20040226110323@...>...
> Helen,
>
> >>If you can afford to have the two databases online at the same time,
> >>sure, and it has a lot of advantages too, like 2PC.
>
> H> How else would you transport raw data from one database to another
except
> H> in a database?
>
> so your suggestion is to use a third database as a transport medium
> between the two if they aren't both available at the same time? That's
> clever, I didn't think about that. But, you must have a local server

This is a good idea. What I need to do is not just a simple export/import
but more like an export then an append/update as necessary.

> to do that, otherwise the intermediate database might not be at hand
> (actually if server security is decent you won't be able to do that
> remotely at all).
>
> Don, I don't know about you, but I always have a local server
> available since the advent of Firebird embedded. :-)

I'll have to check into the FB embedded. Haven't tried it yet. Can you
have it running and still access remote databases?

>
> How else? Well, pick a file format or invent one, and then find or
> develop import/export utilities. I guess IB_Export/IB_Import were
> developed to reach that goal, but as seen they're half-baked. Your
> IB_DataPump solution might well meet Don's requirements.
>
> Otherwise Milan's fbexport (to be found on Sourceforge) might help.
> It acts pretty much like a selective gbak.
>
> Ciao
> --
> Nando Dessena
> mailto:nandod@...
>
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>