question

Vishu-2318 avatar image
0 Votes"
Vishu-2318 asked CarrinWu-MSFT edited

SQL Support

Experts , Which all versions of MS SQL are supported in Azure and does it also follow main stream and extended support for SQL VM migrated to Azure

sql-server-general
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.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

It doesn't matter on which platform you host SQL Server: On-premise, Azure, Amazon or elsewhere, the lifecycle rule always the same way.
See https://docs.microsoft.com/en-us/lifecycle/products/?products=sql-server


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.

Vishu-2318 avatar image
0 Votes"
Vishu-2318 answered CarrinWu-MSFT edited

Thanks , but I read somewhere that MS is giving 3 years extended support beyond the expiry date on Azure for SQL and Windows 2008, hence wanted to confirm

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.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @Vishu-2318,

Welcome to Microsoft Q&A!

May I ask which SQL Server version do you used? I think according to your production environment to choose on prime SQL Server or Azure SQL will good for you.

In addition, SQL Server on Azure VMs is optimized for scenarios where an organization is looking to extend its on-premises deployments to the cloud. Since the SQL Server engine running on an Azure VM is exactly the same as that running on your on-premises environments, it’s easier for organizations to lift-and-shift their SQL workloads to Azure. And Azure SQL Databases do not provide all the features like replication, SQL Server Agent, Linked Servers, etc. Please refer to Azure SQL Database vs SQL Server on Azure VMs to get more information.

If you would like to get more information about migrating SQL Server on Azure VMs to Azure SQL, please refer to Migration guide: SQL Server to Azure SQL Database


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

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.