Posts

Showing posts from May, 2017

MSSQL on Mac

I was inspired to write this simple blog after reading the Microsoft Migrate a SQL Server database from Windows to Linux using backup and restore .This article about how to restore the AdventureWork on Linux, but this blog about MSSQL server 2017 on Mac OS Sierra. MSSQL available as a docker image to install on Mac. If you have Docker installed in your Mac, simple to install with two commands as shown in the http://aka.ms/sqldev site: docker pull microsoft/mssql -server -linux docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=yourStrong(!)Password' -p 1433 : 1433 -d microsoft/mssql -server -linux After the docker installation, login to the doker: docker exec -i -t < CONTAINER ID > /bin/bash Create a new folder “backup” in the “/var/opt/mssql”. If you are not admin run the command sudo su to login as super user. cd /var/opt/mssql/ mkdir backup Your work as admin in the docker is finished. Download the AdventureWork from https://msftdbpro