Agenda:
- Getting started with Oracle SQL developer Data modeler
- How to create relational data model
- How to add Sequence Generator to a table
- Handling M:N relationships
- How to create database view
- Export the data model to DDL
- Backup the modeling project
- Create New Data Dictionary
- Getting started with Oracle SQL developer Data modeler
- How to create relational data model
- How to add Sequence Generator to a table
- Handling M:N relationships
- How to create database view
- Export the data model to DDL
- Backup the modeling project
- Create New Data Dictionary
1. File > Import > Data Dictionary
2. In the Data Dictionary Import Wizard, click the "Add" button
3. in New / Select Database Connection dialog, enter connection details
4. Click Save, and the new Connection added into the list in the left panel.
Done!!
You can also use Dataedo for this. It enables you do document all your SQL Server and Oracle databases in one global repository. It has nice HTML, PDF and Excel exports.
ReplyDeletehttp://dataedo.com
I really like all of the articles, I truly loved, I'd like more info relating to this, simply because it's very good., top 10 boarding school in delhiMany thanks with regard to discussing.
ReplyDelete