DewDrop is an open-source framework that generates source code to support any entity-relationship data model. In practical terms: it generates SQL DDL (Data Definition Language, a.k.a. Database Definition Language) for any database.
DewDrop allows you to define your entity-relationship database just once in XML in the form of SQLML, regardless of what database(s) you might want to use. In doing so, you are freed from knowing database-specific DDL for any of these databases.
DewDrop provides its own standards-based, easily understandable XML DDL for you, otherwise known as SQLML. No more worrying about "Does rdbms-X support foreign-keys? or What is the syntax that rdbms-Y uses for adding a table constraint?"
All you have to do is define your tables and their relationships in SQLML, and DewDrop takes care of all the nasty details. You tell DewDrop what target database(s) you want to use, and it generates clean, human-readable SQL DDL code for your target.
If you like, you don't even have to look at the SQL; you can just have DewDrop install the generated database for you automatically and be on your way developing your application. That's it...no more worrying about how to port (or even worse, completely rewrite) your datamodel to other databases.
Here are some key features of "DewDrop":
· Define a database generically.
· Support multiple database vendors.
· Simplify database definitions.
· Eliminate numerous vendor-specific files.
· Propagate design changes from a single location.