Azure Data Studio (previously known as SQL Operations Studio) is a free tool that you can use to manage SQL Server. It uses a graphical user interface (GUI) that helps you view the various databases and objects within a SQL Server instance. It can run on Windows, macOS, and Linux, and it’s also designed to be used with Azure SQL Database, and Azure SQL Data Warehouse.
Get Azure Data Studio for macOS. Download Azure Data Studio for macOS. To expand the contents of the zip, double-click it. To make Azure Data Studio available in the Launchpad, drag Azure Data Studio.app to the Applications folder. Get Azure Data Studio for Linux. Download Azure Data Studio for Linux by using one of the installers or the tar.gz. In this blog post, I describe the installation process for Azure Data Studio on Mac OSX. I’ve decided to download and install the “insiders build” from GitHub. This version is the most recent one available and includes all the latest bug fixes, enhancements, and fetures. Download the Azure Data Studio zip. Azure Data Studio. The core concept here is to have a development tool that gives you a common framework for working with data, not just SQL data, but CosmosDB and others. Further, a tool that you can run where you work. Do you have a Mac? Use Azure Data Studio. Use Azure Data Studio. Still on Windows with me?
Here I explain how to install Azure Data Studio onto a Mac, then how to use it to connect to SQL Server.
Install Azure Data Studio
To install Azure Data Studio onto your Mac:
- Visit the Azure Data Studio download page, and click the .zip file for macOS
- Once the .zip file has finished downloading, double click it to expand its contents
- Drag the .app file to the Applications folder (the file will probably be called Azure Data Studio.app)
Instructor To install Azure Data Studio on a Mac,we're going to start at the product's download page.And I'll scroll down here, until I find this section.We can see that the current releaseis the November 2018 release at version 1.2.4at the time of this recording.Now, for macOS, we only have a single download option,and that's the ZIP file here.Let's go ahead. (PowerShell script problem detection in Azure Data Studio) In Azure Data Studio, you can run a line of a script in the editor by pressing F8. Let's run the complete script. Select all the text of the script and press F8 to execute it. The first line of the script (Connect-AzAccount) will log into your Azure account.
If you use Windows or Linux, the above linked page also includes download files for those platforms, as well as instructions for installing.
Connect to SQL Server
Now that Azure Data Studio is installed, you can use it to connect to SQL Server.
- Launch Azure Data Studio just as you would launch any other application (e.g. from the Launchpad or Applications folder)
- Enter the login credentials and other information for the SQL Server instance that you’d like to connect to: Mine looked like this (based on my SQL Server on a Mac tutorial):
- Server Name: localhost
- Authentication Type: SQL Login
- User name: sa
- Password: reallyStrongPwd123
- Database Name: <default>
- Server Group: <default>
If you use a port other than the default 1433, click Advanced and enter it in the Port field.
Alternatively, you can append it to your server name, with a comma between. For example, if you use port 1400, use
localhost,1400
.Once Azure Data Studio has connected to the SQL Server instance, you’ll be presented with the server dashboard, which looks something like this:
You can now go ahead and create databases, run scripts, and perform other SQL Server management tasks.
Error when Connecting?
If you receive an error when trying to connect, check that SQL Server is in fact running.
The above example connects to SQL Server running on the local machine (localhost refers to the local machine). In our case, the local machine is a Mac.
Therefore, the above steps assume that you’ve already installed SQL Server on your Mac.
If you’ve previously installed SQL Server on your Mac, but you still get a connection error, make sure your Mac has Docker running and you’ve started the SQL Server Docker container.
Below are instructions for launching Docker and starting the Docker container.
Sql Data Studio
Open Docker and Start the Docker Container
- Open Docker just as you would open any other application (e.g. via the Launchpad, Applications folder, etc).
- Once Docker is running, open your Terminal and start the Docker container. It should look something like this:
This starts a previously stopped container called sql_server_demo. This is the name that I gave the container in my SQL Server on a Mac tutorial. You’ll need to modify this command to suit your own container’s name.
What Next?
Now that you’ve installed Azure Data Studio on your Mac, you might be wondering where to start?
Download Azure Data Studio Mac Os
Here’s how to create a database in Azure Data Studio to get you started.
Download Azure Data Studio Mac Download
And here’s how to restore a database using Azure Data Studio, written specifically for the Mac.