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:
- Use the fixed upgrade package instead the official package, that is available for download at http://dnnazureaccelerator.codeplex.com/releases/view/71164#DownloadId=266856
- Apply the following T-SQL script fix after the official upgrade package has been applied
Hope this helps,
David Rodriguez
