Thread: Database to Database Transfer?

  1. #1
    Registered User
    Join Date
    Jul 2005
    Posts
    39

    Question 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

  2. #2
    Crazy Fool Perspective's Avatar
    Join Date
    Jan 2003
    Location
    Canada
    Posts
    2,640
    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?

  3. #3
    Registered User
    Join Date
    Jul 2005
    Posts
    39
    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

  4. #4
    Sasquatch mog's Avatar
    Join Date
    Dec 2006
    Location
    Caves of Narshe
    Posts
    16
    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

  5. #5
    Crazy Fool Perspective's Avatar
    Join Date
    Jan 2003
    Location
    Canada
    Posts
    2,640
    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.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. literature database: help with planning
    By officedog in forum C++ Programming
    Replies: 1
    Last Post: 01-23-2009, 12:34 PM
  2. Creating a database
    By Shamino in forum Game Programming
    Replies: 19
    Last Post: 06-10-2007, 01:09 PM
  3. Header File Question(s)
    By AQWst in forum C++ Programming
    Replies: 10
    Last Post: 12-23-2004, 11:31 PM
  4. Do I have a scanf problem?
    By AQWst in forum C Programming
    Replies: 2
    Last Post: 11-26-2004, 06:18 PM
  5. Creation of Menu problem
    By AQWst in forum C Programming
    Replies: 8
    Last Post: 11-24-2004, 09:44 PM