question

Samy-7940 avatar image
0 Votes"
Samy-7940 asked Samy-7940 commented

Challenges in migrating on-prem database to Azure Database/managed instance

Hi All, The common challenge we come across migrating from on-prem database to Azure database/managed instance is schema compatibility and schema conversion., it might includes data type compatibility etc. I would be thankful if you point out to other key considerations and factors that might be potential challenges in the migration. I went through below documentation which didn't clarify enough.

https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-sql-server-configure
https://docs.microsoft.com/en-us/azure/dms/known-issues-troubleshooting-dms

Thanks a lot for your help.

azure-sql-database
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.

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered Samy-7940 commented

The first thing you should do is verify the log rate of your SQL Server instance is too high to consider a migration to an Azure Managed Instance. Nobody does this test and some get surprises once all is migrated. Compare the log rate of your SQL Server instance with the log rate limits for Azure Managed Instance using the procedure outlined in this article.

In addition, perform an assessment using Data Migration Assistant this tool may uncover more challenges for your migration project.

Here you will find more tools to perform assessments and identify blocking points. If you use Data Migration Service (DMS) you will need to open quite some ports to be able to use it, that may be a challenge. maybe a network admin is needed to help on that. DMS is practically the the way to migrate a database in near real-time.



· 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 @AlbertoMorillo, thanks a lot for your reply. The log rate of SQL Server pointer was really great help.

0 Votes 0 ·