How can I import the failover group of my sqlmi to manage it from Terraform?
We have created it from outside our IaC and now we need it to be managed from Terraform so that everything is integrated correctly.
I have been running the following commands but all with errors:
- terraform import -var-file=/home/jenkins/agent/workspace/PHOENIX_PRODUCT/IaC_Import/env/pro.tfvars ‘module.sql_mi[“eastus”].azurerm_mssql_managed_instance_failover_group.failovergroup[0]’ ‘/subscriptions/****/resourceGroups/rg-phoenix2cloud-pro-eastus/providers/Microsoft.Sql/managedInstances/sqlmi-phoenix-pro-001/instanceFailoverGroups/fog-phoenix-eastus?locations=eastus’
Error: ID was missing thelocations
element - terraform import -var-file=/home/jenkins/agent/workspace/PHOENIX_PRODUCT/IaC_Import/env/pro.tfvars ‘module.sql_mi[“eastus”].azurerm_mssql_managed_instance_failover_group.failovergroup[0]’ ‘/subscriptions/****/resourceGroups/rg-phoenix2cloud-pro-eastus/providers/Microsoft.Sql/managedInstances/sqlmi-phoenix-pro-001/instanceFailoverGroups/fog-phoenix-eastus’
Error: ID was missing thelocations
element - terraform import -var-file=/home/jenkins/agent/workspace/PHOENIX_PRODUCT/IaC_Import/env/pro.tfvars ‘module.sql_mi[“eastus”].azurerm_mssql_managed_instance_failover_group.failovergroup[0]’ ‘/subscriptions//resourceGroups/rg-phoenix2cloud-pro-eastus/providers/Microsoft.Sql/managedInstances/sqlmi-phoenix-pro-001/instanceFailoverGroups/fog-phoenix-eastus?locations=eastus’
Error: parsing “/subscriptions/*****/resourceGroups/rg-phoenix2cloud-pro-eastus/providers/Microsoft.Sql/managedInstances/sqlmi-phoenix-pro-001/instanceFailoverGroups” as an ManagedInstanceFailoverGroup ID: the number of path segments is not divisible by 2 in “subscriptions//resourceGroups/rg-phoenix2cloud-pro-eastus/providers/Microsoft.Sql/managedInstances/sqlmi-phoenix-pro-001/instanceFailoverGroups”
Is it possible to import this type of resource? If import is possible how can I import my fog?
Thank you!