Item Description: Exports data from a relational data base as XML
DBIx::XML_RDB - Perl extension for creating XML from existing DBI
datasources. DBIx::XML_RDB comes with the sql2xml tool which
simply dumps a table in a database to an XML file.
Why use DBIx::XML_RDB?
- you want to export the data base data in XML
- you prefer to process the data using XML tools rather than as a table
Why NOT use DBIx::XML_RDB?
- you are not using a DBI-supported data base!
- you want to generate something more complex than
just record oriented XML, with nested structures
for sub-tables for example
my $xmlout = DBIx::XML_RDB->new($datasource,
"ODBC", $userid, $password, $dbname) || die "Failed to make new xmlout";
$xmlout->DoSql("select * from MyTable");
I haven't used DBIx-XML_RDB too often (the first script
I wrote with DBI did exactly the same thing!) but it
looks like the right tool to generate XML out of a