• Advertisement
  
  
  
• Navicat for SQL Server for Mac OS v.9.1An ideal solution for administration and development which lets you create, edit databases, runSQL queries and connect to remote SQL Server in an easier way. It features an intuitive GUI and offers powerful visual tools such as Query Editor with ...
• Navicat for Oracle for Mac OS v.9.1An ideal solution for Oracle administration and development which lets you create, edit databases, runSQL queries and connect to remote Oracle in an easier way. It features an intuitive GUI and offers powerful visual tools such as Query Editor with ...
• MailFOO for Mac OS v.1.02Checks the size of you original Apple Mail.app store file, runs the unix Vacuum command on it, checks the size again and then reports back to you on the reduction in size. - added a delay between the quit mail command and the run vacuum command to ...
• Java Randomness Test Suite v.0.4Java Randomness Test Suite is a gui application to run randomness tests on random stream resource (file or algorithm). Application can be run in command line. Includes general statistical tests, NIST and DIEHARD ...
• Sqldev v.0.1Front-end for managing JDBC compliant databases. It allows you to create/change database objects, runSQL statements, etc. It also allows you to manage database specific ...
• PyMetrics v.0.8.1PyMetrics produces metrics for Python programs. Metrics include McCabe's Cyclomatic Complexity metric, LoC, %Comments, etc. Users can also define their own metrics using data from PyMetrics. PyMetrics optionally outputs stdout, SQLcommand files ...
• Databrid for Mac OS v.1.6Database tool for Oracle and/or MySql databases that is suited to all levels of users. Databrids core functionality is based around a main set of tabs that allow access to the following areas: SQL Editor, Database Browser, File Processing, ...
• Schweasel command line sql shell v.1.2Schweasel is a platform-independent text shell to access relational databases that support jdbc. You can perform basic sql features such as insert, update, delete, select as well as create, drop tables stored procedures, etc. (similar to ...
• Command Line Tools v.1.0Provides a portable, highly configurable, lightweight command line access to commonly used internet services (see features). Supports any operating system running Java, and can run in curses or a standard console ...

Free download SQLDeveloper SQLDeveloper for Mac OS X 👍. SQLDeveloper 🛠 - Oracle SQL Developer is a free graphical tool that enhances productivity and simplifies database development tasks. SQL Practice PRO for For Mac Windows and PC – Free Download By appformac One of the powerful and strongest apps on the app store is SQL Practice PRO for Mac which is holding the average rating of 4.6.

• PHP SQL Server (MSSQL) Query Analyzer v.0.43Web based tool written in PHP by Luiz Miguel Axcar to build and run queries on a remote or local MSSQL (Microsoft SQL Server). Support for SQL code highlight (!!!), table browser, field browser, TOP records, most used tables, CSV results export, ...
• SQL*PlusPlus v.rcCurrently dead. Web-based SQL client that can connect to any number of databases using JDBC. Provides a clean, simple and fast interface using HTML and Javascript to make it very easy to run common SQL queries. Faster than your average Swing-based ...
• Coherent PDF Command Line Tools v.1.8Professional command line tools for manipulating PDF files. Split, merge, linearize, scale, rotate, crop, encrypt, decrypt, watermark, bookmark, annotate, attach, impose etc. Full manual provided.
• Command Line Copy & Paste for Mac OS v.1.0This bundle of Mac OS X command line applications consists of two simple programs. maccopy and macpaste. These two programs copy or print the text currently from or to the Mac OS X pasteboard. Use these applications in your scripts or any other ...
• Actual ODBC Driver for SQL Server v.2.6The Actual SQL Server ODBC Driver lets you access your companys Microsoft SQL Server database from within Microsoft Excel. You can connect to any database you are authorized to use, and work with the data just like your Windows-using co-workers. All ...
• Barcode Command Line Tool v.1.0Barcode Command Line Tool 1.0 offers you a full featured tool for OS X which is able to create all common linear and 2D area barcodes. The tool can be used directly in the Terminal on the command line but you can also call it from all common ...
• Coherent PDF Command Line Toolkit v.1.4Coherent PDF Command Line Toolkit 1.4 will not make you disappointed because it gives you a wide range of professional, robust tools to modify PDF files manually from the command line.Coherent PDF Command Line Toolkit is an application that will give ...
• DBIx-SQL-Abstract v.0.07DBIx-SQL-Abstract 0.07 offers you a powerful application which provides a convenient abstraction layer to a database. The intention of this module is to join some methods from the DBI and the SQL: Abstract modules, for a convenient and easy ...
• IPhoto To SQL v.1.2iPhoto To SQL is an export plugin for iPhoto that will create an SQL dump file with all picture metadata in addition to creating scaled images and thumbnails. If youve written your own photo gallery software, use this to get your photos and ...
• SQL Power DQguru for Mac OS v.0.9.7An easy-to-use data cleansing and de-duping tool. The user interface puts a strong emphasis on straightforward visualization of your data and processes. It will help you cleanse your data, validate and correct addresses, and identify and remove ...
• SQL Power Wabit for Mac OS v.1.3.2An easy-to-use, all-in-1 Business Intelligence Reporting and Analysis tool. It offers database and business users the ability to perform Ad-Hoc Queries, generate Standard Reports and more. The most intuitive and simplest BI Reporting tool on the ...

• Installing SQLite on your Mac is pretty straightforward. Just follow these steps: Head over to SQlite.org and download the C source code file, named sqlite-autoconf-3130000.tar.gz or similar, from.
• Download SQuirreL SQL Client for Mac 3.9.0 for Mac. Fast downloads of the latest free software!

• Coherent PDF Command Line Tools Professional command line tools for manipulating PDF
• Command Line Copy & Paste for Mac OS This bundle of Mac OS X command line applications consists
• Java Randomness Test Suite Java Randomness Test Suite is a gui application to run
• Command Line Tools Provides a portable, highly configurable, lightweight
• Plait command-line jukebox Plait (pronounced 'play') is a command -line jukebox and
• Navicat for SQL Server for Mac OS An ideal solution for administration and development which
• SQL Power Wabit for Mac OS An easy-to-use, all-in-1 Business Intelligence Reporting and
• Actual ODBC Driver for SQL Server The Actual SQL Server ODBC Driver lets you access your
• MailFOO for Mac OS Checks the size of you original Apple Mail.app store file,
• IPhoto To SQL iPhoto To SQL is an export plugin for iPhoto that will

I previously explained how to install SQL Server on a Mac via a Docker container. When I wrote that, SQL Server 2017 was the latest version of SQL Server, and it had just been made available for Linux and Docker (which means that you can also install it on MacOS systems).

In late 2018, Microsoft announced SQL Server 2019 Preview, and subsequently announced general release in late 2019. The installation process for SQL Server 2019 is exactly the same as for SQL Server 2017. The only difference is that you need to use the container image for SQL Server 2019 instead of the 2017 image. Here I show you how to do that.

Also, if you already have SQL Server 2017 installed, and you want to install SQL Server 2019 without removing the 2017 version, you’ll need to allocate a different port number on your host. I show you how to do that too.

Docker

The first step is to install Docker. If you already have Docker installed you can skip this step (and jump straight to SQL Server).

Docker is a platform that enables software to run in its own isolated environment. Therefore, SQL Server 2019 can be run on Docker in its own isolated container.

1. Install Docker

   To download, visit the Docker CE for Mac download page and click Get Docker.

   To install, double-click on the .dmg file and then drag the Docker.app icon to your Application folder.

2. Launch Docker

   Launch Docker the same way you’d launch any other application (eg, via the Applications folder, the Launchpad, etc).

   When you open Docker, you might be prompted for your password so that Docker can install its networking components and links to the Docker apps. Go ahead and provide your password, as Docker needs this to run.

3. Increase the Memory (optional)

   By default, Docker will have 2GB of memory allocated to it. I’d suggest increasing it to 4GB if you can.

   To do this, select Preferences from the little Docker icon in the top menu:

   Then finish off by clicking Apply & Restart

SQL Server

Now that Docker has been installed and configured, we can download and install SQL Server 2019.

1. Download SQL Server 2019

   Open a Terminal window and run the following command.

   This downloads the latest SQL Server for Linux Docker image to your computer.

   You can also check for the various container image options on the Docker website if you wish.

2. Launch the Docker Image

   Run the following command to launch an instance of the Docker image you just downloaded:

   Just change Bart to a name of your choosing, and reallyStrongPwd#123 to a password of your choosing.

   If you get a “port already allocated” error, see below.

   Here’s an explanation of the parameters:

   -e 'ACCEPT_EULA=Y'

   The Y shows that you agree with the EULA (End User Licence Agreement). This is required.

   -e 'SA_PASSWORD=reallyStrongPwd#123'

   Required parameter that sets the sa database password.

   -p 1433:1433

   This maps the local port 1433 to port 1433 on the container. The first value is the TCP port on the host environment. The second value is the TCP port in the container.

   --name Bart

   Another optional parameter. This parameter allows you to name the container. This can be handy when stopping and starting your container from the Terminal. You might prefer to give it a more descriptive name like sql_server_2019 or similar.

   -d

   This optional parameter launches the Docker container in daemon mode. This means that it runs in the background and doesn’t need its own Terminal window open. You can omit this parameter to have the container run in its own Terminal window.

   mcr.microsoft.com/mssql/server:2019-latest

   This tells Docker which image to use.

   Password Strength

   You need to use a strong password. Microsoft says this about the password:

   The password should follow the SQL Server default password policy, otherwise the container can not setup SQL server and will stop working. By default, the password must be at least 8 characters long and contain characters from three of the following four sets: Uppercase letters, Lowercase letters, Base 10 digits, and Symbols.

   Error – “Port already allocated”?

   If you get an error that says something about “port is already allocated”, then perhaps you already have SQL Server installed on another container that uses that port. In this case, you’ll need to map to a different port on the host.

   Therefore, you could change the above command to something like this:

   In this case I simply changed -p 1433:1433 to -p 1400:1433. Everything else remains the same.

   You may now get an error saying that you need to remove the existing container first. To do that, run the following (but swap Bart with the name of your own container):

   Once removed, you can try running the previous command again.

   Note that if you change the port like I’ve done here, you will probably need to include the port number when connecting to SQL Server from any database tools from your desktop. For example, when connecting via the Azure Data Studio (mentioned below), you can connect by using Localhost,1400 instead of just Localhost. Same with mssql-cli, which is a command line SQL tool.

Check Everything

Now that we’ve done that, we should be good to go. Let’s go through and run a few checks.

1. Check the Docker container (optional)

   You can type the following command to check that the Docker container is running.

   In my case I get this:

   This tells me that I have two docker containers up and running: one called Bart and the other called Homer.

2. Connect to SQL Server

   Here we use the SQL Server command line tool called “sqlcmd” inside the container to connect to SQL Server.

   Enter your password if prompted.

   Now that you’re inside the container, connect locally with sqlcmd:

   This should bring you to the sqlcmd prompt 1>.

3. Run a Quick Test

   Run a quick test to check that SQL Server is up and running. For example, check the SQL Server version by entering this:

   This will bring you to a command prompt 2> on the next line. To execute the query, enter:

   Result:

   If you see a message like this, congratulations — SQL Server is now up and running on your Mac!

   If you prefer to use a GUI to manage SQL Server, read on.

Azure Data Studio

Azure Data Studio is a free GUI management tool that you can use to manage SQL Server on your Mac. You can use it to create and manage databases, write queries, backup and restore databases, and more.

Azure Data Studio is available on Windows, Mac and Linux.

Here are some articles/tutorials I’ve written for Azure Data Studio:

Another Free SQL Server GUI – DBeaver

Another SQL Server GUI tool that you can use on your Mac (and Windows/Linux/Solaris) is DBeaver.

Sql On Mac

DBeaver is a free, open source database management tool that can be used on most database management systems (such as MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, Microsoft Access, Teradata, Firebird, Derby, and more).

Sql Server Mac

I wrote a little introduction to DBeaver, or you can go straight to the DBeaver download page and try it out with your new SQL Server installation.