We help IT Professionals succeed at work.

ER diagram

103 Views
Last Modified: 2017-12-05
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

Bill PrewTest your restores, not your backups...
CERTIFIED EXPERT
Expert of the Year 2019
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:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Bill PrewTest your restores, not your backups...
CERTIFIED EXPERT
Expert of the Year 2019
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.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions