DNN 6.0 upgrade package fix available for Azure
When trying to upgrade a DotNetNuke instance from 05.06.03 to 06.00.00 on Windows Azure using the official distribution upgrade package, you will encounter the following error:
A detailed view of these erros can be found at http://dnnazureaccelerator.codeplex.com/releases/view/71164#DownloadId=266857
The summary of SQL Azure incompatible issues are:
|
Stored Procedure “GetFile”
|
Deprecated feature 'String literals as column aliases' is not supported in this version of SQL Server.
|
|
Stored Procedure “GetFileById”
|
Deprecated feature 'String literals as column aliases' is not supported in this version of SQL Server.
|
|
Stored Procedure “GetAllFiles”
|
Deprecated feature 'String literals as column aliases' is not supported in this version of SQL Server.
|
|
Stored Procedure “GetFiles”
|
Deprecated feature 'String literals as column aliases' is not supported in this version of SQL Server.
|
|
Creating PK on “PortalLocalization”
|
Table 'PortalLocalization' already has a primary key defined on it.
|
|
Stored Procedure “GetVendorsByEmail”
|
Deprecated feature 'String literals as column aliases' is not supported in this version of SQL Server.
|
|
Stored Procedure “GetBanner”
|
Deprecated feature 'String literals as column aliases' is not supported in this version of SQL Server.
|
You can follow one of these solutions:
Hope this helps,
David Rodriguez