question

WelchJDSYSTEMSSRARCHITECT-3891 avatar image
0 Votes"
WelchJDSYSTEMSSRARCHITECT-3891 asked WelchJDSYSTEMSSRARCHITECT-3891 commented

Upgrading On Prem SQL Server 2014 to Azure

We have an application that is running on SQL Server 2014 on-prem, and we are planning to move it to Azure ("the cloud") and upgrade it to v2019. Are there any compatibility issues with doing this? Areas of interest include, but are not limited to:

  • Stored Procedures

  • Triggers

  • 3rd Party Tools

  • DDL

  • DML

This system is 25+ years old, and we need to get it onto SQL Server 2019 on Azure, and want to be sure we are aware of any compatibility issues with doing so.

Thanks,
J.D.





sql-server-migration
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

You can use the [MS Data Migration Assistant][1] to validate & check your databases for possible issues in front of migration and also for the migration process itself, download at [Microsoft® Data Migration Assistant v5.4][2]

3rd Party Tools

Here you have to ask the 3rd party software vendor if there product supports Azure solution; no one else can say.

[1]: https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15
[2]: https://www.microsoft.com/en-us/download/details.aspx?id=53595


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.

Yufeishao-0810 avatar image
0 Votes"
Yufeishao-0810 answered WelchJDSYSTEMSSRARCHITECT-3891 commented

Hi @WelchJDSYSTEMSSRARCHITECT-3891

You can try using DMA to help you detect compatibility issues. The Data Migration Assistant provides seamless assessments of SQL Server on-premises and upgrades to later versions of SQL Server or migrations to SQL Server on Azure VMs or Azure SQL Database. Maybe it can meet your needs
https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15

· 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.