LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Programming (https://www.linuxquestions.org/questions/programming-9/)
-   -   Database Programming (database to database transaction) (https://www.linuxquestions.org/questions/programming-9/database-programming-database-to-database-transaction-523712/)

johncsl82 01-29-2007 05:51 AM

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

tovis 01-29-2007 06: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 07: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 04: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 04:27 AM

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

Thank

schneidz 02-01-2007 03: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 01: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 08:20 AM

good point; i assumed a nightly sync.


All times are GMT -5. The time now is 01:16 PM.