Re: export from NT to unix
This is a multi-part message in MIME format.
--------------21F814147D7DD8B8D5C14CB2
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Hi. Scott
I guess I have a way easier.
Suppose you have a database mydb into a instance ol_nt and you wish to migrate
to a instance ol_unix
1) on unix, configure the sqlhosts for you can connect a ol_nt
2) On unix you do a dbexport from mydb in ol_nt, this's way:
dbexport mydb@ol_nt -ss -o .
that does a directory mydb@ol_unix.exp on NT. and all file in there will be on
UNIX format.
3) Rename the directory mydb@ol_nt.exp to mydb.exp and rename too the file
mydb@ol_nt.sql.to mydb.sql
4) Make dbimport into ol_nt.
dbimport mydb -i. .
I hope two thing. 1) those instructions can help you and 2) that I may explicate
it to you becouse I don't speak english well.
Scott Patterson wrote:
> I have successfully exported from unix and imported into nt many times.
> Reformat the SQL file and all is well. Now I need to move back from NT to
> unix (HPUX). The linefeeds are killing me. For the smaller files a sed
> script to strip off trailing linefeeds works. But I have a table containing
> a BLOB. sed can't handle that long of a record.
>
> Is there a good way to tranfer from NT to unix?
>
> Thanks,
>
> Scott
--------------21F814147D7DD8B8D5C14CB2
Content-Type: text/x-vcard; charset=us-ascii;
name="fhuezo.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Francisco Huezo
Content-Disposition: attachment;
filename="fhuezo.vcf"
begin:vcard
n:Huezo Saravia;Francisco Armando
tel;pager:(503) 298 1122 unidad 41772, fhuezo@mail.televip.com.sv
tel;cell:(503) 830 6974
tel;fax:(503) 226 81 84
tel;work:(503) 224 37 00 ext 380
x-mozilla-html:FALSE
org:Ministerio de Hacienda;Proyecto SAFI
version:2.1
email;internet:fhuezo@mh.gob.sv
title:Administrador de Base de Datos
adr;quoted-printable:;;Cond. Tres Torres, Torre 2, Nivel 8.=0D=0A;San Salvador;San Salvador;;El Salvador
fn:Francisco Huezo
end:vcard
--------------21F814147D7DD8B8D5C14CB2--