Transfer data between tables that are located in different databases

[Dinesh Bajaj]

Hi,

Could someone give me pointers on how to transfer data between two tables that 
are identical in structure, but located in different databases. This task needs 
to be accomplished through code.

Thanks in advance.

-Dinesh