How can I automate the migration of an existing MySQL database to a newer schema? [more inside]
posted by fightorflight on Aug 6, 2009 - 5 answers

Can anyone recommend some software to help me draw database diagrams the way that I want to draw them...? [more inside]
posted by twine42 on May 15, 2009 - 11 answers

Generating XML documents help? I work with the county health department, and have been asked to come up with a way to create, store and manipulate metadata for various datasets we store internally on a network drive. Basically I think the simplest thing to do is to create an xml file stored in the same directory with any dataset. Preferably I can do this with infopath 2003 or free software, and using the Dublin Core standard for metadata. I've seen the 5 year old answers on Dublin Core Metadata from this Ask, but I need to let my coworkers create the data first, and that mostly covers storage/database solutions. Looking through various DC list archives hasn't been helpful. [more inside]
posted by gryftir on Apr 28, 2009 - 15 answers

How do I make a complex type in Schema that's not "All", "Choice", nor "Sequence"? [more inside]
posted by badstone on Apr 18, 2008 - 8 answers

DATETIME, TIMESTAMP, TIME, DATE. Which should I use for general-purpose date storage in a recent MySQL version? [more inside]
posted by tmcw on Aug 20, 2007 - 16 answers

I'm not a programmer and I need a schema in the worst way. Stylus Studio purports to generate a schema based on xml documents--is this realistic, and if I know sql and html but it stops there, what would it take, ballpark, to get a tech freelancer to do this for me? [more inside]
posted by pessoa on Mar 17, 2007 - 4 answers

Calling all SQL / DBA / code monkey brainiac's! Please help me understand what is happening in this mess .... [more inside]
posted by AllesKlar on Jul 3, 2006 - 8 answers

Is there any central authority or archive for XML DTDs and Schemas? I am thinking of developing an *ML, and would like to know if similar work has already been done, if there are any naming conventions, etc.
posted by signal on Mar 2, 2004 - 4 answers

What's the best way to store Dublin Core metadata? [more inside]
posted by IshmaelGraves on Feb 18, 2004 - 6 answers