Thanks Paul. It is an ongoing thing and the customer will need to be able to run jobs frequently to export their data into this XML format.

This confirms what I had been thinking was probably the case, so I'll have to do some rethinking about how to go about this.

--- In firebird-support@yahoogroups.com, Paul Lopez <paul.lopez@...> wrote:
>
> 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.
>