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?
dreamer123456Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bill PrewIT / Software Engineering ConsultantCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

Try Now
Bill PrewIT / Software Engineering ConsultantCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.