Single Managed Instance with multiple environments

asked 2022-06-15T20:40:41.613+00:00
MIKE82 1 Reputation point

I want to migrate 3 on prem Sql Server environtments (DEV-QA-PROD) to Azure Sql Managed Instance. Every environment has around 10 databases which 350gbs in total. Do I need to create separate Managed instances for each environment (which will triple my cost) or is there any way to manage all environments in 1 single managed instance?

Azure SQL Database
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2022-06-16T03:03:01.457+00:00
    Alberto Morillo 24,631 Reputation points Microsoft MVP

    You won't have to triple your costs as Azure offers up to 57 percent discount for Azure SQL Database/Managed Instance non-production workloads. You can save even more, 65 percent, when you make use of Azure reservations as explained on the same offer.

    Make use of the cross-instance point-in-time restore option in Azure SQL Database Managed Instance to help you refresh your Dev and Test environments with ease as explained here.