SQLPro for MSSQL (was SQL Client) is a lightweight TDS client, allowing quick and simple access to Microsoft SQL servers (sqlserver), including those hosted in Azure. This client does not work with MySQL. Please ensure that your server is a Microsoft SQL server.
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). VS Code, Visual Studio, and Operations Studio now run natively on the Mac, so that can work for you too in some scenarios.
Features. Syntax highlighting.
Intellisense. Tab-based interface. Support for executing multiple queries at once. Quick access to tables, columns, and more.
Stored procedure execution SQLPro for MSSQL can be used to connect with the following databases:. Microsoft SQL What's New in SQLPro for MSSQL.
SQLPro for MSSQL (was SQL Client) is a lightweight TDS client, allowing quick and simple access to Microsoft SQL servers (sqlserver), including those hosted in Azure. This client does not work with MySQL. Please ensure that your server is a Microsoft SQL server. Features.
Syntax highlighting. Intellisense. Tab-based interface. Support for executing multiple queries at once. Quick access to tables, columns, and more. Stored procedure execution SQLPro for MSSQL can be used to connect with the following databases:. Microsoft SQL Azure.
Sql Server Management Studio For Mac Os
Microsoft SQL Server 2005. Microsoft SQL Server 2008. Microsoft SQL Server 2008 R2. Microsoft SQL Server 2012.
Microsoft SQL Server 2014. Microsoft SQL Server 2016.
No, SQL Server will not run on macOS (it can run on Apple hardware, if you use Boot Camp and boot natively to Windows). 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, but there is also.
(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.) You can also, of course, RDP to other machines, use to connect to another SQL Server running on Windows elsewhere, or install a different platform on the Mac. There is also and I'm sure others I don't know about. With SQL Server 2017, you can run, and can even host your own docker container without using Windows at all (I am doing this on my Macs right now - )., and now run natively on the Mac, so that can work for you too in some scenarios. 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.
EDIT Recently SQL Server was released for linux. This makes using Docker a viable solution to 'running sql server on mac'. You can find some details on how to do this here:. Old answer If you have a mac and do not want to run a virtual machine, there are a few options. You can grab a and setup an SQL Server instance.
Azure also provides a web based query interface. You could also setup a free account and create an SQL Server instance.
If you need an MSSQL database client which runs on OS X (similar to SSMS) there are a few available. (also available on the ) Note: I am the developer of this app. You can find a review of multiple clients.