11/12/2018

Azure SQL Database Managed Instance Mimics Enterprise SQL Server in the Cloud

Here's a feature on Azure Portal that allows easy porting of existing databases from On-Premise to Azure SQL Database Managed Instance .

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance







Here's a demo on the tasks required to port an On-Premise database to Azure SQL Database Managed Instance:

https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-managed-instance

It's a great offering for organizations to "lift and shift" existing databases to Azure with minimal impact, yet provide many of the great features from Azure.  Using VNET your data is security in transit.  Active Directory integration and private IP address' included as well.  There's also a Data Migration utility within Azure to port your data seamlessly.

To summarize, Azure SQL Database Managed Instance is the closest thing to Enterprise SQL Server On-Premise available today.