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.

Paul.