from one database to another

I read somewhere that XML is good "...Where data is to be transmitted from one computer system to a different computer system, the ability of XML to express the logical content and structure of data makes it a more straightforward pipe to build than an Electronic Document Interchange (EDI) pipe."

So how do I go about automatically pulling database data from one system into another database using XML? I don't need a full explantion, just a few clues to get me started.

Thanks!

You could take a look at this tutorial, it only covers pulling the data out of the databse and creating xml with it, and also the code is for php, but it's a start http://www.phpdeveloper.org/tutout.php?num=20

Instead of just outputting to the browser, you could have a script save it as a file, then write a script that uses the file to input the data back into another database.