• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 68
  • Last Modified:

ER diagram

Need to reverse engineer SQL Server database to create ER Diagram so user can view it without the software. so I am looking at html export or something similar.

Any inexpensive softwares to do so?
0
dreamer123456
Asked:
dreamer123456
  • 3
  • 2
  • 2
1 Solution
 
Bill PrewCommented:
Have you tried using the tool built in to Microsoft SSMS?



»bp
0
 
dreamer123456Author Commented:
Can you export to html or will user need SSMS installed to view it?
0
 
Pawan KumarDatabase ExpertCommented:
>>Can you export to html or
No with this you cannot export to HTML.

>>will user need SSMS installed to view it?
Yes the user needs to Install the SSMS. The ER diagram from the this is not so useful.

I suggest you to go for powerdesigner from SAP.
https://www.sap.com/india/products/powerdesigner-data-modeling-tools.html
Note - I have personally used this, it is free for 30 days and if you request you can extend that for 6 months. It is very easy to use and can be used with any database (RDBMS)
This time should be fine for you to create the diagram and use it. You can also export to HTML and you can also create the data dictionary from this in HTML format.


OR ERWIN.
https://erwin.com/products/data-modeler/
0
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

 
Bill PrewCommented:
You can copy and ER diagram and paste it into Paint and save as an image file.

Or you can print to PDF or XPS.


»bp
0
 
Pawan KumarDatabase ExpertCommented:
>>You can copy and ER diagram and paste it into Paint and save as an image file.
The ER Diagrams are large in size and cannot be fit in the paint. Even there are 10 tables it will not fit. Honestly this method is not useful.
0
 
dreamer123456Author Commented:
Pawan,

Does trial version of SAP powerdesigner have any functional limitations?
0
 
Pawan KumarDatabase ExpertCommented:
No I dont think so.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now