I did a binary copydb from a Ingres 6.4 (hp/ux) database and tried to
copy the data in a databse on a 2.6 database (intel, redHat linux)
Most of copy transaction went well, but it there were some errors.
(sorry, do not have the errors right now)

Question: Are the binairies from a copy from a 6.4 database compatible
with a 2.6 database. So should I be able to copy al the data from a 6.4
database to a 2.6 database? (regardles of the transfer method of the
data-binairies)


NB. I do not want to use the -c flag, because of low diskspace on the
6.4 machines.

"eteunisse" <eteunisse@gmail.com> wrote in message
news:1118005166.646834.28750@g43g2000cwa.googlegro ups.com...
> I did a binary copydb from a Ingres 6.4 (hp/ux) database and tried to
> copy the data in a databse on a 2.6 database (intel, redHat linux)
> Most of copy transaction went well, but it there were some errors.
> (sorry, do not have the errors right now)
>
> Question: Are the binairies from a copy from a 6.4 database compatible
> with a 2.6 database.

No, not between HP and Intel, not even a little bit. That has no hope of
working.

> So should I be able to copy al the data from a 6.4
> database to a 2.6 database? (regardles of the transfer method of the
> data-binairies)
>
> NB. I do not want to use the -c flag, because of low diskspace on the
> 6.4 machines.

In that case, create a vnode on the Red Hat box and run the unload there.

Roy Hann (rhann at rationalcommerce dot com)
Rational Commerce Ltd.
www.rationalcommerce.com
"Ingres development, tuning, and training experts"

Or you can use copydb -c (ascii mode).

Regards

Roy Hann wrote:

>"eteunisse" <eteunisse@gmail.com> wrote in message
>news:1118005166.646834.28750@g43g2000cwa.googlegr oups.com...
>
>
>>I did a binary copydb from a Ingres 6.4 (hp/ux) database and tried to
>>copy the data in a databse on a 2.6 database (intel, redHat linux)
>>Most of copy transaction went well, but it there were some errors.
>>(sorry, do not have the errors right now)
>>
>>Question: Are the binairies from a copy from a 6.4 database compatible
>>with a 2.6 database.
>>
>>
>
>No, not between HP and Intel, not even a little bit. That has no hope of
>working.
>
>
>
>>So should I be able to copy al the data from a 6.4
>>database to a 2.6 database? (regardles of the transfer method of the
>>data-binairies)
>>
>>NB. I do not want to use the -c flag, because of low diskspace on the
>>6.4 machines.
>>
>>
>
>In that case, create a vnode on the Red Hat box and run the unload there.
>
>Roy Hann (rhann at rationalcommerce dot com)
>Rational Commerce Ltd.
>www.rationalcommerce.com
>"Ingres development, tuning, and training experts"
>
>
>_______________________________________________
>Info-ingres mailing list
>Info-ingres@cariboulake.com
>http://mailman.cariboulake.com/mailm...py/info-ingres
>
>
>

I did the copy from the Linux-machine through the vnode I configured.
Total success! Very simple and effecient!
Thanks!

On 2005-06-06, Oscar Carlés <oscar@integra.com.py> wrote:
> Or you can use copydb -c (ascii mode).

Which works OK as long as you don't mind having it changing stuff on
during copy-out (tabs to spaces, for one), and you have to make sure up
front that your data doesn't contain the delimiter you choose.

--
Emiliano