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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Artan Hajdari Feb 11 2025

Can someone help me in this case please

1 - 1

Post Details

Added on Oct 21 2024
3 comments
82 views