Comparable version of AzureSQL PaaS with SQLServer on VM/On-Prem

grajee 341 Reputation points
2020-11-23T19:41:53.28+00:00

All,

We are in the process of migrating SQLServer 2012 databases onto AzureSQL PaaS. I was thinking of setting up a comparable/compatible edition of SQLServer On-Prem onto which we can migrate the data and then eventually copy (bacpac) the data to AzureSQL PaaS.

Which edition of SQLServer can I possible install (SQLServer 2014,SQLServer 2016, SQLServer 2017,SQLServer 2019)?

Thanks,
grajee

SQL Server on Azure Virtual Machines
Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,702 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 100.9K Reputation points MVP
    2020-11-23T22:40:09.66+00:00

    Is the question which edition that is comparable with Azure SQL Database? I would guess it is SQL 2019 Enterprise (unless you are aiming for Basic Edition.) But keep in mind no matter the version there is not a 100% parity.

    Then again, for the task you describe, you could go with SQL 2012 Standard as well. I am not really sure that I understand the motive for the question.

  2. CathyJi-MSFT 21,086 Reputation points Microsoft Vendor
    2020-11-24T02:51:40.11+00:00

    Hi @grajee ,

    You can use SQL server 2019 Enterprise. The latest version of SQL server.

    Azure SQL database supports most on-premises database-level capabilities. The most commonly used SQL Server features are available.
    99. 995% availability guaranteed. If you worry about the compatibility of SQL server, we can use Data Migration Assistant/ Data Migration Service, this is the service/tool that Azure specifically created for migration task. The tool can also perform assessments to identify feature parity and database compatibility issues when moving your SQL Server to any of the available deployment options for SQL Server from on-premises SQL Server to Azure SQL Database. It will present you with a report identifying all those, as well as possible fixes for the different Database Compatibility level available for your chosen target.

    Please refer to Migrate an on-premises SQL Server database to an Azure SQL database and Migrating SQL workloads to Microsoft Azure: Assessment and Migration Tools.

    Best regards,
    Cathy

    If the response is helpful, please click "Accept Answer" and upvote it.