XML from XSD Schema's

[SiJP]

As an analyst, I am always keen for other's point of view in how they go about doing things. It's my way of learning.

So here's a situation, which i would appreciate your thoughts on:

You, as an XML developer, are given an XSD by a third party organisation. You've got to Import and Export data from your 'database' using MSXML, conforming to this schema.

At the moment, *my* way of doing this would be to get XMLSpy to generate a sample xml doc, create an XSLT which maps the xml output against fields in my db, and use ADO to transform the database data into a transformed xml doc. And THEN worry about validation.

What methods, or approaches would you use to go from XSD to XML?

With regards,

------------------------
Hit any User to continue

 

[leoliang]

UP!, I have the same questions, Any more comments?

 

[SiJP]

leoliang,

I did find that commercial tools are essential for this task, and the one I use is MapForce (Altova).

This allows you to visually specify a data source (like an MS access Database) and a target such as an XSD. You are then given the option to produce either an XSLT or C# / Java code that does the translation for you!

Good luck,

------------------------
Hit any User to continue

 

[leoliang]

SiJP,

thank you so much. Let me take a look.

Leo