Subject Re: Firebird SQL extract to XML: Possible?
Author Sarah
I never thought about using PHP, but not a bad idea. Thanks!

--- In, Lester Caine <lester@...> wrote:
> Sarah wrote:
> > I am working with a customer on a project where I need to map their Firebird database data to an xml schema (from another organization) so it can be imported into another database.
> >
> > I've been trying to figure out how Firebird data can be exported to XML and have been striking out. Ideally I'd be able to write the SQL extract to produce XML that is perfectly formatted for what I need like I've been able to do with Oracle and MSSQL Server; however, if I can get it in any form of XML I'll be happy. I can then transform it using XSLT if necessary.
> I'm having to do something similar, but the actual 'demand' for XML has been
> diminishing since it is not the ideal mechanism in many cases. A simple CSV dump
> is much more readily handled cross database, and much of the data that I was
> being supplied as XML has dropped back to simple CSV formats. In many cases,
> Flamerobin provides the dumps that I need without any heavyweight work.
> I'm using PHP to handle all of the user interfacing, and that has some very
> useful tools for handling both CSV and XML as well as being able to talk
> directly to most of the databases, so the question that has already been asked
> is relevant. Is this a one time export, in which case is it really necessary to
> handle it as XML. If this is a process that is to continue, then a more XML
> friendly interface via something like PHP is probably more practical.
> --
> Lester Caine - G8HFL
> -----------------------------
> Contact -
> L.S.Caine Electronic Services -
> EnquirySolve -
> Model Engineers Digital Workshop -
> Firebird -