Sample Rails 6.0 app with SQL Server

This app was created with

rails new wombat -d jdbc

Use the activerecord-jdbc-alt-adapter and jdbc-mssql gem to work with SQL Server

platforms :jruby do
  # Use jdbc as the database for Active Record
  gem 'activerecord-jdbc-alt-adapter', '~> 60.0.0'
  gem 'jdbc-mssql', '~> 0.7.0'
end

Changed database connections settings to

# SQL Server (2012 or higher recommended)
# Ensure to add the right port if you are
# not using the default port 1433

default: &default
  adapter: sqlserver
  encoding: utf8

development:
  <<: *default
  host: localhost
  database: wombat_development
  username: dev
  password: password

test:
  <<: *default
  host: localhost
  database: wombat_test
  username: test
  password: password

production:
  <<: *default
  host: localhost
  database: wombat_production
  username: wombat
  password: <%= ENV['WOMBAT_DATABASE_PASSWORD'] %>

Scaffolded some imaginary pets records:

bin/rails g scaffold category name:string description:text

bin/rails g scaffold pet category:references name:string price:decimal age:integer desexed:boolean description:text