This content has been marked as final. Show 6 replies
You can import data from the data dictionary, and then export it to repository (different db/schema).
But this is the reporting repository i.e. used for reporting purposes, it contains a lot but not entire model.
Reporting repository supports versions for same design/model.
You can give it a try, maybe it will be enough for your needs.
Oracle SQL Developer Data Modeler (SDDM) supports check-in and check-out of Subversion repositories. You could check your model into subversion. Your developers could have readonly access to your Subversion repository, so they could get a copy and modify it, but not check it back into Subverison.
See the "Working with Subversion in Data Modeler" link in:http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html
I have a slide deck from this year's ODTUG conference that has details on capturing database designs. It is free on SlideShare: http://www.slideshare.net/kgraziano/reverse-engineering-an-existing-database-using-oracle-sql-developer-data-modeler
One simple option for sharing the designs it to print the diagrams into PDFs and put them on a file share or SharePpoint etc. Just go to File->Print Diagram -> To PDF File.
I usually break big models into multiple sub view to help readability of the diagrams. The nice thing with a PDF is that you can zoom and navigate around the document making it pretty easy to read. And it prints out nice too.
Thanks for the suggestions, i'm learning how to use the subversion repository.
I have some doubts that I hope you could answer me.
It is possible to view the models stored in the subversion repository with the oracle data modeler viewer?
Is there a way to alter the models stored in the subversion repository, without having to do all those steps, checking out, saving on your computer, alter the model, save that altered model on your computer and finally updating the repository?
Thanks, everyone for the help so far...