Data Studio Download Mac

Posted on by

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.

Here I explain how to install Azure Data Studio onto a Mac, then how to use it to connect to SQL Server.

DataStudio Final Release. After more than a decade as the premier data acquisition, display, and analysis software for high school and university science, DataStudio was superseded by a revolutionary and powerful software package — PASCO Capstone.With its new features this software will make your existing PASCO USB interfaces even more useful and will take. Download Description. IBM Data Studio is a no-charge offering that consists of the Data Studio client. The Data Studio client provides an integrated development environment for instance and database administration, routine and Java application development, and query tuning that can be installed with other IBM software products so that they can share a common environment.

Install Azure Data Studio

To install Azure Data Studio onto your Mac:

  1. Visit the Azure Data Studio download page, and click the .zip file for macOS
  2. Once the .zip file has finished downloading, double click it to expand its contents
  3. Drag the .app file to the Applications folder (the file will probably be called Azure Data Studio.app)

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.

  1. Launch Azure Data Studio just as you would launch any other application (e.g. from the Launchpad or Applications folder)
  2. 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.

Open Docker and Start the Docker Container

  1. Open Docker just as you would open any other application (e.g. via the Launchpad, Applications folder, etc).
  2. 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.

Studio

What Next?

Now that you’ve installed Azure Data Studio on your Mac, you might be wondering where to start?

Here’s how to create a database in Azure Data Studio to get you started.

And here’s how to restore a database using Azure Data Studio, written specifically for the Mac.

Restoring a database is a piece of cake with Azure Data Studio. It’s a similar process to doing it with SQL Server Management Studio. Simply click Restore and follow the prompts.

5.Download and Install Azure Data Studio on Mac and Windows. 6.Model real-world scenarios and write SQL queries across multiple tables. This beginner's course is for you if you want to learn SQL Skills in Mac or Windows. Who this course is for: Anyone who works with data.

This restore process allows you to navigate through the computer’s file system to locate the .bak file. This .bak file contains a backup of the database you want to restore. So when SQL Server restores the database, it’s using the .bak file to do so.

However, if you’re running your SQL Server instance inside a Docker container (which of course, you would be if you’re running SQL Server on Mac or Linux), there’s something you need to be aware of if your backup file is located outside the Docker container.

If the backup file is located outside the Docker container that’s running SQL Server, you’ll need to copy it into the Docker container before you do the restore. Once you’ve copied the .bak file into the Docker container, you can go ahead and use Azure Data Studio to restore the database.

Below I outline all the steps involved.

This tutorial assumes that you’ve installed SQL Server on your Mac using a Docker container, and you’ve installed Azure Data Studio.

I should point out that, even though the examples on this page were done on a Mac, all steps should work on both macOS and Linux.

Download a Sample Database

If you already have your own database .bak file, you don’t need to do this step.

For this tutorial, I’m going to restore the WideWorldImporters sample database. This is a sample database that Microsoft has made available for showing off the various features of SQL Server. In particular, I’ll be using the data warehousing version of the database.

To download the WideWorldImporters sample database .bak file, either go to the WideWorldImporters Github page and find the download link, or you can download the .bak file directly here:

  • WildWorldImportersDW-Full.bak [47.7mb]

Copy the .bak file to the Docker Container

You’ll only need to do this step if your .bak file is located outside the Docker container (which it will be if you just downloaded the WideWorldImporters .bak file).

First, let’s create a folder inside the Docker container:

Now copy the database .bak file into that folder:

Sql Data Studio

This command assumes you’re in the same directory as the .bak file. If not, either change into the directory first using. For example:

or whatever folder it’s in.

Data Studio Download Db2

Why do we need to Copy the .bak File?

The Docker container has its own file system, and it lives kind of independently of your Mac’s file system. So when you try to navigate to the .bak file in Azure Data Studio (in the next step), you’ll find yourself “stuck” inside the Docker container’s file system, with no way of accessing the .bak file on your Mac’s file system. Therefore, we copy the .bak file to the container’s file system first, then we can access it via Azure Data Studio.

Azure Sql Studio

Download Azure Data Studio Mac

Restore the Database

Sql Database Studio

OK, now we can do the actual database restore process.

The following steps assume you’ve already got Azure Data Studio running, and you’ve already connected to SQL Server.

  1. From the Server Dashboard, click the Restore button
  2. At the Restore from heading, select Backup file from the dropdown menu
  3. At the Backup file path heading, click the ellipses (…)
  4. Navigate to the folder, select the .bak file and click OK
  5. Click Restore
  6. The restore might take a minute or two. The Task History will indicate when it’s ready

The database has now been restored.

Data Studio Download Mac Version

Check the Database

You’ll probably want to check that the database has in fact been restored. One way of doing this is to navigate to the database and run a quick query.

Azure Ml Service

Download Azure Data Studio

  1. Click on the Servers icon (top left of the screen)
  2. The database should now be listed under the Databases heading for the applicable server. If not, right click Databases and select Refresh
  3. Use the Azure Data Studio interface to run a query against the database. For example, right-click on the Tables node (after expanding the database) and click Select Top 1000. This automatically runs a query against that table, selecting only the top 1000 results