LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices

Reply
 
Search this Thread
Old 01-29-2007, 06:51 AM   #1
johncsl82
Member
 
Registered: Nov 2003
Location: Planet Earth
Distribution: Redhat, Gentoo, Mandrake, FreeBSD
Posts: 73

Rep: Reputation: 18
Exclamation 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
 
Old 01-29-2007, 07:35 AM   #2
tovis
Member
 
Registered: Jan 2007
Location: Budapest
Distribution: Debian
Posts: 74

Rep: Reputation: 15
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!
 
Old 01-29-2007, 08:06 AM   #3
johncsl82
Member
 
Registered: Nov 2003
Location: Planet Earth
Distribution: Redhat, Gentoo, Mandrake, FreeBSD
Posts: 73

Original Poster
Rep: Reputation: 18
Talking

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
 
Old 01-29-2007, 05:00 PM   #4
schneidz
Senior Member
 
Registered: May 2005
Location: boston, usa
Distribution: fc-15/ fc-20-live-usb/ aix
Posts: 4,197

Rep: Reputation: 642Reputation: 642Reputation: 642Reputation: 642Reputation: 642Reputation: 642
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.
 
Old 01-30-2007, 05:27 AM   #5
johncsl82
Member
 
Registered: Nov 2003
Location: Planet Earth
Distribution: Redhat, Gentoo, Mandrake, FreeBSD
Posts: 73

Original Poster
Rep: Reputation: 18
how about using database middleware such as ODBC, OLE DB or ADO?

Thank
 
Old 02-01-2007, 04:32 PM   #6
schneidz
Senior Member
 
Registered: May 2005
Location: boston, usa
Distribution: fc-15/ fc-20-live-usb/ aix
Posts: 4,197

Rep: Reputation: 642Reputation: 642Reputation: 642Reputation: 642Reputation: 642Reputation: 642
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.

Last edited by schneidz; 02-01-2007 at 04:35 PM.
 
Old 02-02-2007, 02:41 AM   #7
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.6, Centos 5.10
Posts: 16,324

Rep: Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041
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.
 
Old 02-02-2007, 09:20 AM   #8
schneidz
Senior Member
 
Registered: May 2005
Location: boston, usa
Distribution: fc-15/ fc-20-live-usb/ aix
Posts: 4,197

Rep: Reputation: 642Reputation: 642Reputation: 642Reputation: 642Reputation: 642Reputation: 642
good point; i assumed a nightly sync.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Not really programming, but a Database Question scheidel21 Programming 3 10-15-2006 03:50 PM
LXer: A database solution is more than database software LXer Syndicated Linux News 0 09-25-2006 09:54 AM
Database programming like math? halfpower Programming 4 09-14-2006 08:27 PM
Snort database: Closing connection to database "" Homer Glemkin Linux - Security 2 07-14-2005 07:58 PM
Database programming in C Steve_Taylor Programming 5 10-28-2001 05:27 AM


All times are GMT -5. The time now is 09:06 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration