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
Once we have completed the data modeling project with Oracle SQL Developer Data Modeler, normally we will need to backup the files or future reference or it could be backup and then save it with our team members or superiors.
platform:
1. Oracle SQL Developer Data Modeler
There are 2 ways to backup the data modeling project.
1. With the "Save As..." feature of the data modeler
2. Manual
Steps:
1. With the "Save As..."
a) File > Save As...
b) in the Save Design dialog, browse to the desired backup location (network drive, thumb drive, etc)
c) click Save.
a) in folder explorer, browse to the project directory, eg, C:/users/public/Documents
b) copy [project_name].dmd and [project_name] folder.
c) paste the dmd file and the project folder to the desired location.
* the [project_name] folder is very important as all the tables/entities are kept in this folder.
Done!!
Pleased to find your guide, please keep writing!
ReplyDeleteThis article is attracted to help them in the comprehension of Machine Learning.Data Analytics Courses
ReplyDeletei never know the use of adobe shadow until i saw this post. thank you for this! this is very helpful. Avenue South Residence
ReplyDeletei never know the use of adobe shadow until i saw this post. thank you for this! this is very helpful. The Avenir
ReplyDeletei never know the use of adobe shadow until i saw this post. thank you for this! this is very helpful. midtown modern condo
ReplyDeletei never know the use of adobe shadow until i saw this post. thank you for this! this is very helpful. Clavon Condo
ReplyDeletei never know the use of adobe shadow until i saw this post. thank you for this! this is very helpful. myra condo
ReplyDeletei never know the use of adobe shadow until i saw this post. thank you for this! this is very helpful. One Pearl Bank
ReplyDeleteWe are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work. Hyll On Holland
ReplyDelete
ReplyDeleteVery good points you wrote here..Great stuff...I think you've made some truly interesting points.Keep up the good work.
360digitmg