Like RoyalTSX for Mac, this tool also allows for startup programs to run when a connection is made. FreeRDP Another tool from the same repo owner is FreeRDP, a command line tool to start remote desktop sessions. I've been using Oracle SQL Developer since the Microsoft software for SQL Server is not currently available on Mac OS X. It works wonders. I would also recommend RazorSQL or SQLGrinder. RazorSQL 7.4.4 is set of tools for the database in which browser, admin, SQL editor and SQL query tool are main. This tool is design for Mac, Mac x, windows, Solaris and Linux. This application is tested on more than fourteen databases. (For 64-bit Intel Macs, download Java for Mac OS X 10.5, Update 1. For the latest version of Mac OS, use the Software Update feature) - Download the file for OS X on the Downloads page. DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. It is for users and developers wanting to create databases, search, and edit data.
Active5 years, 7 months ago
I am on Windows so SQL server management studio works fine for me. However, my application is hosted and my client needs to make some entries in DB and he has Mac. How can we get over this issue? Is there any MAC option for SSMS?
Thanks!
Jack
JackJack3,2151515 gold badges4949 silver badges100100 bronze badges
closed as off-topic by Kermit, billinkc, Aaron Bertrand, animuson♦Jan 28 '14 at 0:23
This question appears to be off-topic. The users who voted to close gave this specific reason:
- 'Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.' – Kermit, billinkc, Aaron Bertrand, animuson
2 Answers
DbVisualizer is OS independent using java.
Osa EOsa E
I use RazorSQL. It works on OS X, Windows and Linux so you can use one tool across all platforms, if you like.
Chris JChris J
Not the answer you're looking for? Browse other questions tagged sql-serverwindowsmacossql-server-2008ssms or ask your own question.
Active1 year, 5 months ago
Can SQL Server engine express edition be installed on OS X? I use a MacBook at home and would like to use it as a testing/learning platform for SQL Server.
Julien Vavasseur9,39122 gold badges2020 silver badges3838 bronze badges
user33664
4 Answers
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 Parallels Desktop, but there is also VMWare Fusion and Oracle VirtualBox.
(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 SSMS equivalent clients to connect to another SQL Server running on Windows elsewhere, or install a different platform on the Mac (such as PostgreSQL). There is also an IDE from JetBrains called DataGrip and I'm sure others I don't know about.
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. 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.
Free Sql For Mac
Aaron Bertrand♦Aaron Bertrand161k1919 gold badges321321 silver badges526526 bronze badges
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: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-docker.
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 Azure trial and setup an SQL Server instance. Azure also provides a web based query interface.
- You could also setup a Amazon RDS 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.
- SQLPro for MSSQL (also available on the mac app store) [Note: I am the developer of this app].
You can find a review of multiple clients here.
![Sql Sql](/uploads/1/2/6/2/126280050/355471608.jpg)
KyleKyle
The command line tools are also available for Mac. (In case if it helps)https://blogs.technet.microsoft.com/dataplatforminsider/2017/04/03/sql-server-command-line-tools-for-mac-preview-now-available/
Ms Sql Server Mac
John Eisbrener6,45622 gold badges1717 silver badges4444 bronze badges
SoundararajanSoundararajan
Best Sql Tool For Mac
To run SQL on mac, we can run this using docker. Please follow the link below.
Sql Tool For Mac
murarivarmamurarivarma