If a computer contains side-by-side installations of SSMS, verify you start the correct version for your specific needs. You can see if you have the preview version by going to the Help > About window.

However, if you have a preview version of SSMS 18.x installed, you must uninstall it before installing SSMS 18.11. SSMS 18.x installs side by side with previous versions, so both versions are available for use. The SSMS 18.x installation doesn't upgrade or replace SSMS versions 17.x or earlier. If you have comments or suggestions, or you want to report issues, the best way to contact the SSMS team is at SQL Server user feedback.

If you have a previous GA version of SSMS 18 installed, installing SSMS 18.11.1 upgrades it to 18.11.1.īy using SQL Server Management Studio, you agree to its license terms and privacy statement. SSMS 18.11 is the latest general availability (GA) version. Download SSMSįree Download for SQL Server Management Studio (SSMS) 18.11.1 Use SSMS to query, design, and manage your databases and data warehouses, wherever they are - on your local computer, or in the cloud. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, and build queries and scripts. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. It all depends on whether you expect SQL Server to actually run on macOS, or if you just want to do most of your work there.Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics VS Code, Visual Studio, and Azure Data Studio now run natively on the Mac, so that can work for you too in some scenarios. With SQL Server 2017, you can run SQL Server on Linux, and can even host your own docker container without using Windows at all (I am doing this on my Macs right now - and I wrote about it here). There is also an IDE from JetBrains called DataGrip and I'm sure others I don't know about. You can also, of course, RDP to other machines, use SSMS equivalent clients to connect to another SQL Server running on Windows elsewhere, or install a different platform on the Mac ( such as PostgreSQL). (I haven't tested the latter recently, but last time I tried, it was a disaster - gets great reviews as a VM host on Windows, but not very stable on the Mac.) Otherwise you will need to install virtualization software of some sort, where you install Windows in a VM, and install SQL Server there - I use Parallels Desktop, but there is also VMWare Fusion and Oracle VirtualBox.

No, SQL Server will not run on macOS (it can run on Apple hardware, if you use Boot Camp and boot natively to Windows).

Sql server management studio mac os x