If you use DBeaver Community as your database client on macOS (and you should — it’s the best cross-platform alternative to SQL Server Management Studio), updating is a single command:

brew upgrade --cask dbeaver-community

That’s it. Homebrew handles downloading the latest version and replacing the old one.

Why DBeaver?

DBeaver gives you everything SQL Server Management Studio does, but it runs on Mac and Linux too. It supports virtually every database out there, automatically downloads drivers, and has solid query editing and data visualization built in.