Database Software

Hi,

This thread to have your opinion on how to export data from tables to an xml file containing the data and an another one (xsd) containing the table's structure.
For instance i have a datamart with a fact table and 3 dimensions. The idea is to have an xml file with the fact table's data, a xsd file with the structure of the fact table, a xml file which will contain the data of the 3 dimensions, and a xsd file which will contain the definition of the all 3 dimensions. So one xml file for the fact table, one xml file gathering all the dimension, one xsd file for the fact table and one xsd file regrouping all the dimension.

I do ever have an idea on how to do it, but i would like to have any of your advises on the way you would do it.

Thanks by advance.