store datas between two database 1

[eri232323]

Hi Everybody,
I need store some data from a database into an other.
I try pipeline, rowscopy, and step row by row, but it's so slow i think.
Does anyone know something what is faster like these?
(Pipeline was the best slower)
erie

 

[tabhijit]

eri,

Try following steps :

1) Have 2 transaction objects.
1) Retrieve rows from one database.
2) Change status of all rows to newmodified!.
3) Change trasaction object and point to another database.
4) Update.

Let me know if it works.

Regards,
Abhijit.

 

[eri232323]

Hi,
It's cool!!! (2000 row 50 sec. If I used pipe it was more than 10 minute!)
I never try changing the transaction object under the living "data".
So many thanks!!! Professional ))
-eri-