RE: Migrate BLOBs From 5.x to 7.3 ?
Can I avoid dbexport all together and do:
- dbschema my OL5
- create on IDS7 only for tables with BYTE columns
- run: insert into LOCALTABLE select * from REMOTETABLE@server5:owner.tablename
for tables with BYTE columns. Both server on same network.
-----Original Message-----
From: Paul watson [SMTP:watsop@russellcorp.co.uk]
Sent: Friday, October 01, 1999 11:53 AM
To: informix-list@iiug.org
Subject: Re: Migrate BLOBs From 5.x to 7.3 ?
I checked back in notes, the problems I was seeing was BYTE column but only where
a number of multiple pages were required, so about 2000 rows had to be unloaded,
deleted and reloaded by hand
Paul Watson
WF Software Ltd
Tel: +44 1436 674729
Fax: +44 1436 678729
www.wfsoftware.com/informix
# If you broke it, hide the evidence
>>> "Art S. Kagel" <kagel@bloomberg.net> 09/30/99 06:53PM >>>
It will work fine for BYTE columns. However there was a problem with
exporting TEXT columns. Newlines were not quoted and so confused the
dbimport/import which would complain about incorrect number of columns.
You can use my dbcopy to copy the data directly from engine to engine.
Another option is using onunload/onload or writing a custom ESQL/C program
to unload and load the data.
Art S. Kagel
"M. Najaa" wrote:
>
> Hi,
>
> I have an Online 5.03 Database with BLOB data. Total size above 70G.
>
> Need to migrate to new platform (SUN) running IDS 7.3 and need help on best method to move data to new platform.
>
> Can I run OL5.03 dbexport from my current platform (Sequent S2000/250) and then run 7.3 import on SUN ? Well this work ?
>
> We still in the planning stage and want to avoid surprises during implementations.
>
> TIA
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************