MSSQL

MSSQL lets you build intelligent, mission-critical applications using a scalable, hybrid database platform that has everything built-in from in-memory performance and advanced security to in-database analytics.

You can easily add it to your Lando app by adding an entry to the services top-level config in your Landofile.

services:
  myservice:
    type: mssql

Supported versions

• 2019-latest
• 2017-latest (default)
• custom

ARM-Chip Macs Require Rosetta Emulation!

There is a bug in the image when emulated by M1 (or other ARM-chip) Macs. Until Microsoft releases an ARM-native version of the image, you should turn on the setting "Use Rosetta for x86/amd64 emulation on Apple Silicon" in the "Features in Development" section of your Docker Desktop settings.

Patch versions

This service does not support patch versions but if you really need something like that, you could consider using either a custom compose service or a service overrides.

Custom Installation

This plugin is included with Lando by default. That means if you have Lando version 3.0.8 or higher then this plugin is already installed!

However if you would like to manually install the plugin, update it to the bleeding edge or install a particular version then use the below. Note that this installation method requires Lando 3.5.0+.

# Ensure you have a global plugins directory
mkdir -p ~/.lando/plugins

# Install plugin
# NOTE: Modify the "yarn add @lando/mssql" line to install a particular version eg
# yarn add @lando/mssql@0.5.2
docker run --rm -it -v ${HOME}/.lando/plugins:/plugins -w /tmp node:14-alpine sh -c \
  "yarn init -y \
  && yarn add @lando/mssql --production --flat --no-default-rc --no-lockfile --link-duplicates \
  && yarn install --production --cwd /tmp/node_modules/@lando/mssql \
  && mkdir -p /plugins/@lando \
  && mv --force /tmp/node_modules/@lando/mssql /plugins/@lando/mssql"

# Rebuild the plugin cache
lando --clear

# @TODO
# @NOTE: This doesn't actaully work yet
hyperdrive install @lando/mssql

You should be able to verify the plugin is installed by running lando config --path plugins and checking for @lando/mssql. This command will also show you where the plugin is being loaded from.