VitePress

Appearance

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.

yaml
services:
  myservice:
    type: mssql

Supported versions ​

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+.

::: code-group-item LANDO 3.21+

bash
lando plugin-add @lando/mssql

::: ::: code-group-item HYPERDRIVE

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

::: ::: code-group-item DOCKER

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

# Install plugin
# NOTE: Modify the "npm install @lando/mssql" line to install a particular version eg
# npm install @lando/mssql@0.5.2
docker run --rm -it -v ${HOME}/.lando/plugins:/plugins -w /tmp node:18-alpine sh -c \
  "npm init -y \
  && npm install @lando/mssql --production --flat --no-default-rc --no-lockfile --link-duplicates \
  && npm 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

:::

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.