We have created a new database in Azure MSSQL using Terraform, which was based on an existing MSSQL database. However, we are encountering an issue when attempting to rename the new database. Instead of renaming the database, it creates a new resource with empty data. We are looking for assistance in resolving this issue. Can someone help us with this problem?
Also we do not want to use terraform null_resource for this task.