Skip to Main Content

SQL Developer Web

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORDS 24.3.0.r2620924 Dbactions Datamodeler - how to export datamodels to other schema@pdb ?

PaavoOct 21 2024

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

  1. Apex -SqlWorkshop - Utilities - QuickSql
    1. setup with drops - so db design can be recreated fast
  2. Create database (drops existing objects and recreates them)
  3. (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.
  4. Open SqlDeveloper Web via Apex SqlWorkshop dropdown menu
  5. Open Datamodeler
  6. Open datamodel for the database
    1. refresh objects and/or reinsert them ← this works prettywell
    2. beautify object placings etc.
    3. color objects
    4. add notes
  7. save datamodel
  8. save datamodel
  9. …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

Comments
Post Details
Added on Oct 21 2024
4 comments
284 views