split into a resource that doesn't create the db

[drdamour]

this would have more utility IMO if it didn't have to provision the db as well. It could be triggered similar to the null providers triggers

[patpicos]

implementation piece:

variable "db_server_fqdn" {
  description = "Full qualified domain name of the database sever. The server where to create the database. In the form xxxx.database.windows.net"
  type        = string
}

variable "db_name" {
  description = "The name of the database to run the seed script against."
  type        = string
}

variable "sql_admin_username" {
  description = "The administrator username of the SQL Server to use for launching the seed script."
  type        = string
}

variable "sql_admin_password" {
  description = "The administrator password of the SQL Server to use for launching the seed script."
  type        = string
  sensitive   = true
}

variable "init_script_file" {
  description = "SQL Script file name to seed the database. Example: db-init.sql."
  type        = string
}

resource "null_resource" "seed" {
  provisioner "local-exec" {
    environment = {
      SQLCMDPASSWORD = var.sql_admin_password # Required so that the password does not spill to console when the resource fails
    }
    command = "sqlcmd -U ${var.sql_admin_username} -S ${var.db_server_fqdn} -d ${var.db_name} -i ${var.init_script_file}"
  }
}

[patpicos]

Note: i dropped the log file piece. it wasnt working for me in TF 1.5.x

[drdamour]

for sure i can use the null resource but the beauty of a dedicated resource is the way it tracks changes and executes and eventually doesn't require sql cmd