Azure migrate with upgrade

Question

Hi Team,

I am planning to migrate a .Net/SQL Server application to Azure.
Requesting to please reply on below questions -

1. How to find out if OS versions (Web and DB servers), .Net framework and SQL Server version used in above mentioned application is compatible to be migrated to Azure.
2. Once we know that any of above are not compatible to migrating to Azure, are there Azure services which could be used to upgrade them.
3. If there are no Azure services to to be used in #2, what are the best practices to upgrade OS to a new version (of a web or db server), to upgrade .Net app to a new framework version and SQL Server to a new version. Please not after all need to be compatible to Azure.
4. Can you please let me know of a link which shows which OS versions, .Net framework versions and SQL Server versions are not compatible to be migrated to Azure.

Please let me know if any additional information required.

Thanks,
Salil

Answer 1

Please access these tools to get a compatibility report for the Web application. You can also use Azure Data Migration Assistant to get assessment of the databases related to the application. Those tools will help you not only perform an assessment but will assist you on migrating to Azure.

If these tools find obstacles on the migration path, they will let you know, they will also let you know the actions you need to do make the application/database compatible.

Answer 2

Hi @salilsingh-9961 ,
You can use the following order to check the compatibility level of all databases:

SELECT name, compatibility_level  
FROM sys.databases;  

When you get the result, you can contrast the information in the following table to see if your SQL is compatibility:

And let's talk about the version of .Net framework, which is backward compatible. So you just need to make sure your version is the latest then you don't need to worry about it.

Is App Service Migration Assistant/Azure Data Migration Assistant capabilities not available in Azure Migrate Service.

It can be used anyway, and microsoft recommed you to do the test when transfering. DMA is a very useful tool you really can try it.

---

If the answer is helpful,  please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"

Answer 3

Hi @salilsingh-9961 ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.