I have a Database backup and for lack of documentation I need to generate the MER of it. I remember reading somewhere that there are programs that do this reverse engineering and generate MER.
Could you help me with this?
I have a Database backup and for lack of documentation I need to generate the MER of it. I remember reading somewhere that there are programs that do this reverse engineering and generate MER.
Could you help me with this?
This the SQL Server MAnagemnet Studio itself generates.
1) Open SQL SERVER Management Studio
2) Connect to the desired database.
3) In Object Explorer, expand the Databases folder in the tree - > Name of your database - > Database diagrams.
4) If you do not have any, right click on Database Diagrams, and New Database Diagram ...
5) Then just choose the tables that you want to appear in the diagram and leave the hug.