question

grajee avatar image
0 Votes"
grajee asked Cathyji-msft commented

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

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-generalazure-sql-databaseazure-sql-virtual-machines
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered grajee commented

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I would like to migrate the data & code to AzureSQL PaaS. While I wait for the resources, I was hoping to complete most of my work On-Prem by installation an edition of SQLServer (2014,2016,2017,2019) whose features are most compatible with that of AzureSQL PaaS.

I cannot use SQLServer 2012 (which the database currently is on) due to lack of External tables, full ColumnStore Index ... etc.

Thanks,
grajee

0 Votes 0 ·
Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft commented

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.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @grajee,

Any update for this thread? Did the reply could help you? If the response helped, do "Accept Answer".

Best regards,
Cathy

0 Votes 0 ·