generating XML at MySQL/FreeBSD after SQL Server DTS

[Denis]

Hello

I am building new solution for reporting server while migrating from SQL server to FreeBSD/MySQL.
The task is to generate 1 XML file for each of several millions of records.
I was doing it in DTS before, was looping through records, run stored procedure for each record, used FOR XML EXPLICIT command in stored procedure, was getting output into stream and saved to file. So it was simple.

What can be a solution in case MySQL on freeBSD ? It seems that MySQL doesn’t have built-in functionality for generation XML. So it should be done on application side. What API should I use? PHP, Perl or C? Maybe some of them has good functionality for generating custom XML?

Seems that PHP is not good, since it is just scripting language. I just don’t see how it can be implemented. Please, advice.

Thanks
Denis