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
SQL Server 2019 Developer is a full-featured free edition, licensed for use as a development and test database in a non-production environment. Download now Express.
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.
SQL Server
To start SQL Developer, go to the sqldeveloperdirectory under the sqldeveloperinstalldirectory, and do one of the following, as appropriate for your operating system: On Linux and Mac OS X systems, run sh sqldeveloper.sh. On Windows systems, double-click sqldeveloper.exe. Oracle SQL Developer is a free IDE that enables users to easily and effortlessly develop and manage Oracle database. To install the application you have to download and extract the 181 MB TAR archive and copy Oracle SQL Developer to the /Applications folder.
Now that Docker has been installed and configured, we can download and install SQL Server 2019.
Check EverythingSql Developer Download For Mac Os 64-bit
Now that we’ve done that, we should be good to go. Let’s go through and run a few checks.
Sql Developer Download For Mac Osx
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.
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).
Oracle Sql Developer For 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.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |