0
I have a Database backup and for lack of documentation I need to generate his MER. I remember reading somewhere that there are programs that do this reverse engineering and generate the MER.
Could you help me with that?
1 answer
4
This is what SQL SERVER Managemnet Studio generates.
1) Opens SQL SERVER Management Studio
2) Connects to the desired database.
3) In Object Explorer expands the Databases folder -> Name of your database -> Database Diagrams.
4) If you have none, right click on Database Diagrams, and New Database Diagram...
5) Ai just choose the tables you want to appear in the diagram and go to hug.
Browser other questions tagged sql database sql-server modeling
You are not signed in. Login or sign up in order to post.
Friend he only generates for me the logical model, it would be possible to generate the conceptual model?
– Lucas
Ai think only third party tool. As far as I know there is no Management Studio.
– Joe Torres
@Lucas: "Database Diagrams" generates the diagram with the physical implementation. There is no way to get reliable MER from the database. Replacement keys, for example, can be implemented by DBA and obviously do not exist in MER. Aside from other optimizations that can be implemented in the physicalization.
– José Diz
Vlw for the @Josédiz explanation . I used Power Designer to generate the MER of DB
– Lucas