Home > IT Answers > Business Intelligence > Data transfer between databases
JOEJOSE
5 pts.
 Data transfer between databases
Data transfer, Databases
Hi, I need to transfer data from one database to another, whenever a table in the first database get inserted with a value from UI. Can somebody explain me way to do this (Both databases are not identical). I have an idea like selecting required row data from first table and putting it in generic temp table. And then using DBLINK inserting the same to the second database. Do anybody have any nice and easy way to do the same. Thanks in advance.

Software/Hardware used:
ASKED: February 4, 2013  8:29 AM
UPDATED: February 4, 2013  1:05 PM
RELATED QUESTIONS
Answer Wiki:
What database are you using?
Last Wiki Answer Submitted:  February 28, 2013  8:05 pm  by  TomBubb   65 pts.
All Answer Wiki Contributors:  TomBubb   65 pts. , Michael Tidmarsh   11,380 pts. , JOEJOSE   5 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

DBLINK can mean Oracle or Postgres SQL or perhaps other DBMSs. Can you at least tell what DBMS your two databases are built over? What versions? Are they on the same systems? The same platforms? What OSs are you using? How are the database systems connected? — Tom

TomLiotta
 107,735 pts.