MySQL Forums
Forum List  »  Microsoft SQL Server

generating XML at MySQL/FreeBSD after SQL Server DTS
Posted by: Denis
Date: February 03, 2005 06:37PM


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.


Options: ReplyQuote

Written By
generating XML at MySQL/FreeBSD after SQL Server DTS
February 03, 2005 06:37PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.