generator-jhipster-mssql

JHipster module for adding Microsoft SQL capabilities to a generated application.

PLEASE NOTE

As of JHipster v3.12.1, MSSQL is an official choice in the generator! Please use this module only if you are building a project with an older version (<= v3.12.0).

Introduction

This is a JHipster module, that is meant to be used in a JHipster application.

Prerequisites

As this is a JHipster module, we expect you have JHipster and its related tools already installed:

Installing JHipster

This modules requires JHipster >= v3.0.0. If you want to use a lower version, please use v1.0.1 of this module.

Installation

To install this module:

npm install -g generator-jhipster-mssql

To update this module:

npm update -g generator-jhipster-mssql

Usage

To enable MSSQL for your project:

yo jhipster-mssql

Follow These Steps

Add your MSSQL Database Credentials in the application-dev.yml and application-prod.yml files. Simply copying an Azure Connection String (JDBC) and setting your username/password will work.
Make sure your IP and your production environment's IP are in the Allowed IPs for the MSSQL Database.

A docker-compose configuration is generated for you in src/main/docker. Run docker-compose -f src/main/docker/mssql.yml up -d in order to launch a local SQL Server. Running this image requires docker to have more than 3.25GB of RAM.

Notes

This was tested with an Azure-hosted MSSQL database and initial JHipster database settings of MySQL.

You will need to manually add date and autoincrement properties to Liquibase changelogs for any generated entities (copy from the initial changelog). This will change in the next version.

ruddell/generator-jhipster-mssql