Note from ToniA

I created this fork because I needed to control an Azure SQL Server 12.0, running Terraform on Azure with Managed Identity. The resource 'mssql_script' is very handy in cleaning and seeding a database with initial data.

ToniA/terraform-provider-mssql is a fork of etinquis/terraform-provider-mssql, which again is a fork of PGSSoft/terraform-provider-mssql:

PGSSoft/terraform-provider-mssql does not work with DefaultAzureCredential, all I get is

DefaultAzureCredential authentication failed
GET http://169.254.169.254/metadata/identity/oauth2/token
--------------------------------------------------------------------------------
RESPONSE 400 Bad Request
--------------------------------------------------------------------------------
***
  "error": "invalid_request",
  "error_description": "Identity not found"
***

etinquis/terraform-provider-mssql connects to the database, but the data resource mssql_database is broken

mssql: USE statement is not supported to switch between databases. Use a new
connection to connect to a different database.

The Terraform provider definition I'm using is

terraform {
  required_providers {
    mssql = {
      source  = "ToniA/mssql"
      version = ">= 0.1.0"
    }
  }
}


provider "mssql" {
  hostname   = "ToniA-db.database.windows.net"
  azure_auth = {}
}

Terraform provider for MS SQL Server

Requirements

Terraform >=1.0.0
MS SQL Server >=2017 or Azure SQL
Go 1.19 (to build the provider)

Building the provider

Clone repository to: $GOPATH/src/github.com/PGSSoft/terraform-provider-mssql

$ cd $GOPATH/src/github.com/PGSSoft/terraform-provider-mssql
$ make install

Acceptance tests

Acceptance tests run MS SQL Server docker container automatically. Make sure you have Docker installed and configured before running the tests (i.e. make sure you're able to run docker run <image>).

To run all tests, including acceptance tests, using Docker MSSQL image:

$ make dockerAccTest

To run all tests, including acceptance tests, using Azure SQL:

$ az login
$ make azureAccTest

To run only unit tests (excluding tests depending on Docker container or Azure SQL):

$ make test

About

The project maintained by software development agency PGS Software. See our other open-source projects or contact us to develop your product.