Database Programming (database to database transaction)

johncsl82 · 01-29-2007, 06:51 AM

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

tovis · 01-29-2007, 07:35 AM

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!

johncsl82 · 01-29-2007, 08:06 AM

Quote:

Originally Posted by tovis

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

schneidz · 01-29-2007, 05:00 PM

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.

johncsl82 · 01-30-2007, 05:27 AM

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

Thank

schneidz · 02-01-2007, 04:32 PM

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.

chrism01 · 02-02-2007, 02:41 AM

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.

schneidz · 02-02-2007, 09:20 AM

good point; i assumed a nightly sync.