View Design Create Er Diagram In Sql Server Management Studio Example Download Zip Background. Open the sql server management studio. Create database in sql server.
In ssms under the when in sql server management studio with your database diagram opened and created personally i only use the database diagram tool to get a picture of what is there and not to design the database.
From here you paste to mspaint or another image creator and save to. I would suggest try using dbweaver i am using mac and windows both and i was able to download the community edition and logged into my sql server database and was able to. We recommend that you print the er diagram out and stick it to your desk to get familiar with the schema while learning mysql. Open the diagram and right click somewhere in the middle and you'll have there the option to copy diagram to clipboard.