Transfer data from Oracle to Informix 
Author Message
 Transfer data from Oracle to Informix
Hi :
     I'm trying to transfer data from Oracle to Informix
When encounter to transfer Oracle Long type data to Informix Text type field
It need very long time because there are five  hundred thousand rows of data
I use two action
First Query from Oracle (except Long field)  and insert into Informix
Send query Long field use ADO getchunk
then update to Informix use ADO appendchunk and update method to update it
Any suggestion to process the transfer more fast ?
     Scott


Fri, 04 Jun 2004 11:04:55 GMT
 Transfer data from Oracle to Informix

Hi,

I don't know if this will work for you, but it is free trial:

From Sybase get eval copy of Infomaker. It is a report writer with
added pipeline functionallity. It reads from one database, translates
datatypes and writes to another.

HTH

Michael

Quote:

> Hi :
>      I'm trying to transfer data from Oracle to Informix
> When encounter to transfer Oracle Long type data to Informix Text type field
> It need very long time because there are five  hundred thousand rows of data
> I use two action
> First Query from Oracle (except Long field)  and insert into Informix
> Send query Long field use ADO getchunk
> then update to Informix use ADO appendchunk and update method to update it
> Any suggestion to process the transfer more fast ?
>      Scott



Fri, 11 Jun 2004 01:49:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Data transfer between Oracle and Informix

2. Data transfer between Oracle and Informix

3. Transfer Oracle Long Data value to SQL Server Long data value

4. How do I transfer INFORMIX data to SQL Server 6.5

5. Data Transfer - only transferring new or changed rows

6. SQL 6.5 Object Transfer: transfer fails and also destroys source data

7. Transfer from Informix to Oracle?

8. Data Transfer from Long data type to SQL Server Text data type column

9. Transferring the data from Oracle to SQL server through VB

10. data transfer ms->oracle

11. has anyone transferred MSSQL data to ORACLE?


 
Powered by phpBB® Forum Software