Need to migrate from SQL 2016 onprem to Azure Synapse or SQL server on VM or MI, which option is best in terms of cost and compatibility. Total database size is around 110GB.

Question

Need to migrate from SQL 2016 onprem to Azure Synapse or SQL server on VM or MI, which option is best in terms of cost and compatibility. Total database size is around 110GB.

Answer 1

Hello @gupta, Utkarsh

The cost-effectiveness of Azure SQL VM, Azure SQL Managed Instance, and Azure Synapse depends on your specific requirements and workloads.

Azure SQL VM provides the most compatibility with on-premises SQL Server deployments and is the most cost-effective option for workloads that require a high degree of customization and control.

Azure SQL Managed Instance is a fully managed PaaS offering that provides high-performance and scalability, with minimal maintenance and management overhead. This option is best suited for workloads that require a high degree of scalability and performance and are not as sensitive to cost.

Azure Synapse is a cloud-native data integration and analytics platform that provides a seamless experience for data integration, data warehousing, and big data analytics. This option is best suited for workloads that require advanced analytics and data integration capabilities and are not as sensitive to cost.

Based on the explanation above, you can make the choice with ease now.
Adding some references that might come handy, please see below

https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/database/sql-server-to-sql-database-guide?view=azuresql
https://learn.microsoft.com/en-us/azure/migrate/common-questions-discovery-assessment#how-do-i-choose-the-assessment-type

Hope this helps!

If this response has answered your query, please 'Accept as Answer' and Upvote using "Thumbs-up" so that the relevancy of this post will improve when anyone in the community search for a similar query

If you have any further questions at all, please let me know in the comments.