I have found very very fast way to iterate datamodels and not sure in which OTN forum this posting should go due the way-of-working, but due the question I think this must be correct forum.
Steps for fast datamodelling
- Apex -SqlWorkshop - Utilities - QuickSql
- setup with drops - so db design can be recreated fast
- Create database (drops existing objects and recreates them)
- (Create Apex application to see hiccups in how Apex gets e.g. fields like mambojambo_id, auditcolumns in forms etc. ) – GOTO 1. if lots of problems.
- Open SqlDeveloper Web via Apex SqlWorkshop dropdown menu
- Open Datamodeler
- Open datamodel for the database
- refresh objects and/or reinsert them ← this works prettywell
- beautify object placings etc.
- color objects
- add notes
- save datamodel
- save datamodel
- …export datamodel ???
So how I can get the datamodel and move it to next dev staging environment?
The question is relevant because steps 1.-3. can be repeated in next stage but steps 6. is best done if the model could be copied / exported or singleclick deployed or liquibase versioned there :)
rgrds Paavo