Database to Database Transfer?

hi...

I'm looking for some C++ tutorials/articles or open source library that enable me to perform file or data transfer from one remote database server to another remote database server.......

Thanks
:D

1. Are both sites the same DBMS?
2. Are both sites the same OS/architecture?
3. Do you want to transfer the entire DB, or some partial content?

Quote:

---

Originally Posted by Perspective

1. Are both sites the same DBMS?
2. Are both sites the same OS/architecture?
3. Do you want to transfer the entire DB, or some partial content?

---

Thank you for replying...


1. Is a different DBMS, MySQL and PostgreSQL.

2. Different OS, Windows and Linux

3. Either one is fine, but best support both entire DB and partial content.


Thanks

As long as you sit at the same location and transfer from one other host to one other host the architecture are of less importance me thinks.
Just be sure that both DB´s accept connections from you.

If you dont find anything helpful, perhaps a look in API could help you to write a simple function.

http://www.postgresql.org/docs/8.2/i...ive/libpq.html for PostgreSQL
and
http://dev.mysql.com/doc/refman/4.1/en/c.html for MySQL

Questions 1 and 2 were just in case you wanted to blindly copy the entire DB file set from one computer to another, in which case DBMS, versoins, platform, and arch need to line up. In this case you might want to do some bulk export / bulk loading or just query the results you want and insert them into the other DB.