Server to server data transfer

ratheeshknair · #1 (**permalink**) 01-29-10, 05:45

Hi Experts,

Is it possible to insert data from one table in a server to another server into a table having same structure?

Is it possible to achive using SELECT statement?

TIA

dr_te_z · #2 (**permalink**) 01-29-10, 06:23

Yes, by means of "federation". When you can select data from a db2-table residing on another db2-database you van just as easy code a "load from cursor" of a "insert from select...).

ratheeshknair · #3 (**permalink**) 01-29-10, 06:32

I have succesfully tried load and insert into select statements from one db to another but i want to know how can i achive the same in different db's residing in different physical machines.

Cougar8000 · #4 (**permalink**) 01-29-10, 09:22

dr_te already gave you the answer. Look up federation.

Internet Services

Web Development

Digital Marketing

Consumer Tech