@amplication/plugin-db-sqlserver

@amplication/plugin-db-sqlserver

Use an MS SQL Server database in the service generated by Amplication.

Purpose

This plugin adds the required code to use MS SQL Server database in the service generated by Amplication. It updates the following parts:

• Updates the datasource on the schema.prisma file
• Adds the required services and variables to docker-compose.yml
• Add the db service to the docker-compose.dev.yml
• Add the required environment variables to .env

Configuration

The plugin uses the parameters configured on the plugin settings page. These settings include: host, port, user, password, dbName

Usage

This plugin integrates with the all default tasks and scripts used by the generated service:

    "seed": "ts-node scripts/seed.ts",
    "db:migrate-save": "prisma migrate dev",
    "db:migrate-up": "prisma migrate deploy",
    "db:clean": "ts-node scripts/clean.ts",
    "db:init": "run-s \"db:migrate-save -- --name 'initial version'\" db:migrate-up seed",
    "prisma:generate": "prisma generate",
    "docker:db": "docker-compose -f docker-compose.db.yml up -d",
    "docker:build": "docker build .",
    "compose:up": "docker-compose up -d",
    "compose:down": "docker-compose down --volumes"