Hi, thanks for going through the article. To answer your question, some of the use cases are:
- customers don't want to rebuild SQL MI, but have different subnets for dev and prod environment
- customers environment grows, new SQL MIs are added, and subnet gets full (only empty subnet can be resized). In this case, customers re-shuffle environment and move part of the instances to the new subnet.
- customer environment grows, subnet gets full, and customer has to scale instance vCores (or change some other parameter that requires additional IP addresses, like changing hardware generation or maintenance window)
What is most important is that:
- Instance is online during the operation (except a short failover at the end of operation)
- Connection string remains unchanged after the move