Generate database model in XML, is it possible?

[Kramer]

Hi,

I am researching possibility to use EA for enterprise-scale PHP/MySQL project.

My problem is that I need to generate database model in XML from EA model.
I need to have database structure in XML for use with Propel, http://propel.phpdb.org (DTD is available)

I have two questions:

1. As I understand it could be done through exporting XSD and then transforming to XML.
XSD generated from EA database model doesn't contain any attributes at all! E.g. it's not possible to say which fields are KEYs by looking at XSD. XSD only have field name and type.
SQL generated from same model have all attributes. Am I doing something wrong? Or XSD is not the way to generate database XML?
There is option to save Database model as "UML Pattern" Output seem to have all the data. Is it possible to transform it to XML relatively easily?

2. Sorry I never worked with XSD. What tool could be used to transform XSD to XML?  Do I need to write XSL and use XMLSpy or there is another easier way, through EA perhaps?


Thanks.

[thomaskilian]

Just a quick idea would be to change the code generation so you'll receive the right output. But better wait for more suggestions from others, since I'm only a temporary database modeller.

[Oliver Michalski]

Hi,

1. All large databases (Oracle, Microsoft SQL Server, DB2) use XSD for data models.So wrongly the work with XSD cannot be thus

2. XSD has also attributes, Patterns and many other Elementtypes available Read : Eric van der Vlist XML Schema  (O'Reilly)

3. They do not need to write XSL.  XMLSpy can create automatically XML - documents from XSD

Oliver