[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: Ref. Translation of ERD to XSD


xsd to erd
Title: Ref. Translation of ERD to XSD
There isn't a single answer because there isn't a single
style or format for ERDs.  You have to pick the source
before you pick the target.   However, if the ERD software
can SaveAs an open format, it is not too difficult.   So the
first problem is figuring out the ERD itself (there are several
kinds of ERDs out there).
 
If you have the original relational implementation, the
job is easy.  The problem is having a source relational description
I use FoxPro so YMMV.
 
A relational system typically has objects that can serialize their internals
into a form that can then be converted into an ERD.  To
do this here, I query the directory for table names, use
the table names to get the table objects to tell me their
fields and other information (eg, datatype), push that into
a tables table and a fields table while building in key
references, then walk these tables and create the ERDs.
I create the XSD just as easily although it won't
be a very sophisticated XSD.  IOW, I stay in table format
so I can use Foxpro scripts to do all the querying and
heavy lifting, then produce the ERD or XSD as an output
from that process.
 
len
-----Original Message-----
From: Jahanshahi, Fariba [mailto:fariba.jahanshahi@e...]
Sent: Monday, September 12, 2005 10:06 AM
To: xml-dev@l...
Subject: Ref. Translation of ERD to XSD

Appreciate your input in advance.

What are the best approaches to convert an ERD to an XSD?

  
Regards,

Fariba Jahanshahi
( phone: +01-972-604-9600
+ mailto:fariba.jahanshahi@e...

Jabber:  fariba.jahanshahi@e...





PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
 

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.


Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.