We are using a MS SQL Server database and we want to create a database diagram for an existing database.
There were several options on how to do this: In Microsoft Visio 2010, Visual Studio 2013 or even in SQL Server directly.
We are now using Visio 2016 Professional, Visual Studio 2015 Enterprise and Visual Studio 2017 Enterprise and SQL Server 2014. In Visio, the support is gone, only in the Office365 Version there is an extra add-in.
In VisualStudio, the database project works different and the diagram option is now missing (there is a kind of a work-around when creating an Entity Framework digram, but still not what I am looking for)
In Microsoft SQL Server I can create a digram, but every change there will immediately the database directly.
I need a designer to create and save drafts, such as it used to be in Visio 2010.
Any recommendations?