When comparing Microsoft SQL Server Management Studio (SSMS) vs ERBuilder, the Slant community recommends Microsoft SQL Server Management Studio (SSMS) for most people. In the question“What are the best MySQL client applications for Windows?” Microsoft SQL Server Management Studio (SSMS) is ranked 10th while ERBuilder is ranked 11th.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Can work for other databases if Linked Servers are used
Pro Great for SQL Server
Pro Ease of use
Pro Affordable
Very affordable compared to pricey alternatives.
Pro Supports many databases
Pro ER Builder is easy to use and a complete modeling tool
Very interesting tool, powerful and easy to use. Can do reverse and forward engineering, generate SQL script, and more.
Pro Lightweight
Small install size.
Pro Supports Amazon Redshift data modeling
Cons
Con Bloated
SSMS eats up a lot of disk space and memory, but Microsoft seems to have addressed the issue in the newest version, quote "The current size of the bundle is less than half of what SSMS 17.x is (~400 MB). The size will eventually grow a little when the IS components are added back to SSMS, but it should not be as large as it used to be."
https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-changelog-ssms?view=sql-server-2017
Con Doesn't natively support other databases
SSMS is aimed at SQL Server.
Use of Linked Servers will give you some access to query other types of DBs using the tool, but this is a workaround.