Sql Server For Mac

Posted on by

After the Announcement of .Net Core -v 1.0 back in 2016, it was kind of a relief for most of the .Net Developers( including me ). Developers, who used to rely on Windows Platform to Develop .Net Web Application saw an opportunity to achieve the same using Linux/Mac Platform after the release of .Net Core.

Install sql-cli on a Mac. Once you've installed SQL Server on your Mac, you'll probably want to run some queries. Sql-cli is a command line tool that allows you to run SQL queries right from your Mac's Terminal window. Popular Alternatives to SQL Server Management Studio for Mac. Explore 15 Mac apps like SQL Server Management Studio, all suggested and ranked by the AlternativeTo user community.

Being in the Initial stages, .Net Core was not mature enough to compete with other Web Technologies like PHP or Python which were already platform-independent. Again in 2017, Microsoft announced the new Release of .Net Core( v 2.0 ) which was much more stable than the earlier version.

  1. SQLPro Studio is the Premier application for editing and viewing mysql, postgres, oracle and microsoft sql server databases on mac os x.
  2. Microsoft® ODBC Driver 13.1 for SQL Server® - Windows, Linux, & macOS. Generally, a download manager enables downloading of large files or multiples files in one session. Many web browsers, such as Internet Explorer 9, include a download manager. Stand-alone download managers also are available, including the Microsoft Download Manager.
  3. ODBC drivers that are compatible with Excel for Mac To import data from a database, such as Microsoft SQL Server, you must have an ODBC driver that is compatible with Microsoft Query installed on your computer. Compatible ODBC drivers are available from third-party vendors.

Now developers with the Knowledge and experience in C# or F# can easily develop web application on their favourite Operation System. But the question is –

What about SQL Server?

Unfortunately, Microsoft didn’t make SQL Server Platform-Independent. Instead, Microsoft announced SQL Server 2017 for Linux. Seeing the features and benefits of Docker, Microsoft released the Docker image of “SQL Server 2017 Linux”. With the help of Docker, we can easily run Sql Server and connect our .Net application to it on our Mac.

Now, we are going to see –

  • How to install and run Docker ?
  • How to run Sql Server 2017 on the Docker ?
  • How to Connect to Sql Server 2017 ?

Installing and Running Docker

First step is to Download the Docker For Mac from this link.
To download docker from the docker store, you need to Sign Up/ Login In first. Once you’re logged in, you would be able to see the download (Get Docker) button –

This will download the dmg Image which is default for MAC OS to install application. Installer will ask you to move Docker to your Applications Folder. Once copied, launch Docker and make sure it is running by checking the status in the menu bar.

Running SQL Server using Docker

Docker is up and running. Next step is to Download the Container Image of SQL Server 2017 Linux provided by Microsoft.

Fire your Terminal, and type the following command –

This will download the docker image and once downloaded, type the following command or just copy and paste for now –

SA_PASSWORD= Password For Default sa Account

–name ”Name For the Container”

When you move the cursor over an application, the window will be highlighted. Command for screenshot on mac. Select the active application window you want to capture by moving your cursor.

-p 1433:1433 Port Mapping From Docker Container Port No to Host Port No

This command will –

  • Accept the Agreement License
  • Provide the Password for Default sa Account
  • Provide Port Mapping Details
  • Provide Custom Name for our Container
  • Provide Reference to the Downloaded Docker Image
  • Start the Container
Sql server for machine learning

To see the list of Docker Containers with their statuses, type in the following command . –

As you can see, docker named “mssqlserver” is Up and running and mapped to port no 1433 of the host.

Connecting to SQL Server

Now it’s time to see SQL Server in action. We will be using SQL Operations Studio by Microsoft to connect to SQL Server. Download Operations Studio from this link.
Once downloaded, open the application and connect to the running server. As we Provided same port No (1433) for the container and the host, we can mention the server as localhost,1433

Filling out the other Details –

Server – localhost,1433
Authentication Type – SQL Login
User name – sa
Password – abcd@1234

Password is same which we mentioned earlier while accepting the agreement and launching the container.

Sql Server Macbook

and clicking Connect.

Sql Server 2016 For Mac

We’ll be able to do SQL Operations just like we used to do on Windows Platform. Refer the Following Screenshots.

Free Sql Server For Mac

Creating Tables for the Selected Database

Running Select Command to View the Table Tuples.

Sql Server For Macbook Air

Summary :

In this tutorial, we saw how to install and run Docker. We saw how easy it is to run SQL Server on Mac OS. And Finally, how we can use SQL Operations Studio to visualise the Database and Tables Entries.

Sql Developer Download For Windows 10

Similarly, we can connect our .Net application to the “docker container” running SQL Server using Linux Image.