We have an on premises instance of Sitecore 10.1.1 and want to move the databases from SQL Server on VM to Azure SQL Database. We are leaving the Sitecore sites on VM for now.
A migration blocker in the core database has been reported by the Data Migration Analyzer because the stored procedure 'sp_helpuser' is not supported in Azure SQL Database. What needs to be done so the database can be migrated?
Azure SQL Database currently does not support certain system stored procedures that are available in SQL Server. See the "Impacted Objects" section for the specific unsupported procedures that were referenced. Objects referencing unsupported stored procedures will not work correctly after migrating to Azure SQL Database.
You will need to remove the references to these system stored procedures before migrating to Azure SQL Database.
Object '[dbo].[aspnet_Setup_RemoveAllRoleMembers]' uses procedure 'sp_helpuser', which is not supported in Azure SQL Database. For more details, please see: Line 15, Column 10.