ER diagram

dreamer123456
dreamer123456 used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Bill PrewIT / Software Engineering Consultant
Top Expert 2016

Commented:
Have you tried using the tool built in to Microsoft SSMS?



»bp

Author

Commented:
Can you export to html or will user need SSMS installed to view it?
Database Expert
Awarded 2016
Top Expert 2016
Commented:
>>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/
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Bill PrewIT / Software Engineering Consultant
Top Expert 2016

Commented:
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
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
>>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.

Author

Commented:
Pawan,

Does trial version of SAP powerdesigner have any functional limitations?
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
No I dont think so.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial