Hi, I am using SQLAzureMW to export the DB from test server to Azure.
When prepping the SQL script file, I get the following errors:
StoredProcedure [dbo].[aspnet_Setup_RemoveAllRoleMembers] -- sp_helpuser is not supported in current version of Azure SQL DatabaseStoredProcedure [dbo].[EntityGetGuidByID] -- SELECT INTO statement is not supported in this version of Azure SQL Database.StoredProcedure [dbo].[EntityGetIDByGuid] -- SELECT INTO statement is not supported in this version of Azure SQL Database.
Has anyone come across similar errors? Can I ignore them?
It seems to have to do with ASP.NET Authentication
A tip is that the easiest way to move a database to Azure is to create a local dacpac file and upload it to a blob storage and then you can through portal create a new database from that dacpac-file.
I've seen that one, the guy has ignored the error :D Probably it's not affecting the application cycle, since the SP might never be called... But, I'll need to put some time to it.