> On Nov 24, 2019, at 11:54 AM, Tom Benedict via 4D_Tech <[email protected]> > wrote: > > To that end, I’m investigating whether there is a way to use the XML file > that 4D creates via the EXPORT STRUCTURE command in a non-4D tool (like SQL > Server Management Studio, MySQL Workbench etc) to create an Entity > Relationship Diagram which I can manipulate and print. > > I have a 4D method which generates a SQL DDL, but it doesn’t include > relations. So now I’m looking at the XML structure file as a possibility. > I’ve tried to work with it in XMLSpy, but I don’t know enough about XSD, XSL, > DTD and XML to make much headway.
Working with the raw structure XML is rather painful, I found it easier to convert it to an object. But if all you want to do is write SQL for an ER modeling tool, I don't see why you need to deal with XML unless you have something that would use the relation names. GET RELATION PROPERTIES is enough to get all the source and target fields in the database. That should be enough to create foreign key references in your SQL export for the modeling tool. John DeSoi, Ph.D. ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
