Problems publishing DNN-based SQL database to SQL Azure
Last post Dec 29, 2015 04:18 AM by Angie xu - MSFT
Dec 26, 2015 08:42 PM|AussieMark|LINK
I’m getting a bit sick of the inconsistent ability to publish a WebMatrix site built using a SQL database to Azure.
The site is a DNN site created on Azure using the DNN template and downloaded to WebMatrix. WebDeploy must be used as WebMatrix doesn’t support FTP uploading of databases.
I don’t really understand why it won’t publish any more. The message log reads:
“SQL_EXECUTION_FAILURE. Could not drop object 'dbo.Roles' because it is referenced by a FOREIGN KEY constraint.”
There have been no database changes made directly. All changes have been a result of using the DNN design interface.
It sporadically had failures in uploading since being established of which I thought were related to Australia’s woeful ADSL1 network but I’ve also found lately that it won’t update
over 40/9 4G network.
Dec 29, 2015 04:18 AM|Angie xu - MSFT|LINK
Based on my understanding this issue is related to
And I suggest that you can post it in Azure forum where you can get better answers.