rds-sqlserver-versions.sh

gistfile1.txt

#!/bin/bash

min_version="16.00.4236.2.v1"

aws rds describe-db-engine-versions \
  --filters Name=engine,Values=sqlserver-ee,sqlserver-se,sqlserver-ex \
  --query "DBEngineVersions[?starts_with(EngineVersion, '16')].[Engine,EngineVersion]" \
  --output text |
while read -r engine version; do
  if [ "$version" != "$min_version" ] &&
     [ "$(printf '%s\n' "$min_version" "$version" | sort -V | tail -n 1)" = "$version" ]; then
    printf '%s\t%s\n' "$engine" "$version"
  fi
done