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, matt@sergeant.org