At the present we have to go to each database and manually generate database diagrams, so I want a way to automate this.
Question: Is it possible to generate DB diagram for all SQL databases opened in SSMS ?
Sql-server – Is it possible to generate DB diagram for all SQL databases opened in SSMS
database-diagramssql serverssms
Related Solutions
More Google searching did not help, but after fiddling around with SSMS I managed to figure it out. Thought I'd answer my own question for anyone else who might stumble across this.
To script all of the changes at once, simply right-click a blank area of the diagram and click 'Select All' (or press Ctrl+A). Then right-click one of the selected tables and choose 'Generate Change Script...' at the bottom.
You can change the look of the diagrams a bit, evn though not exactly as shown in your sshot. Under the model menu there are 2 submenus for object and relationship notations:
The result looks then like this:
Best Answer
No it is not possible
You have to go into each database and create database diagrams there