Monitor your entire network from a single platform. Free 30 Day Trial Now!
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?
Any inexpensive softwares to do so?
Asked:
3
2-
2
1 Solution
>>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/
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/
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
Or you can print to PDF or XPS.
»bp
>>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.
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.
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 Already a member? Login.
Featured Post
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.
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
»bp