Common Azure Database Migration Issues

Data Migration Assistant helps to assess your on-premise database readiness to migrate to Azure. DMA identifies the compatibility issues and provides the recommendation on alternatives.

Unsupported features:

1. Windows Authentication is not supported on Azure SQL database
2. Service Broker feature is not supported Azure SQL database

Compatibility issues:

1. Deprecated datatypes (TEXT, IMAGE, NTEXT). Alternative varchar(max), nvarchar(max), varbinary(max) 
2. Table hints in indexed view definitions are ignored in compatibility mode