Subject RE: [firebird-support] Firebird SQL extract to XML: Possible?
Author Paul Lopez
Hi Sarah,

> Hi all -
> 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.
> So far my attempts have not panned out so I'm turning to you guys to see if
> you have ideas.
> I have IBExpert to work with, but if there is a better tool, I'll gladly look into it.

I do not believe there is any simple way to achieve what you want directly with Firebird yet.

If this is going to be a one-off export to XML, then maybe you could use a tool like IBPump (unfortunately only pumps TO firebird not from) to pump the data to an MSSQL database and then perform the XML Path Queries on there.

Just an idea.