I notice that Database Diagrams are not supported in SSMS version 18, any idea why, and is there a way to get the same functionality?
And why is the T-SQL debugger gone now?
Asked
Active
Viewed 3.8k times
4 Answers
42
As it was posted at June 11, 2019, to announce that SQL Server Management Studio (SSMS) 18.1 is now generally available, the Database diagrams is back in SSMS 18.1 along side SSBDIAGNOSE.EXE and Integration Services (SSIS)
Original Answer:
The feature is deprecated, you can visit SQL Server Management Studio - Changelog (SSMS) page and read the Deprecated Features in SSMS 18.0.
Deprecated Features
The following features are no longer available in SSMS:
- T-SQL Debugger
- Database Diagrams
- …
Those features are available in earlier versions, you can use one of them a long side with SSMS 18.0
-
Currently, [as described here](https://feedback.azure.com/forums/908035/suggestions/37507828), any diagrams created with V18 will not open again once SSMS is closed. Older diagrams are good. – Uwe Keim Jul 04 '19 at 14:31
23
SQL Server Management Studio 18.1 was just released on June 11th, and it supports Database Diagrams again.
According to this blogpost SQL Server Management Studio (SSMS) 18.1 is now generally available:
Yes, we’ve heard the feedback; Database Diagrams is back.
Here's the SSMS download page.
7
I had the same problem with SSMS 18 (preview 4)
To get the functionality, install a previous SSMS release until the fix comes.
TylerH
- 20,799
- 66
- 75
- 101
Ivan Kukushkin
- 161
- 1
- 2
-
2FYI Be sure to uninstall the newer one before installing the previous. They do not work side by side. – ΩmegaMan Oct 01 '18 at 11:23
-
@ΩmegaMan Actually separate versions of SSMS (17, 18, etc) do work side-by-side, as always. – TylerH Jun 12 '19 at 13:51
-
Understood, at the time it failed for me; maybe it was installed in the same directory (?). Regardless disregard my comment. – ΩmegaMan Jun 12 '19 at 16:01
