"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 for the import 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.

This may come in handy for some other things. It is a very nice utility.
Again, the best for me is an append/update type import.

>
> Ciao
> --
> Nando Dessena
> mailto:nandod@...
>

_________________________________________
Don Gollahon
dlgllhn@... <mailto:dlgllhn@...>
ICQ#: 115831669
"What in Eternity does it matter?"
_________________________________________