RE: dbcopy over secure/encrypted line
Why not write a simple python script that has two database connections.
One to the old database and one to the new database?
In short, you select data from one table, insert row in to new table on second box.
If you want better performance, then create multiple threads and do a table per thread.
This will move your data over, never having to stage it on disk.
> Subject: RE: dbcopy over secure/encrypted line
> Date: Thu, 18 Sep 2008 11:46:07 -0500
> From: mosserp@wellsfargo.com
> To: curtis@crowson1.com; informix-list@iiug.org
>
> > -----Original Message-----
> > From: informix-list-bounces@iiug.org [mailto:informix-list-
> > bounces@iiug.org] On Behalf Of bozon
> > Sent: Thursday, September 18, 2008 8:44 AM
> > To: informix-list@iiug.org
> > Subject: Re: dbcopy over secure/encrypted line
> >
> > On Sep 17, 5:50 pm, <moss...@wellsfargo.com> wrote:
> > > Anyone have an ideas on how to use Art K.'s "dbcopy" utility over a
> > > secure/encrypted line? I tried to set up port forwarding under ssh,
> > but
> > > am not having any luck. Anyone made this to work?
> > >
> > > TIA,
> > > Paul M.
> >
> > Are you using a later version of informix because HPL is now much
> > nicer. The onpladm command works great. This may take the place of
> > using dbcopy. Can you just use HPL to unload the data and then sftp to
> > the other box? Also in 10 you can redirect ontape through the ssh I
> > have an example of doing this that might work for you.
> >
> > just type onpladm for help
> >
> > onpladm
> > usage : onpladm <command>
> > create job <jobname> {options}>
> << clipped >>
>
> Thanks for the suggestion. HPL might be an option, but we were hoping
> to bypass having to put the data to flat files at all, thus the desire
> to use dbcopy. And ontape is not an option for us, as we are migrating
> to different boxes (HP => Linux), and different IDS versions (9.40 =>
> 10.00).
>
> A co-worker (former Informix employee) and I were experimenting, and
> there might be a way to use named pipes, ssh, and unload / load, to get
> the data across and loaded. Anyone already done something like that??
>
> TIA (again),
> Paul M.
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
_________________________________________________________________
Get more out of the Web. Learn 10 hidden secrets of Windows Live.
http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_domore_092008