This is a discussion on Re: how to copy large data fast within the Informix forums, part of the Database Server Software category; --> >From: "Neil Truby" <neil.truby@ardenta.com> >"Ian Michael Gumby" <im_gumby@hotmail.com> wrote in message >news:mailman.9.1168889830.10648.informix-list@iiug.org... > > > I'm talking in terms ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| >From: "Neil Truby" <neil.truby@ardenta.com> >"Ian Michael Gumby" <im_gumby@hotmail.com> wrote in message >news:mailman.9.1168889830.10648.informix-list@iiug.org... > > > I'm talking in terms of theory. I'd take the lazy approach and do the > > insert statement. > >The lazy approach is to use dbexport/dbimport. > > Uhm no, too much work. There you'd have to ensure that you have enough disk space free to store a copy of your database. ;-) If I did an insert with a select on a remote system. I'd go directly from one database to the other. The I wouldn't have to worry about setting up bothersome meetings with the BOFH and explain why I need this diskspace. Fill out all that paperwork and then have to get permission for the charge back of database back to my department. ... ;-) __________________________________________________ _______________ Your Hotmail address already works to sign into Windows Live Messenger! Get it now http://clk.atdmt.com/MSN/go/msnnkwme...enger/overview |