DBIx::XML_RDB creates XML from select statements to DBI datasources.

DBIx::XML_RDB creates XML from select statements to DBI datasources.
It also includes an import utility xml2sql that allows you to copy
data from one database to another.

SYNOPSIS
use DBIx::XML_RDB;
my $xmlout = DBIx::XML_RDB->new($datasource,
"ODBC", $userid, $password, $dbname) || die "Failed to make new xmlout";
$xmlout->DoSql("select * from MyTable");
print $xmlout->GetData;

The format of the XML output is something like this:

<?xml version="1.0"?>
<DBI driver="dbi:Sybase:database=foo">
<RESULTSET statement="select * from Table">
<ROW>
<Col1Name>Data</Col1Name>
<Col2Name>Data</Col2Name>
...
</ROW>
<ROW>
...
</ROW>
</RESULTSET>
<RESULTSET statement="select * from OtherTable">
...
</RESULTSET>
</DBI>

Matt Sergeant, [email protected]