|
Replies:
6
-
Pages:
1
-
Last Post:
Nov 3, 2009 3:52 AM
by: veda
|
|
|
Posts:
7
Registered:
11/2/09
|
|
|
|
Data modelling using SQL Navigator
Posted:
Nov 2, 2009 3:27 AM
|
|
|
Hi,
How to do data model with the help of sql navigator?
Is it possible to open .DML file in SQL navigator?
Please clarify these queries.
|
|
|
Posts:
425
Registered:
11/13/06
|
|
|
|
Re: Data modelling using SQL Navigator
Posted:
Nov 2, 2009 4:10 AM
in response to: veda
|
|
|
Hi
If by .DML you mean an text file with DML instrution (aka DML SQL instructions), SQL Nav can open and run it.
Then you can reverse engineering with ER Diagram to get a data model.
SQL Nav has no direct edition/creation of a data model.
Greetings
|
"Walking on water and developing software from a specification are easy if both are frozen"
|
|
Posts:
7
Registered:
11/2/09
|
|
|
|
Re: Data modelling using SQL Navigator
Posted:
Nov 2, 2009 4:57 AM
in response to: veda
|
|
|
Thanks silva.
I have that reverse engineered data model as a .DML file, how to open that file in sql navigator. If you brief me the steps it would be helpful.
|
|
|
Posts:
425
Registered:
11/13/06
|
|
|
|
Re: Data modelling using SQL Navigator
Posted:
Nov 2, 2009 9:04 AM
in response to: veda
|
 |
Helpful |
|
|
File ->new file -> sql script
Open the .DML file
Run it (F9)
Tool->E-R diagram
New ->choose a table and the "depth" (level) you want
|
"Walking on water and developing software from a specification are easy if both are frozen"
|
|
Posts:
7
Registered:
11/2/09
|
|
|
|
Re: Data modelling using SQL Navigator
Posted:
Nov 2, 2009 10:05 PM
in response to: Fsilva
|
|
|
Thanks Fsilva.
Opened the .DML file in navigator, able to see the code.
Tools>>E-RDiagram option is disabled, am not able to run as well; throwing error as no connection. How to view the relationship and ER diagram.
|
|
|
Posts:
425
Registered:
11/13/06
|
|
|
|
Re: Data modelling using SQL Navigator
Posted:
Nov 3, 2009 3:36 AM
in response to: veda
|
|
|
Ops.
I didn't make myself clear...
SQLNavigator is not a modeling tool ...my workaround was to recreated the tables/etc in a database (for that you need a connection) and then make a reverse enginering of getting the E-R from the database.
a list of some modeling tools can be found in http://www.databaseanswers.com/modelling_tools.htm
|
"Walking on water and developing software from a specification are easy if both are frozen"
|
|
Posts:
7
Registered:
11/2/09
|
|
|
|
Re: Data modelling using SQL Navigator
Posted:
Nov 3, 2009 3:52 AM
in response to: Fsilva
|
|
|
Thanks for your reply Silva :)
To which format will you save the generated E-R diagram.
Bcoz the one i have (datamodel/table structure of a database) is in .DML format (generated by sql navigator) and i need to regenerate this again into table structure to find the table structure as well as table relationship. How to proceed?
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
