I'm doing more work with Cayenne lately, and it is pretty spiffy. By using their modeler to reverse engineer our database and save it as the datamap XML file, I wrote a very small Java application that loads that map and then generates the appropriate SQL statements to create that database in both MySQL and Oracle. Papa likes!