Re: Help - Export/Import a Row

Hi Joe,

    Some tools let you perform this operation, like SQLTalk. I think it's from Gupta. It allows you to open 2 cursors (identities in 2 different databases), then you 'Copy 1.tablename to 2.tablename;'. That pulls all data from cursor 1. to 2.. Then you can manipulate as necessary. It seems to be using the memory of the client that has both db's open as an intermediary store row-by-row - like the export file would act. I don't know it's availability. HTH, Greg

Joe Gervais wrote:

> Howdy Folks,
>
> Sorry if this is in the FAQ, but I couldn't find it.
> Can anyone help me figure out how to export a database
> row from a single table to file, and then import the
> row back into an equivalent table in another database
> (on a separate network).
>
> I'm looking into spool and sqlload, but that seems like
> overkill. Is there an easier way to do this?
>
> Thanks in advance!
>
> Cheers,
>
> -Joe, vole_at_primenet.com
>
> "And that, my Liege, is how we know the Earth
> to be banana-shaped." -- Monty Python and the Holy Grail
> --
Received on Wed Apr 29 1998 - 00:00:00 CDT