Database Programming (database to database transaction)
 

hi...

Anyone can recommend any open source and cross platform C/C++ API or programming library that enable a remote database to transfer record to another remote database through Internet?

Thanks

What purpose? Which database server/engine? What protocoll to use?
I'm use PostgreSQL, if I would need a task such as you, I would use ecpg - stands for "embedded SQL" - but it works "duplex" only the servers are the same!

Thank for reply

I need to transfer database record from MySQL server on a Windows 2000 Server platform at US to another remote database server PostgreSQL on linux server which at UK.

Therefore I need programming library (API) or some database middleware that help me to accomplish such task.

Best if someone can provide some tutorial or open source library in C/C++ cause I'm more familiar with C/C++ programming language.

Thank

i think you would need a method to export to a different database.

in another life,... we were transferring from visual intercept to bugzilla (ms-access to mysql).

i would suggest exporting to a portable format (i.e.- csv). the programs you want to play around with are mysqldump/ mysqlimport.

how about using database middleware such as ODBC, OLE DB or ADO?

Thank

that might work. i dont beleive in using proprietory file formats and thence i dont have any experience with those.

are you able to get a backup of the mysql database ?

looking at the mysqlclient manpage, mysqlclient is able to populate tables from antother database via the internet.

If you use an export/import methodology, that'd enable you to re-try if it all goes pear shaped, plus you can send the file to other places.
If I wanted to do it in real-time ie effectively streamed, I'd use Perl, which can have multiple Db handles on different systems open at the same time.

good point; i assumed a nightly sync.