In the previous post I described how I set the basic development environment using Visual Studio Code. You cannot do much application development without a database though, and while there are many options for database connectivity, since this exercise is about using a Microsoft development stack on a Mac, the database of choice is inevitably Sqlserver.
When I started thinking about all these, the only option I had was to install Sqlserver on my Mac in a virtual machine. And this is what I did. I installed Virtualbox with Windows 10 LTBS and in it, I installed Sqlserver. I won’t go through this process as it is not Mac related. The point of interest is the network connectivity for the Virtualbox: in order to be able to talk to the Sqlserver inside it, one needs to use bridged networking.
Also, since we are going to connect to Sqlserver through the network, TCP connectivity must be enabled.
To test the connectivity you can use command line tools, a Mac client like Navicat Essentials for SQL Server or connect directly through the Visual Studio Code.
There is an extension for this: mssql for Visual Studio Code
Like all extensions in VSC it adds a bunch of commands
The extension works from within the editor: you open a document and change the language mode to SQL.
Then you create a connection profile and connect to the Virtualbox Sqlserver. Upon a successful connection the footer of VSC changes to this:
And now the party begins.
In the opened document you type sql commands and execute them running the Execute query command. The results are fetched in another document and the screen splits in two: sql on the left, data on the right.
From this point on, you have all the tools in place to dive into some real development.
connecting to a Virtualbox hosted Sqlserver is not the less resource hungry solution.
After I set the above, Microsoft made a lot a good announcements in the Connect() event. Among them was the release of Sqlserver for Mac though Docker, which promises a lighter solution. The docker container runs Ubuntu linux, so there is no real Sqlserver for Mac. Just a better workaround. But I will leave this for a future post.