How to copy the data's from one database to another database?

[lvensen]

Two databases are having the same tables and same fields. How to copy the
data's from one database to another database?

 

[Douglas J. Steele]

Do you really need to have the same data stored redundantly in multiple
places? Why not just link from one database to another?

If you think you have a legitimate reason to do it, you can write an Append
query that reads from one database and writes to the other.

 

[Pat77]

Hello,

If you want to copy data from one database to the other, you can use an ETL
tool to perform the job. There are open source tools available for free.

Talend Open Studio is an open source ETL tool for data integration and
migration experts. It's easy to learn for a non-technical user. What
distinguishes Talend, when it comes to business users, is the tMap component.
It allows the user to get a graphical and functional view of integration
processes.

For more information: http://www.talend.com/

 

[Pat77]

Hello,

If you want to copy data from one database to the other, you can use an ETL
tool to perform the job. There are open source tools available for free.

Talend Open Studio is an open source ETL tool for data integration and
migration experts. It's easy to learn for a non-technical user. What
distinguishes Talend, when it comes to business users, is the tMap component.
It allows the user to get a graphical and functional view of integration
processes.

For more information: http://www.talend.com/